Re: Which version of postgresql supports replication on RHEL6?

[ 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(dot)kumar(at)enterprisedb(dot)com]
> Sent: Thursday, April 21, 2011 6:53 PM
> To: Tiruvenkatasamy Baskaran
> Cc: pgsql-general(at)postgresql(dot)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 you have followed.
>
> Thanks & Regards,
> Vibhor Kumar
> EnterpriseDB Corporation
> The Enterprise PostgreSQL Company
> vibhor(dot)kumar(at)enterprisedb(dot)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(dot)kumar(at)enterprisedb(dot)com
Blog:http://vibhork.blogspot.com