Download pgpool-II user manual

best when searching large-scale data.
Watchdog
PCP commands
Troubleshooting
Restrictions
internal
pgpool-II speaks PostgreSQL's backend and frontend protocol, and relays messages between a backend and a
frontend. Therefore, a database application (frontend) thinks that pgpool-II is the actual PostgreSQL server, and the
server (backend) sees pgpool-II as one of its clients. Because pgpool-II is transparent to both the server and the client,
an existing database application can be used with pgpool-II almost without a change to its source code.
There are some restrictions to using SQL via pgpool-II. See Restrictions for more details.
back to top
[Japanese page]
License
Copyright (c) 2003-2013 PgPool Global Development Group
Permission to use, copy, modify, and distribute this software and its documentation for any purpose and without fee is
hereby granted, provided that the above copyright notice appear in all copies and that both that copyright notice and
this permission notice appear in supporting documentation, and that the name of the author not be used in advertising
or publicity pertaining to distribution of the software without specific, written prior permission. The author makes no
representations about the suitability of this software for any purpose. It is provided "as is" without express or implied
warranty.
back to top
Supported Platforms
pgpool-II works on Linux, Solaris, FreeBSD, and most of the UNIX-like architectures. Windows is not supported.
Supported PostgreSQL server's versions are 6.4 and higher. To use the parallel query feature, however, 7.4 and higher
must be used.
If you are using PostgreSQL 7.3 or older, some features of pgpool-II won't be available. But you shouldn't use such an
old release anyway.
You must also make sure that all of your PostgreSQL servers are using the same major PostgreSQL version. In
addition to this, we do not recommend mixing different PostgreSQL installation with different build options: including
supporting SSL or not, to use --disable-integer-datetimes or not, different block size. These might affect part of
functionality of pgpool-II. The difference of PostgreSQL minor versions is not usually a problem. However we do not test