Pg ctl

From DreamsteepWiki

Usage:

 pg_ctl start   [-w] [-D DATADIR] [-s] [-l FILENAME] [-o "OPTIONS"]
 pg_ctl stop    [-W] [-D DATADIR] [-s] [-m SHUTDOWN-MODE]
 pg_ctl restart [-w] [-D DATADIR] [-s] [-m SHUTDOWN-MODE] [-o "OPTIONS"]
 pg_ctl reload  [-D DATADIR] [-s]
 pg_ctl status  [-D DATADIR]
 pg_ctl kill    SIGNALNAME PID

Common options:

 -D, --pgdata DATADIR   location of the database storage area
 -s, --silent           only print errors, no informational messages
 -w                     wait until operation completes
 -W                     do not wait until operation completes
 --help                 show this help, then exit
 --version              output version information, then exit

(The default is to wait for shutdown, but not for start or restart.)

If the -D option is omitted, the environment variable PGDATA is used.

Options for start or restart:

 -l, --log FILENAME     write (or append) server log to FILENAME
 -o OPTIONS             command line options to pass to postgres
                        (PostgreSQL server executable)
 -p PATH-TO-POSTGRES    normally not necessary

Options for stop or restart:

 -m SHUTDOWN-MODE   may be "smart", "fast", or "immediate"

Shutdown modes are:

 smart       quit after all clients have disconnected
 fast        quit directly, with proper shutdown
 immediate   quit without complete shutdown; will lead to recovery on restart

Allowed signal names for kill:

 HUP INT QUIT ABRT TERM USR1 USR2