Skip site navigation (1) Skip section navigation (2)

Database system identifier mismatch

From: "Deka, Rajib IN MAA SL" <rajib(dot)deka(at)siemens(dot)com>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Database system identifier mismatch
Date: 2011-04-20 13:12:48
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
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= port=5432' - recovery.conf

Please suggest on the above log O/P.


Rajib Deka
Robert V Chandran Tower, First Floor, West Wing,
#149, Velechery Tambaram Main Road, Pallikaranai, Chennai-100, INDIA.<>

Mob: +91-9176780669 | E-Mail: rajib(dot)deka(at)siemens(dot)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-novice by date

Next:From: Grzegorz SzpetkowskiDate: 2011-04-20 20:29:58
Subject: Choosing character set for database
Previous:From: PyrogergDate: 2011-04-19 14:56:44
Subject: Re: MDTFATAL: could note create log file . . . permission denied

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group