Configuring Pgpool-II

4.3.1. Configuring pgpool.conf

pgpool.conf is the main configuration file of Pgpool-II . You need to specify the path to the file when starting Pgpool-II using -f option. pgpool.conf is located at $prefix/etc/pgpool.conf by default.

4.3.2. Running mode of Pgpool-II

There are four different running modes in Pgpool-II : streaming replication mode, master slave mode, native replication mode and raw mode. In any mode, Pgpool-II provides connection pooling, automatic fail over and online recovery. The sample configuration files for each mode are provied. They are located under $prefix/etc . You can copy one of them to $prefix/etc/pgpool.conf .

Those modes are exclusive each other and cannot be changed after starting the server. You should make a decision which to use in the early stage of designing the system. If you are not sure, it is recommended to use the streaming replication mode.

The streaming replication mode can be used with PostgreSQL servers operating streaming replication. In this mode, PostgreSQL is responsible for synchronizing databases. This mode is widely used and most recommended way to use Pgpool-II . Load balancing is possible in the mode. The sample configuration file is $prefix/etc/pgpool.conf.sample-stream .

The master slave mode mode can be used with PostgreSQL servers operating Slony . In this mode, Slony / PostgreSQL is responsible for synchronizing databases. Since Slony is being obsoletd by streaming replication, we do not recommend to use this mode unless you have specific reason to use Slony . Load balancing is possible in the mode. The sample configuration file is $prefix/etc/pgpool.conf.sample-master-slave .

In the native replication mode, Pgpool-II is responsible for synchronizing databases. The advantage for the mode is the synchronization is done in synchronous way: writing to the database does not return until all of PostgreSQL servers finish the write operation. Note, however, read snapshot control is not done and consistent visibility is not guaranteed in the mode. Load balancing is possible in the mode. The sample configuration file $prefix/etc/pgpool.conf.sample-replication .

In the raw mode, Pgpool-II does not care about the database synchronization. It's user's responsibility to make the whole system does a meaningfull thing. Load balancing is not possible in the mode. The sample configuration file $prefix/etc/pgpool.conf.sample .