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: | 2658E54B540D284981EA57E6A549EA70ABD205D3A4@INBLRK77M1MSX.in002.siemens.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
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=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<http://www.siemens.com>
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Grzegorz Szpetkowski | 2011-04-20 20:29:58 | Choosing character set for database |
Previous Message | Pyrogerg | 2011-04-19 14:56:44 | Re: MDTFATAL: could note create log file . . . permission denied |