Re: database system identifier differs between the primary and standby

From: Vibhor Kumar <vibhor(dot)aim(at)gmail(dot)com>
To: "Deka, Rajib IN MAA SL" <rajib(dot)deka(at)siemens(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: database system identifier differs between the primary and standby
Date: 2011-04-20 13:52:46
Message-ID: E8206F4A-2089-4786-8223-84307292712B@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


On Apr 20, 2011, at 6:46 PM, Deka, Rajib IN MAA SL wrote:

>
> 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

How did you setupt the replication? Please mention the steps. It seems you have not used the PITR Backup of Primary for creating standby.

Thanks & Regards,
Vibhor Kumar
vibhor(dot)aim(at)gmail(dot)com
Blog:http://vibhork.blogspot.com

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message raghu ram 2011-04-20 14:31:19 Re: [GENERAL] How to uninstall PostgreSQL 8.4 on both Windows XP and Windows 7
Previous Message Deka, Rajib IN MAA SL 2011-04-20 13:16:15 database system identifier differs between the primary and standby