From: | rajibdk <rajib(dot)deka(at)siemens(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | database system identifier differs between the primary and standby |
Date: | 2011-04-20 13:28:11 |
Message-ID: | 1303306091382-4317178.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
--
View this message in context: http://postgresql.1045698.n5.nabble.com/database-system-identifier-differs-between-the-primary-and-standby-tp4317178p4317178.html
Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2011-04-20 13:38:27 | Re: Re: [COMMITTERS] pgsql: setlocale() on Windows doesn't work correctly if the locale name |
Previous Message | Robert Haas | 2011-04-20 13:19:50 | Re: time-delayed standbys |