Man Linux: Main Page and Category List


       pgpool - PostgreSQL connection pool daemon


       pgpool [ -c] [ -f config_file ] [ -F pcp_config_file ] [ -a hba_file ]
       [ -n ] [ -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


       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_hba.conf).


       --clear-cache Clears the query cache.


       --debug Print lots of debug messages.

       -f path

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

       -F path

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


       --help Print a help message and exit.

       -m mode

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


       --no-daemon 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.


       --version Print version and exit.


              Default configuration file

              Host Based Access configuration file

              PCP commands configuration file


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

       Additional information can be found in the pgpool README file.

                                  12 Oct 2009