Re: Which version of postgresql supports replication on RHEL6? - Mailing list pgsql-general
| From | Tiruvenkatasamy Baskaran |
|---|---|
| Subject | Re: Which version of postgresql supports replication on RHEL6? |
| Date | |
| Msg-id | 04F87E501E06034AB023C70BBCFC5AD8013767BA69BA@CHN-HCLT-EVS06.HCLT.CORP.HCL.IN Whole thread Raw |
| In response to | Re: Which version of postgresql supports replication on RHEL6? (Vibhor Kumar <vibhor.kumar@enterprisedb.com>) |
| Responses |
Re: Which version of postgresql supports replication on RHEL6?
|
| List | pgsql-general |
Hi Vibhor Kumar,
We downloaded postgresql-9.0.4.tar source from postgresql.org.
We installed postgresql db from source on machine1(master) and machine2(slave).
RHEL version : 2.6.32-71.el6.x86_64
In order to enable replication between master and slave, we did necessary configuration
changes on master DB then started the master DB.
Also did necessary configuration changes on slave DB then started the slave DB.
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.
Could you tell me why slave DB is not running?
If you need more details on how we configured master and slave DB in replication mode , we will provide.
Regards,
Tiru
-----Original Message-----
From: Vibhor Kumar [mailto:vibhor.kumar@enterprisedb.com]
Sent: Thursday, April 21, 2011 5:17 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 4:42 PM, Tiruvenkatasamy Baskaran wrote:
> Which version of postgresql supports replication on RHEL6?
> RHEL version : 2.6.32-71.el6.x86_64
If you are talking about inbuilt replication, then from PG9.0 onwards. Else slony-I replication tool is available for replication of PG Database
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.
-----------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------
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.
-----------------------------------------------------------------------------------------------------------------------
pgsql-general by date: