1PGPOOL(8)                   System Manager's Manual                  PGPOOL(8)
2
3
4

NAME

6       pgpool - PostgreSQL connection pool daemon
7

SYNOPSIS

9       pgpool [ -d ] [ -f file ] [ -n ] [ -h ]
10
11       pgpool [ -d ] [ -f file ] [ -m mode ] stop
12
13       pgpool  [  -d  ]  [ -f file ] [ -m mode ] [ -s m[aster] | s[econdary] ]
14       switch
15

DESCRIPTION

17       pgpool is a connection pool server for PostgreSQL.  pgpool runs between
18       PostgreSQL's  client  and server.  Any PostgreSQL client can connect to
19       pgpool as if it's a real PostgreSQL server.  pgpool caches the  connec‐
20       tion to the PostgreSQL server to reduce the overhead involved in estab‐
21       lishing the connection to it.  pgpool can also be used with  two  Post‐
22       greSQL  servers for fail over purposes.  If the first server goes down,
23       pgpool will automatically switch to the secondary server.
24
25       When started without arguments, pgpool starts as a daemon in the  back‐
26       ground.   When  started  with  the  argument stop, pgpool is shut down.
27       With the argument switch, pgpool will switch between  master  and  sec‐
28       ondary  servers.   If  only  one  server  is configured, this will only
29       restart the child processes.
30
31       pgpool is typically  started  and  stopped  via  system  initialization
32       scripts.
33

OPTIONS

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

FILES

56       /etc/pgpool.conf
57              Default configuration file
58

SEE ALSO

60       logger(1), postmaster(1), rotatelogs(8)
61
62       Additional information can be found in the pgpool README file.
63
64
65
66                                  27 Jan 2006                        PGPOOL(8)
Impressum