Rechercher une page de manuel
pgpool
Langue: en
Version: 27 Jan 2006 (fedora - 06/07/09)
Section: 8 (Commandes administrateur)
NAME
pgpool - PostgreSQL connection pool daemonSYNOPSIS
pgpool [ -d ] [ -f file ] [ -n ] [ -h ]pgpool [ -d ] [ -f file ] [ -m mode ] stop
pgpool [ -d ] [ -f file ] reload
pgpool [ -d ] [ -f file ] [ -m mode ] [ -s m[aster] | s[econdary] ] switch
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... ] switch
- Switch between master and secondary servers. If only one server is configured, this will only restart the child processes.
OPTIONS
- -d
- Print lots of debug messages.
- -f path
- Sets the path to the configuration file (default: /etc/pgpool-II//pgpool.conf).
- -h
- Print a help message and exit.
- -m mode
- Shutdown mode: smart, fast, or immediate.
- -n
- 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.
- -s m[aster] | s[econdary]
- Determines which server to switch away from. Default is to drop the master.
- -v
- Print version and exit.
FILES
- /etc/pgpool-II//pgpool.conf
- Default configuration file
SEE ALSO
logger(1), postmaster(1), rotatelogs(8)Additional information can be found in the pgpool README file.
Contenus ©2006-2024 Benjamin Poulain
Design ©2006-2024 Maxime Vantorre