logo
Free, unlimited AI code reviews that run on commit
git-lrc git-lrc GitHub Install Now We'd appreciate a star git-lrc - Free, unlimited AI code reviews that run on commit | Product Hunt git-lrc - Free, unlimited AI code reviews that run on commit | Product Hunt

pgpool - Pgpool-II main server

Common Options

       These are common options for 3 modes.

       -ahba_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.

       -fconfig_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.

       -Fpc_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.

       -kkey_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.

Description

       the Pgpool-II main server

Name

       pgpool - Pgpool-II main server

Reloading Pgpool-Ii Configuration Files

       Reload configuration file of Pgpool-II. No specific options exist for reload mode. Common options are
       applicable.

pgpool-II 4.6.1                                       2023                                             PGPOOL(8)

Starting Pgpool-Ii Main Server

       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 memqcache_method 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.

               Caution
               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).

Stopping Pgpool-Ii Main Server

       Here are options for the stop mode.

       -mshutdown_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.

Synopsis

pgpool [option...]

       pgpool [option...] stoppgpool [option...] reload

Usages

pgpool runs in 3 modes: start, stop and reload. If none of stop or reload is given, it is assumed that
       "start" is specified.

See Also