pgpool man page

pgpool — PostgreSQL connection pool daemon


pgpool [ -c] [ -f config_file ] [ -F pcp_config_file ] [ -a hba_file ] [ -n ] [ -D ] [ -d ]

pgpool [ -f config_file ] [ -F pcp_config_file ] [ -a hba_file ] [ -m {s[mart]|f[ast]|i[mmediate]} ] stop

pgpool [ -f config_file ] [ -F pcp_config_file ] [ -a hba_file ] reload


pgpool is a connection pool server for PostgreSQL. pgpool runs between PostgreSQL's client and server. Any PostgreSQL client can connect to pgpool as if it's a real PostgreSQL server. pgpool caches the connection to the PostgreSQL server to reduce the overhead involved in establishing the connection to it.

pgpool can also be used with two PostgreSQL servers for fail over purposes. If the first server goes down, pgpool will automatically switch to the secondary server.

pgpool is typically started and stopped via system initialization scripts.


pgpool [ options... ]
Starts as a daemon in the background (unless -n is given).
pgpool [ options... ] stop
pgpool [ options... ] reload
Reloads the configuration.


-a path

--hba-file path
Sets the path to the pool_hba.conf configuration file (default: /etc/pgpool-II/pgpool_hba.conf).


Clears the query cache.


Print lots of debug messages.

-f path

--config-file path
Sets the path to the pgpool.conf configuration file (default: /etc/pgpool-II/pgpool.conf).

-F path

--pcp-config-file path
Sets the path to the pcp.conf configuration file (default: /etc/pgpool-II/pcp.conf).


Print a help message and exit.

-m mode

--mode mode
Shutdown mode: smart, fast, or immediate.


Foreground mode. Error messages go to stdout or stderr, which could be piped out to log processors such as logger(1) or rotatelogs(8). To daemonize, explicitly invoke pgpool in background.


Discard pgpool_status file and do not restore previous status.


Print version and exit.


Default configuration file
Host Based Access configuration file
PCP commands configuration file

See Also

logger(1), postmaster(1), rotatelogs(8)

Additional information can be found in the pgpool README file.


Explore man page connections for pgpool(8).