database system identifier differs between the primary and standby - Mailing list pgsql-admin

From Deka, Rajib IN MAA SL
Subject database system identifier differs between the primary and standby
Date
Msg-id 2658E54B540D284981EA57E6A549EA70ABD205D3AF@INBLRK77M1MSX.in002.siemens.net
Whole thread Raw
Responses Re: database system identifier differs between the primary and standby  (Vibhor Kumar <vibhor.aim@gmail.com>)
List pgsql-admin

Hello List,

We are getting the following log while configuring hot standby,

2011-04-20 17:34:40 ETC/GMT FATAL:  the database system is starting up
2011-04-20 17:34:41 ETC/GMT FATAL:  database system identifier differs between the primary and standby
2011-04-20 17:34:41 ETC/GMT DETAIL:  The primary's identifier is 5592072752411433371, the standby's identifier is 5597615802844953578.

PostgreSQL Version: 9.0.2

Prymary configuration:
wal_level = 'hot_standby'  - postgresql.conf
host    replication     all       x.x.x.x/24          trust – pg_hba.conf

Secondary configuration:
Hot_standby=off – postgresql.conf
standby_mode = 'on' – recovery.conf
primary_conninfo = 'host=10.20.9.181 port=5432' – recovery.conf

Please suggest on the above log O/P.

Regards,
Rajib

 

Rajib Deka

SIEMENS Ltd.

Robert V Chandran Tower, First Floor, West Wing,

#149, Velechery Tambaram Main Road, Pallikaranai, Chennai-100, INDIA.

www.siemens.com

 

Mob: +91-9176780669 | E-Mail: rajib.deka@siemens.com

 



Important notice: This e-mail and any attachment there to contains corporate proprietary information. If you have received it by mistake, please notify us immediately by reply e-mail and delete this e-mail and its attachments from your system.
Thank You.

pgsql-admin by date:

Previous
From: rajibdk
Date:
Subject: database system identifier differs between the primary and standby
Next
From: Vibhor Kumar
Date:
Subject: Re: database system identifier differs between the primary and standby