Sunday, May 22, 2011

0

Important Instructions For Replication using postgres (PGsql), java in fedora machine.

  • Sunday, May 22, 2011
  • ikraninc
  • Share

  • Here we are testing replication using streamline ERP system (One largest ERP system for Garments), Postgrea 8.2, Java , PGPool and Fedora 9. 

    1.  Restarting  Streamline Services:

    When you need to restart Streamline Services you should restart pgpool also.

    Follow below setup to restart steamline services and pgpool

    Step-1: Stop the Streamline Services
    Step-2: Stop the pgpool
    -->pgpool -m fast stop

    Step-3: Start the pgpool
    -->pgpool -n &
    Step-4: Start the Streamline Services


    2.  Restarting  pgpool:

    When you need to restart the pgpool you should follow the same procedure.

    Step-1: Stop the Streamline Services
    Step-2: Stop the pgpool
    -->pgpool -m fast stop
    Step-3: Start the pgpool
    -->pgpool -n &
    Step-4: Start the Streamline Services



    3.  Restarting Master Server:

    If you need to Restart the Master server then do the following procedures
    Step-1: Stop the Streamline Services
    Step-2: Stop the pgpool
    -->pgpool -m fast stop
    Step-3: Stop the postgres service in Master server

    --> su
    -->
    --> su postgres
    --> /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data/ -m fast stop

    Step-4: Then Restart the Master Server Machine
    Step-5: Then start pgostgres services in master and check slave postgres also running
    Step-6: Start the pgpool
    -->pgpool -n &
    Step-7: And Start the Streamline Services

    4.  Restarting Slave Server:
    If you want to Restart the Slave server means do the following procedures
    Step-1: Stop the Streamline Services
    Step-2: Stop the pgpool in mainserver
    -->pgpool -m fast stop
    Step-3: Stop the postgres service in Slave server
    --> su
    -->
    --> su postgres
    --> /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data/ -m fast stop
    Step-4: Then Restart the Slave Server Machine
    Step-5: Then start postgres services in slave and check master postgres also running
    Step-6: Start the pgpool in mainserver
    -->pgpool -n &
    Step-7: And Start the Streamline Services

    5.  If Slave server connection faild due to Network problem or Slave Machine Crashed.
    *  Restart Streamline and Pgpool services in Mainserver.  So that reports will get data from Mainserver.
    *  Once Slave Server ready follow below steps to enable replication.
    Step-1: Stop the Streamline Services
    Step-2: Stop the pgpool
    -->pgpool -m fast stop
    Step-3: Stop the postgres service in Slave server
    --> su
    -->
    --> su postgres
    --> /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data/ -m fast stop

    Step-4: Stop the postgres service in Master server
    --> su
    -->
    --> su postgres
    --> /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data/ -m fast stop

    Step-5: Delete the “data”  folder in slave server
    --> su
    -->
    --> rm -rf  /usr/local/pgsql/data
    Step-6: Then create the “data” folder in slave server
    --> su
    -->
    --> mkdir  /usr/local/pgsql/data
    --> chown postgres /usr/local/pgsql/data

    Step-7: Copy the “data” folder from Master server to Slave server “data” folder through rsync.
    --> su
    -->
    -->  rsync -r -v -d -p -o -g -l root@192.168.0.41:/usr/local/pgsql/data/ /usr/local/pgsql/data/

            “While using rsync to each and every time we need to enter the root    
    password of Main server. “

    Step-8: After Complete the “data” folder copy. Delete the folders from table-spacing drives in Slave server.
    --> su
    -->
    --> rm -rf /d_op_doc/
    --> rm -rf /d_planning/
    --> rm -rf /d_edi_stores/

    Step-9: Then Copy the each table-spacing folders from Master to Slave Machines
    --> su
    -->
    -->rsync -r -v -d -p -o -g -l root@192.168.0.41:/d_op_doc// /d_op_doc
    -->rsync -r -v -d -p -o -g -l root@192.168.0.41:/d_planning// /d_op_doc
    -->rsync -r -v -d -p -o -g -l root@192.168.0.41:/d_edi_stores// /d_op_doc
    Step-10: Start the postgres service in  Master server
    Step-11: Start the postgres service in  slave server
    Step-12: Start the pgpool
    -->pgpool -n &
    Step-13: Start the streamline Services.


    0 Responses to “Important Instructions For Replication using postgres (PGsql), java in fedora machine.”

    Post a Comment