Specify replication delay check user and password.Įnable health check so that pgpool-II performs failover. To allow Pgpool-II to accept all incoming connections, we set listen_addresses = '*'. # cp /etc/pgpool-II/-stream /etc/pgpool-II/nf In this example, we copy the sample configuration file for streaming replication mode. When installing Pgpool-II from RPM, all the Pgpool-II configuration files are in /etc/pgpool-II. Here are the common settings on osspc16, osspc17 and osspc18. The following commands are to enable Pgpool-II and PostgreSQL start on system boot. # firewall-cmd -permanent -zone=public -add-service=postgresql Following is an example for CentOS/RHEL7. When Pgpool-II connects to other Pgpool-II servers or PostgreSQL servers, the target port must be accessible by enabling firewall management softwares. pgpass file in postgres user's home directory and change the permission to 600 on both PostgreSQL servers osspc19 and osspc20. To allow repl user without specifying password for streaming replication and online recovery, we create the. To use the failover and online recovery of Pgpool-II, the settings that allow SSH without password to other servers ( osspc16 - osspc20) are necessary. Assuming that all the Pgpool-II servers and the PostgreSQL servers are in the network of 133.137.174.0/24, and edit pg_hba.conf to enable md5 authentication method.

We use the online recovery functionality of Pgpool-II to setup standby server after the primary server is started.īecause of the security reasons, we create a user repl solely used for replication purpose, and a user pgpool for streaming replication delay check and health check of Pgpool-II. Then we edit the configuration file $PGDATA/nf on osspc19 (primary) as follows.Īrchive_command = 'cp '%p' '/var/lib/pgsql/archivedir/%f''

In this example, we use WAL archiving.įirst, we create the directory /var/lib/pgsql/archivedir to store WAL segments on both PostgreSQL servers ( osspc19 and osspc20). Set up PostgreSQL streaming replication on the primary server. Before you start the configuration process, please check the following prerequisites.

Yum psql