Replication Implementation pg-pool Installation for PostgreSQL Replication.

After Download the pgpool file copy the tar file to home location then  we need to extract that as following.

                            

tar ­xvf pgpool­II pgpool­II­2.3.3.tar.gz

   * After extracting the source tar ball, execute the configure script.

Configure

                              >su

                              > “type the root password”

                              >cd pgpool­II­2.2.3

                              >./configure

                              >make

                              >make install

      will install pgpool­II...

After Installation copy the pgpool.conf and pcp.conf files to

following location

                  /usr/local/etc/

     

Then create the new database like “replicatedb” in both Master and Slave servers:

#/usr/local/pgsql/bin/createdb ­p 9999 ­Ustreamline  replicatedb

Restore the database backup to the replicatedb:

#/usr/local/pgsql/bin/pg_restore ­p 9999 ­Ustreamline  ­v ­Fc ­d

replicatedb  /home/erpsupport/demo.Backup

              

Note: Database's names and their passwords should same in both master and

slave servers.