==== pgqd

Maintenance daemon for PgQ

:Manual section: 1

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