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.d...@siemens.com ________________________________ From: Robert Haas [via PostgreSQL] [mailto:ml-node+4326869-1711138747-200...@n5.nabble.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.