Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
PGPOOL(8)		    System Manager's Manual		     PGPOOL(8)

NAME
       pgpool -	PostgreSQL connection pool daemon

SYNOPSIS
       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

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

INVOCATION
       pgpool [	options... ]
	      Starts as	a daemon in the	background (unless -n is given).

       pgpool [	options... ] stop
	      Shutdown.

       pgpool [	options... ] reload
	      Reloads the configuration.

OPTIONS
       -a path

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

       -c

       --clear-cache Clears the	query cache.

       -d

       --debug Print lots of debug messages.

       -f path

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

       -F path

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

       -h

       --help Print a help message and exit.

       -m mode

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

       -n

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

       -D

       --discard-status	Discard	pgpool_status file and do not restore previous
       status.

       -v

       --version Print version and exit.

FILES
       /usr/local/etc/pgpool.conf
	      Default configuration file

       /usr/local/etc/pool_hba.conf
	      Host Based Access	configuration file

       /usr/local/etc/pcp.conf
	      PCP commands configuration file

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

       Additional information can be found in the pgpool README	file.

				  12 Oct 2009			     PGPOOL(8)

NAME | SYNOPSIS | DESCRIPTION | INVOCATION | OPTIONS | FILES | SEE ALSO

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=pgpool&sektion=8&manpath=FreeBSD+12.1-RELEASE+and+Ports>

home | help