1 .\" Copyright 2004-2009 by PgPool Global Development Group
2 .\" This man page is subject to the same license as the rest of pgpool.
4 .TH PGPOOL 8 "08 Mar 2009"
5 .\" Please adjust this date whenever revising the manpage.
10 pgpool \- PostgreSQL connection pool daemon
12 \fBpgpool\fR [ \fB\-c\fR] [ \fB\-f config_file\fR ] [ \fB\-F pcp_config_file\fR ] [ \fB\-a hba_file\fR ] [ \fB\-n\fR ] [ \fB\-d\fR ]
14 \fBpgpool\fR [ \fB\-f config_file\fR ] [ \fB\-F pcp_config_file\fR ] [ \fB\-a hba_file\fR ] [ \fB\-m\fR \fI{s[mart]|f[ast]|i[mmediate]}\fR ] \fBstop\fR
16 \fBpgpool\fR [ \fB\-f config_file\fR ] [ \fB\-F pcp_config_file\fR ] [ \fB\-a hba_file\fR ] \fBreload\fR
19 \fBpgpool\fR is a connection pool server for PostgreSQL.
20 \fBpgpool\fR runs between PostgreSQL's client and server.
21 Any PostgreSQL client can connect to \fBpgpool\fR as if it's a real PostgreSQL server.
22 \fBpgpool\fR caches the connection to the PostgreSQL server to reduce the overhead
23 involved in establishing the connection to it.
25 \fBpgpool\fR can also be
26 used with two PostgreSQL servers for fail over purposes. If the first
27 server goes down, \fBpgpool\fR will automatically switch to the secondary server.
29 \fBpgpool\fR is typically started and stopped via system initialization scripts.
34 \fBpgpool\fP [ \fIoptions...\fP ]
35 Starts as a daemon in the background (unless \fB\-n\fR is given).
37 \fBpgpool\fP [ \fIoptions...\fP ] \fBstop\fP
40 \fBpgpool\fP [ \fIoptions...\fP ] \fBreload\fP
41 Reloads the configuration.
46 Sets the path to the \fIpool_hba.conf\fR configuration file (default: \fI@sysconfdir@/pgpool_hba.conf\fR).
49 Clears the query cache.
52 Print lots of debug messages.
55 Sets the path to the \fIpgpool.conf\fR configuration file (default: \fI@sysconfdir@/pgpool.conf\fR).
58 Sets the path to the \fIpcp.conf\fR configuration file (default: \fI@sysconfdir@/pcp.conf\fR).
61 Print a help message and exit.
71 Error messages go to stdout or stderr, which
72 could be piped out to log processors such as
76 To daemonize, explicitly invoke
81 Print version and exit.
85 \fI@sysconfdir@/pgpool.conf\fR
86 Default configuration file
88 \fI@sysconfdir@/pool_hba.conf\fR
89 Host Based Access configuration file
91 \fI@sysconfdir@/pcp.conf\fR
92 PCP commands configuration file
98 Additional information can be found in the \fBpgpool\fR \fIREADME\fR file.