Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 0969C1337BD3 for ; Wed, 20 Apr 2011 10:48:38 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 93474-01-6 for ; Wed, 20 Apr 2011 13:48:30 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-pw0-f46.google.com (mail-pw0-f46.google.com [209.85.160.46]) by mail.postgresql.org (Postfix) with ESMTP id 97A231337C5A for ; Wed, 20 Apr 2011 10:47:53 -0300 (ADT) Received: by pwi15 with SMTP id 15so401492pwi.19 for ; Wed, 20 Apr 2011 06:47:53 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:subject:mime-version:content-type:from :in-reply-to:date:cc:content-transfer-encoding:message-id:references :to:x-mailer; bh=pXAO9M7frcKx2D817aZkOPKVOSxh5W4vvUcqz4lzJk0=; b=iDiF0WQ+jMhDrr4S4HMRC+khZKKTu7TMCQxVE7SvmSVt7mWa2huoftG/3sSPMMrOMT Xq9QPaSh2NlsUHgJTXAXwQrd6wRg3G2+wCL2TToMqfzhRIWAi+mNe6Zx/uag3D6h7M4L 7E7u4t+4Jmzwd2xKCKyC3vYu+asP6+K56k1wM= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=subject:mime-version:content-type:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to:x-mailer; b=sgxXGmtXB5s4ZvD/DRJvRCeLDKi2uUqaONpXj1fyPpMbZHrVNjWgd7042zlNk/YqK7 pMoA3njmIa6rFevyuUT7V4zRNmzSgUoEXSZe0SQbAtyScVAP7TpryFsT1KI/E8NhgJzC oCHIsoFQbHs6rMcbLcOHUG5RnSPikOBiiGakc= Received: by 10.142.225.5 with SMTP id x5mr4008019wfg.332.1303307273814; Wed, 20 Apr 2011 06:47:53 -0700 (PDT) Received: from [172.24.35.132] ([59.162.78.200]) by mx.google.com with ESMTPS id n4sm1248683wfl.14.2011.04.20.06.47.50 (version=TLSv1/SSLv3 cipher=OTHER); Wed, 20 Apr 2011 06:47:52 -0700 (PDT) Subject: Re: database system identifier differs between the primary and standby Mime-Version: 1.0 (Apple Message framework v1084) Content-Type: text/plain; charset=us-ascii From: Vibhor Kumar In-Reply-To: <2658E54B540D284981EA57E6A549EA70ABD205D3AF@INBLRK77M1MSX.in002.siemens.net> Date: Wed, 20 Apr 2011 19:22:46 +0530 Cc: "pgsql-admin@postgresql.org" Content-Transfer-Encoding: quoted-printable Message-Id: References: <2658E54B540D284981EA57E6A549EA70ABD205D3AF@INBLRK77M1MSX.in002.siemens.net> To: "Deka, Rajib IN MAA SL" X-Mailer: Apple Mail (2.1084) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.898 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, RFC_ABUSE_POST=0.001 X-Spam-Level: X-Archive-Number: 201104/189 X-Sequence-Number: 37370 On Apr 20, 2011, at 6:46 PM, Deka, Rajib IN MAA SL wrote: >=20 > 2011-04-20 17:34:40 ETC/GMT FATAL: the database system is starting up=20= > 2011-04-20 17:34:41 ETC/GMT FATAL: database system identifier differs = between the primary and standby=20 > 2011-04-20 17:34:41 ETC/GMT DETAIL: The primary's identifier is = 5592072752411433371, the standby's identifier is 5597615802844953578.=20 >=20 > PostgreSQL Version: 9.0.2=20 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.aim@gmail.com Blog:http://vibhork.blogspot.com