Scroll to navigation

PGQD(1) PGQD(1)

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

Do not log to stdout
Verbose log
Daemonize process
Send SIGINT to running process to stop it
Send SIGTERM to running process to stop it
Send SIGHUP to running process to reload config
Show help
Show version
Show sample config

CONFIGURATION

Config uses ini file syntax:

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


Options:

Filename to log to. Default: empty.
Filename to store pid, required when daemonizing. Default: empty.
Connect string without dbname= Default: empty.
Startup db to query other databases. Default: template1
Limit ticker to specific databases. Default: empty, which means all database.
Whether to log into syslog. Default: 1
Name to use for syslog. Default: pgqd
How often to check for new databases, in seconds. Default: 60.
How often to flush retry queue, in seconds. Default: 30
How often to do maintentance, in seconds. Default: 120
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