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

NAME

6       pgpool - PostgreSQL connection pool daemon
7

SYNOPSIS

9       pgpool [ -c] [ -f config_file ] [ -F pcp_config_file ] [ -a hba_file ]
10       [ -n ] [ -d ]
11
12       pgpool [ -f config_file ] [ -F pcp_config_file ] [ -a hba_file ] [ -m
13       {s[mart]|f[ast]|i[mmediate]} ] stop
14
15       pgpool [ -f config_file ] [ -F pcp_config_file ] [ -a hba_file ] reload
16

DESCRIPTION

18       pgpool is a connection pool server for PostgreSQL.  pgpool runs between
19       PostgreSQL's client and server.  Any PostgreSQL client can connect to
20       pgpool as if it's a real PostgreSQL server.  pgpool caches the
21       connection to the PostgreSQL server to reduce the overhead involved in
22       establishing the connection to it.
23
24       pgpool can also be used with two PostgreSQL servers for fail over
25       purposes.  If the first server goes down, pgpool will automatically
26       switch to the secondary server.
27
28       pgpool is typically started and stopped via system initialization
29       scripts.
30

INVOCATION

32       pgpool [ options... ]
33              Starts as a daemon in the background (unless -n is given).
34
35       pgpool [ options... ] stop
36              Shutdown.
37
38       pgpool [ options... ] reload
39              Reloads the configuration.
40

OPTIONS

42       -a path
43
44       --hba-file path Sets the path to the pool_hba.conf configuration file
45       (default: /etc/pgpool-II//pgpool_hba.conf).
46
47       -c
48
49       --clear-cache Clears the query cache.
50
51       -d
52
53       --debug Print lots of debug messages.
54
55       -f path
56
57       --config-file path Sets the path to the pgpool.conf configuration file
58       (default: /etc/pgpool-II//pgpool.conf).
59
60       -F path
61
62       --pcp-config-file path Sets the path to the pcp.conf configuration file
63       (default: /etc/pgpool-II//pcp.conf).
64
65       -h
66
67       --help Print a help message and exit.
68
69       -m mode
70
71       --mode mode Shutdown mode: smart, fast, or immediate.
72
73       -n
74
75       --no-daemon Foreground mode.  Error messages go to stdout or stderr,
76       which could be piped out to log processors such as logger(1) or
77       rotatelogs(8).  To daemonize, explicitly invoke pgpool in background.
78
79       -v
80
81       --version Print version and exit.
82

FILES

84       /etc/pgpool-II//pgpool.conf
85              Default configuration file
86
87       /etc/pgpool-II//pool_hba.conf
88              Host Based Access configuration file
89
90       /etc/pgpool-II//pcp.conf
91              PCP commands configuration file
92

SEE ALSO

94       logger(1), postmaster(1), rotatelogs(8)
95
96       Additional information can be found in the pgpool README file.
97
98
99
100                                  12 Oct 2009                        PGPOOL(8)
Impressum