Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id D00E99FB583 for ; Mon, 6 Aug 2007 19:54:35 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 62560-01 for ; Mon, 6 Aug 2007 19:54:21 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from smtp132.iad.emailsrvr.com (smtp132.iad.emailsrvr.com [207.97.245.132]) by postgresql.org (Postfix) with ESMTP id 2F6DD9FB560 for ; Mon, 6 Aug 2007 19:54:25 -0300 (ADT) Received: by relay3.r3.iad.emailsrvr.com (Authenticated sender: chander-AT-otg-nc.com) with ESMTP id 1C80C44C081; Mon, 6 Aug 2007 18:54:23 -0400 (EDT) Message-ID: <46B7A6A6.9010401@otg-nc.com> Date: Mon, 06 Aug 2007 18:54:30 -0400 From: Chander Ganesan User-Agent: Thunderbird 2.0.0.5 (Windows/20070716) MIME-Version: 1.0 To: Donald Fraser CC: "[ADMIN]" Subject: Re: WAL segment question References: <008601c7d622$244237a0$b464a8c0@demolish1> In-Reply-To: <008601c7d622$244237a0$b464a8c0@demolish1> Content-Type: multipart/alternative; boundary="------------080200040604050004000500" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/33 X-Sequence-Number: 26364 This is a multi-part message in MIME format. --------------080200040604050004000500 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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). > > Disaster recovery node start-up log: > user= pid=9907 timestamp=[2007-08-01 17:09:51 BST] tid= LOG: record > with zero length at 0/7C62F52C > user= pid=9907 timestamp=[2007-08-01 17:09:51 BST] tid= LOG: redo > done at 0/7C62F4E8 > > 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 point of failure, without starting the database up? > > Regards > Donald Fraser. DRBD is a synchronous method of transferring data - it's not asynchronous. Assuming you are using Protocol C you should find that both are always in sync. If you are using protocol B then things will be in sync so long as the remote system didn't crash, and if you are using Protocol A then things should be in sync as long as the local system didn't crash. -- Chander Ganesan Open Technology Group, Inc. One Copley Parkway, Suite 210 Morrisville, NC 27560 919-463-0999/866-229-3386 http://www.otg-nc.com --------------080200040604050004000500 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit 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).
 
Disaster recovery node start-up log:
user= pid=9907 timestamp=[2007-08-01 17:09:51 BST] tid= LOG:  record with zero length at 0/7C62F52C
user= pid=9907 timestamp=[2007-08-01 17:09:51 BST] tid= LOG:  redo done at 0/7C62F4E8
 
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 point of failure, without starting the database up?
 
Regards
Donald Fraser.
DRBD is a synchronous method of transferring data - it's not asynchronous.  Assuming you are using Protocol C you should find that both are always in sync.  If you are using protocol B then things will be in sync so long as the remote system didn't crash, and if you are using Protocol A then things should be in sync as long as the local system didn't crash.
-- 
Chander Ganesan
Open Technology Group, Inc.
One Copley Parkway, Suite 210
Morrisville, NC  27560
919-463-0999/866-229-3386
http://www.otg-nc.com
--------------080200040604050004000500--