PGQD

NAME

pgqd - Maintenance daemon for PgQ

SYNOPSIS

pgqd [-qvd] config

pgqd [-skr] config

pgqd --ini|-h|-V

DESCRIPTION

Runs both ticker and periodic maintenence for all databases in one PostgreSQL cluster.

OPTIONS

	-q		Do not log to stdout
	-v		Verbose log
	-d		Daemonize process
	-s		Send SIGINT to running process to stop it
	-k		Send SIGTERM to running process to stop it
	-r		Send SIGHUP to running process to reload config
	-h		Show help
	-V		Show version
	--ini		Show sample config

CONFIGURATION

Config uses ini file syntax:

[pgqd]
logfile = ˜/log/pgqd.log
pidfile = ˜/pid/pgqd.pid

Options:
logfile

Filename to log to. Default: empty.

pidfile

Filename to store pid, required when daemonizing. Default: empty.

base_connstr

Connect string without dbname= Default: empty.

initial_database

Startup db to query other databases. Default: template1

database_list

Limit ticker to specific databases. Default: empty, which means all database.

syslog

Whether to log into syslog. Default: 1

syslog_ident

Name to use for syslog. Default: pgqd

check_period

How often to check for new databases, in seconds. Default: 60.

retry_period

How often to flush retry queue, in seconds. Default: 30

maint_period

How often to do maintentance, in seconds. Default: 120

ticker_period

How often to run ticker, in seconds. Default: 1

INSTALL

pgqd uses autoconf based build system:

./configure --prefix=/opt
make
make install

Dependencies: libevent, python3-docutils