Poster of Linux kernelThe best gift for a Linux geek
PGPOOL

PGPOOL

Section: Maintenance Commands (8) Updated: 27 Jan 2006
Local index Up
 

NAME

pgpool - PostgreSQL connection pool daemon  

SYNOPSIS

pgpool [ -d ] [ -f file ] [ -n ] [ -h ]

pgpool [ -d ] [ -f file ] [ -m mode ] stop

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.

When started without arguments, pgpool starts as a daemon in the background. When started with the argument stop, pgpool is shut down. With the argument switch, pgpool will switch between master and secondary servers. If only one server is configured, this will only restart the child processes.

pgpool is typically started and stopped via system initialization scripts.  

OPTIONS

-d
Print lots of debug messages.
-f path
Sets the path to the configuration file (default: /etc/pgpool.conf).
-h
Print a help message and exit.
-m mode
Shutdown mode: smart, fast, or immediate.
-n
Do not start as daemon. Error messages go to stdout or stderr. Thus you could play with utilities such as logger(1) and rotatelogs(8). You need to run in background explicitly if you use this option.
-s m[aster] | s[econdary]
Determines which server to switch away from. If this option is omitted, the master goes down.
 

FILES

/etc/pgpool.conf
Default configuration file
 

SEE ALSO

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

Additional information can be found in the pgpool README file.


 

Index

NAME
SYNOPSIS
DESCRIPTION
OPTIONS
FILES
SEE ALSO

This document was created by man2html, using the manual pages.
Time: 22:02:09 GMT, April 16, 2011