Re: database system identifier differs between the primary and standby

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<http://www.siemens.com>

Mob: +91-9176780669 | E-Mail: rajib(dot)deka(at)siemens(dot)com
________________________________
From: Robert Haas [via PostgreSQL] [mailto:ml-node+4326869-1711138747-200178(at)n5(dot)nabble(dot)com]
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]</user/SendEmail.jtp?type=node&node=4326869&i=0&by-user=t>> 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]</user/SendEmail.jtp?type=node&node=4326869&i=1&by-user=t>)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

________________________________
If you reply to this email, your message will be added to the discussion below:
http://postgresql.1045698.n5.nabble.com/database-system-identifier-differs-between-the-primary-and-standby-tp4317178p4326869.html
To unsubscribe from database system identifier differs between the primary and standby, click here<http://postgresql.1045698.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4317178&code=cmFqaWIuZGVrYUBzaWVtZW5zLmNvbXw0MzE3MTc4fC0zNTQ2NTE2Njg=>.

________________________________
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: http://postgresql.1045698.n5.nabble.com/database-system-identifier-differs-between-the-primary-and-standby-tp4317178p4330373.html
Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.