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