pgpool pgpool 8 Server Commands pgpool Pgpool-II main server pgpool option pgpool option stop pgpool option reload the Pgpool-II main server pgpool runs in 3 modes: start, stop and reload. If none of stop or reload is given, it is assumed that "start" is specified. These are common options for 3 modes. -a hba_config_file --hba-file=hba_config_file Set the path to the pool_hba.conf configuration file. Mandatory if the file is placed other than the standard location. -f config_file --config-file=config_file Set the path to the pgpool.conf configuration file. Mandatory if the file is placed other than the standard location. -F pc_config_file --pcp-file=pcp_config_file Set the path to the pcp.conf configuration file. Mandatory if the file is placed other than the standard location. -k key_file --key-file=key_file Set the path to the .pgpoolkey file. Mandatory if you use AES256 encrypted password and the file is placed other than the standard location and used. -h --help Print help. Here are options for the start mode. -d --debug Run Pgpool-II in debug mode. Lots of debug messages are produced. -n --dont-detach Don't run in daemon mode, does not detach control ttys. -x --debug-assertions Turns on various assertion checks, This is a debugging aid. -C --clear-oidmaps Clear query cache oidmaps when is memcached. If memqcache_method is shmem, Pgpool-II always discards oidmaps at the start-up time. So this option is not necessary. -D --discard-status Discard pgpool_status file and do not restore previous status. This option is testing purpose only for developers and you should not use it for other purposes. If pgpool_status is accidentally removed, Pgpool-II may go into split-brain (there are multiple primary servers exist). Here are options for the stop mode. -m shutdown_mode --mode=shutdown_mode Stop Pgpool-II. shutdown_mode is either smart, fast or immediate. If smart is specified, Pgpool-II will wait for all clients are disconnected. If fast or immediate are specified, Pgpool-II immediately stops itself without waiting for all clients are disconnected. There's no difference between fast and immediate in the current implementation. Reload configuration file of Pgpool-II. No specific options exist for reload mode. Common options are applicable.