simple_local_consumer3(1) PgQ consumer that executes query for each row

SYNOPSIS [switches] config.ini


For each event in batch it will execute query, filling event values into it.

Transactionality: query is executed in autocommit mode, completed batch is tracked in local file. It can be switched between nodes in cascaded queue.


Run simple_local_consumer3 --ini to see commented config template.


Following switches are common to all skytools.DBScript-based Python programs.

-h, --help

show help message and exit

-q, --quiet

make program silent

-v, --verbose

make program more verbose

-d, --daemon

make program go background


show commented template config file.

Following switches are used to control already running process. The pidfile is read from config then signal is sent to process id specified there.

-r, --reload

reload config (send SIGHUP)

-s, --stop

stop program safely (send SIGINT)

-k, --kill

kill program immidiately (send SIGTERM)