database system identifier differs between the primary and standby

Поиск
Список
Период
Сортировка
От rajibdk
Тема database system identifier differs between the primary and standby
Дата
Msg-id 1303306091382-4317178.post@n5.nabble.com
обсуждение исходный текст
Ответы Re: database system identifier differs between the primary and standby  (Robert Haas <robertmhaas@gmail.com>)
Список 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.


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: time-delayed standbys
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Re: [COMMITTERS] pgsql: setlocale() on Windows doesn't work correctly if the locale name