How to run a failover Streaming instance setting with pgpool-II

This is a step by step config of pg-poolII managing two instances of postgreSQL instance. The setup is basically run to provide data to a database server application automatically when one posgreSQL instance goes down. The flow diagram will assist us understand the config process. port 5432 is assigned to the primary server while port 5433 is assigned to the standby server. After installation of … Continue reading How to run a failover Streaming instance setting with pgpool-II