Re: Which version of postgresql supports replication on RHEL6? - Mailing list pgsql-general

[ Please don't do top posting]

> 20.      cd /usr/local/pgsql/
> 21 .     tar  -czf data.tar.gz        data/

After 21. step, seems you forgot to execute pg_stop_backup() command.

With this, I would recommend you to follow the documentation given below:
http://wiki.postgresql.org/wiki/Streaming_Replication

Thanks & Regards,
Vibhor

On Apr 22, 2011, at 11:08 AM, Tiruvenkatasamy Baskaran wrote:

> Hi Vibhor Kumar,
>
>                   Here is the configuration changes.
> Changes made on Master DB
> -------------------------
> 1.      tar –xzvf   postgresql-9.0.4.tar
> 2.      cd postgresql-9.0.4
> 3.      ./configure
> 4.      gmake
> 5.      su
> 6.      gmake install
> 7.      adduser postgres
> 8.      mkdir -p /usr/local/pgsql/data
> 9.      chown -R postgres /usr/local/pgsql
> 10.     su - postgres
> 11.     /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
>
>         “Modify the following attributes and their values in postgresql.conf as follows”
>         ------------------------------------------------------------------------------
> 12.     vi  /usr/local/postgres/data/postgresql.conf
>
> listen_addresses = '*'
> max_connections = 500
> shared_buffers = 32MB
> wal_level = hot_standby
> archive_mode = on
> archive_command = 'cp %p /usr/local/pgsql/data/pg_xlogarch/%f'
> max_wal_senders = 1    ####( this setting for  1 slave can connect with Master)
> wal_keep_segments = 32
> datestyle = 'iso, mdy'
> lc_messages = 'en_US.UTF-8'
> lc_monetary = 'en_US.UTF-8'
> lc_numeric = 'en_US.UTF-8'
> lc_time = 'en_US.UTF-8'
> default_text_search_config = 'pg_catalog.english'
>
> 13.      mkdir  /usr/local/pgsql/data/pg_xlogarch/
> 14.      su – postgres
> 15.      cd /usr/local/pgsql/
>
>                         “Modify the following attributes and their values in pg_hba.conf as follows”
>                         -------------------------------------------------------------------------------
> 16.      vi data/pg_hba.conf
>                 host    replication             all             10.128.16.52/32 (slave IPaddress)           trust
>
> 17.      /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -l logfile start
> 18.      cd /usr/local/pgsql/bin/
> 19.      /psql –c "SELECT pg_start_backup('label')" PICOEMSDB
> 20.      cd /usr/local/pgsql/
> 21 .     tar  -czf data.tar.gz        data/
> Changes made on Slave DB
> -------------------------
>     • tar –xzvf   postgresql-9.0.4.tar
>     • cd postgresql-9.0.4
>     • ./configure
>     • gmake
>     • su
>     • gmake install
>     • adduser postgres
>     • mkdir -p /usr/local/pgsql/data
>     • chown -R postgres /usr/local/pgsql
>     • cd  /usr/local/pgsql
>     • Copy the tar file which we have created in master machine to the respected dir in the slave m/c step 21
>     • tar xzf data.tar.gz
>     • chown –R postgres:postgres  /usr/local/pgsql/data/pg_xlogarch
>     • cd data
>     • rm –rf postmaster.pid
> “Modify the following attributes and their values in Postgresql.conf as follows”
> ----------------------------------------------------------------------------------------------
>     • vi  /usr/local/pgsql/data/Postgresql.conf
> listen_addresses = '*'          # what IP address(es) to listen on;
> max_connections = 500                   # (change requires restart)
> shared_buffers = 32MB                   # min 128kB
> hot_standby = on
> datestyle = 'iso, mdy'
> lc_messages = 'en_US.UTF-8'                     # locale for system error message
> lc_monetary = 'en_US.UTF-8'                     # locale for monetary formatting
> lc_numeric = 'en_US.UTF-8'                      # locale for number formatting
> lc_time = 'en_US.UTF-8'                         # locale for time formatting
> default_text_search_config = 'pg_catalog.english'
>
>     • create recovery.conf file in the following directory /usr/local/pgsql/data/
> Add the below lines in the recovery.conf file
> standby_mode = 'on'
> primary_conninfo = 'host=master ip port=5432 user=postgres'
> restore_command = 'cp /usr/local/pgsql/data/pg_xlogarch/%f "%p"'
>
>     • /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -l logfile start
>
> Regards,
> Tiru
>
> -----Original Message-----
> From: Vibhor Kumar [mailto:vibhor.kumar@enterprisedb.com]
> Sent: Thursday, April 21, 2011 6:53 PM
> To: Tiruvenkatasamy Baskaran
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Which version of postgresql supports replication on RHEL6?
>
>
> On Apr 21, 2011, at 6:35 PM, Tiruvenkatasamy Baskaran wrote:
>
> > Got the following messages in log file on the master DB.
> > LOG:  database system was shut down at 2011-04-01 14:27:37 IST
> > LOG:  database system is ready to accept connections
> > LOG:  autovacuum launcher started
> > LOG: replication connection authorized: user=postgres host=10.128.16.52 port=52324
> > cp:   cannot stat `/usr/local/pgsql/data/pg_xlogarch/000000010000000000000001': No such file or directory
> > LOG:  archive command failed with exit code 1
> > Got the following messages in log file on the slave DB.
> > LOG:  database system was interrupted; last known up at 2011-03-24 12:29:15 IST
> > LOG:  entering standby mode
> > cp: cannot stat `/usr/local/pgsql/data/pg_xlogarch/000000010000000000000002': No such file or directory
> > LOG:  redo starts at 0/2000020
> > LOG:  record with zero length at 0/20000B0
> > cp: cannot stat `/usr/local/pgsql/data/pg_xlogarch/000000010000000000000002': No such file or directory
> > LOG:  streaming replication successfully connected to primary
> > FATAL:  the database system is starting up
> > FATAL:  the database system is starting up
> > Master DB is running and able to query table. But slave DB is not running and not able to query table.
>
> Please confirm if you have made Slave DB using PITR/Hot Backup of Master. Also, please let me know the steps which
youhave followed. 
>
> Thanks & Regards,
> Vibhor Kumar
> EnterpriseDB Corporation
> The Enterprise PostgreSQL Company
> vibhor.kumar@enterprisedb.com
> Blog:http://vibhork.blogspot.com
>
>
>   ________________________________
> ::DISCLAIMER::
>
-----------------------------------------------------------------------------------------------------------------------
>
> The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only.
> It shall not attach any liability on the originator or HCL or its affiliates. Any views or opinions presented in
> this email are solely those of the author and may not necessarily reflect the opinions of HCL or its affiliates.
> Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of
> this message without the prior written consent of the author of this e-mail is strictly prohibited. If you have
> received this email in error please delete it and notify the sender immediately. Before opening any mail and
> attachments please check them for viruses and defect.
>
>
-----------------------------------------------------------------------------------------------------------------------

Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.kumar@enterprisedb.com
Blog:http://vibhork.blogspot.com