Thread: database system identifier differs between the primary and standby
database system identifier differs between the primary and standby
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.
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.
On Apr 20, 2011, at 6:46 PM, Deka, Rajib IN MAA SL wrote: > > 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 How did you setupt the replication? Please mention the steps. It seems you have not used the PITR Backup of Primary for creatingstandby. Thanks & Regards, Vibhor Kumar vibhor.aim@gmail.com Blog:http://vibhork.blogspot.com