Re: database system identifier differs between the primary and standby

Поиск
Список
Период
Сортировка
От rajibdk
Тема Re: database system identifier differs between the primary and standby
Дата
Msg-id 2658E54B540D284981EA57E6A549EA70ABD20DEB4E@INBLRK77M1MSX.in002.siemens.net
обсуждение исходный текст
Ответ на Re: database system identifier differs between the primary and standby  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: Re: database system identifier differs between the primary and standby  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Re: Re: database system identifier differs between the primary and standby  (Simon Riggs <simon@2ndQuadrant.com>)
Список pgsql-hackers
Дерево обсуждения

What does that database system identifier means? Is it related to DB transactions’ or unique to a version?

 

Rajib Deka

SIEMENS Ltd.

Robert V Chandran Tower, First Floor, West Wing,

#149, Velechery Tambaram Main Road, Pallikaranai, Chennai-100, INDIA.

www.siemens.com

 

Mob: +91-9176780669 | E-Mail: [hidden email]

From: Robert Haas [via PostgreSQL] [mailto:ml-node+[hidden email]]
Sent: Wednesday, April 20, 2011 7:20 PM
To: Deka, Rajib IN MAA SL
Subject: Re: database system identifier differs between the primary and standby

 

On Wed, Apr 20, 2011 at 9:28 AM, rajibdk <[hidden email]> wrote:
> 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

You need to initialize the slave using a hot backup taken on the master.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

--
Sent via pgsql-hackers mailing list ([hidden email])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

To unsubscribe from database system identifier differs between the primary and standby, click here.


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.

View this message in context: RE: database system identifier differs between the primary and standby
Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.

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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: fsync reliability
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Re: database system identifier differs between the primary and standby