Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id C465B9FBDDE for ; Fri, 3 Aug 2007 21:21:30 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 25050-10 for ; Fri, 3 Aug 2007 21:21:20 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 3D8D89FB6AF for ; Fri, 3 Aug 2007 21:21:27 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id 1784556453; Fri, 3 Aug 2007 19:21:26 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Fri, 3 Aug 2007 19:21:24 -0500 Date: Fri, 3 Aug 2007 19:21:24 -0500 From: Decibel! To: Donald Fraser Cc: "[ADMIN]" Subject: Re: WAL segment question Message-ID: <20070804002124.GD25704@nasby.net> References: <008601c7d622$244237a0$b464a8c0@demolish1> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="EH85xkKza2NXtwkF" Content-Disposition: inline In-Reply-To: <008601c7d622$244237a0$b464a8c0@demolish1> X-Operating-System: FreeBSD 6.1-RELEASE-p10 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.13 (2006-08-11) X-Hashcash: 1:20:070804:postgres@kiwi-fraser.net::V/4ingOHcVFTtIHN:0000000000000 0000000000000000000000000/7r X-Hashcash: 1:20:070804:pgsql-admin@postgresql.org::rtusOwsEn9NSXVLU:00000000000 0000000000000000000000001Rph X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/28 X-Sequence-Number: 26359 --EH85xkKza2NXtwkF Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Sat, Aug 04, 2007 at 12:00:52AM +0100, Donald Fraser wrote: > Our company has two sites, a master and a disaster recovery site. > I am trying to assess whether data has been lost during a fail-over, due = to the asynchronous method of transporting WAL file data between sites (we = use DRBD). >=20 > Disaster recovery node start-up log: > user=3D pid=3D9907 timestamp=3D[2007-08-01 17:09:51 BST] tid=3D LOG: rec= ord with zero length at 0/7C62F52C > user=3D pid=3D9907 timestamp=3D[2007-08-01 17:09:51 BST] tid=3D LOG: red= o done at 0/7C62F4E8 >=20 > My question is: given the above WAL segment information, can I use it to = decide whether information was lost in the master database site, at the poi= nt of failure, without starting the database up? I'm not sure, but you could try md5-ing the appropriate WAL file on the master and slave; if the files are identical then you shouldn't have lost any data... if they are then you probably have. --=20 Decibel!, aka Jim Nasby decibel@decibel.org EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) --EH85xkKza2NXtwkF Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.3 (FreeBSD) iD8DBQFGs8aEdO30qud8SkgRAicBAJ4qmXdxV8uGSDPy7VXVXnXfryoMPACeLj3z gzEje2wIWOEGv700bYTesgQ= =sYEU -----END PGP SIGNATURE----- --EH85xkKza2NXtwkF--