Sunday, May 22, 2011


Replication Implementation pg-pool Installation for PostgreSQL Replication.

  • Sunday, May 22, 2011
  • ikraninc
  • Share

  • 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.
                                  > “type the root password”
                                  >cd pgpool­II­2.2.3
                                  >make install
          will install pgpool­II...

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


    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.

    0 Responses to “Replication Implementation pg-pool Installation for PostgreSQL Replication.”

    Post a Comment