Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id C2A2B1337C19 for ; Wed, 20 Apr 2011 10:32:14 -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 55316-01-3 for ; Wed, 20 Apr 2011 13:32:07 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sam.nabble.com (sam.nabble.com [216.139.236.26]) by mail.postgresql.org (Postfix) with ESMTP id 85C441337C08 for ; Wed, 20 Apr 2011 10:31:33 -0300 (ADT) Received: from [192.168.236.26] (helo=sam.nabble.com) by sam.nabble.com with esmtp (Exim 4.69) (envelope-from ) id 1QCXDt-0003Ng-42 for pgsql-admin@postgresql.org; Wed, 20 Apr 2011 06:13:37 -0700 Date: Wed, 20 Apr 2011 06:13:37 -0700 (PDT) From: rajibdk To: pgsql-admin@postgresql.org Message-ID: <1303305217113-4315820.post@n5.nabble.com> Subject: database system identifier differs between the primary and standby MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.778 tagged_above=-10 required=5 tests=BAYES_00=-1.9, URI_HEX=1.122 X-Spam-Level: X-Archive-Number: 201104/187 X-Sequence-Number: 37368 Hello List, 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 Prymary configuration: wal_level =3D 'hot_standby' - postgresql.conf host replication all x.x.x.x/24 trust =E2=80=93 pg_hb= a.conf Secondary configuration: Hot_standby=3Doff =E2=80=93 postgresql.conf standby_mode =3D 'on' =E2=80=93 recovery.conf primary_conninfo =3D 'host=3D10.20.9.181 port=3D5432' =E2=80=93 recovery.co= nf Please suggest on the above log O/P. Regards, Rajib Rajib Deka SIEMENS Ltd.=20 Robert V Chandran Tower, First Floor, West Wing,=20 #149, Velechery Tambaram Main Road, Pallikaranai, Chennai-100, INDIA. www.siemens.com =20 Mob: +91-9176780669 | E-Mail: rajib.deka@siemens.com -- View this message in context: http://postgresql.1045698.n5.nabble.com/datab= ase-system-identifier-differs-between-the-primary-and-standby-tp4315820p431= 5820.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com.