I would like to share the pgpool configuration, and it's failback mechanism in this post. Hope it will be helpful to you in creating pgpool and it's failback setup. Pgpool Installation & Configuration 1. Download the pgpool from below link(Latest version is 3.2.1). http://www.pgpool.net/mediawiki/index.php/Downloads
2. Untart the pgpool-II-3.2.1.tar.gz and goto pgpool-II-3.2.1 directory. 3. Install the pgpool by executing the below commands: ./configure prefix=/opt/PostgreSQL92/ --with-pgsql-includedir=/opt/PostgreSQL92/include/ --with-pgsql-libdir=/opt/PostgreSQL92/lib/ make make install 4. You can see the pgpool files in /opt/PostgreSQL92/bin location. /opt/PostgreSQL92/bin $ ls clusterdb droplang pcp_attach_node pcp_proc_count pcp_systemdb_info pg_controldata pgpool pg_test_fsync pltcl_loadmod reindexdb createdb dropuser pcp_detach_node pcp_proc_info createla...