Skip site navigation (1) Skip section navigation (2)

Re: beta testing version

From: Don Baccus <dhogaza(at)pacifier(dot)com>
To: "Vadim Mikheev" <vmikheev(at)sectorbase(dot)com>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: beta testing version
Date: 2000-12-01 14:39:57
Message-ID: 3.0.1.32.20001201063957.0178e280@mail.pacifier.com (view raw or flat)
Thread:
Lists: pgsql-hackers
At 11:06 PM 11/30/00 -0800, Vadim Mikheev wrote:
>> As for replaying logs against a restored snapshot dump... AIUI, a 
>> dump records tuples by OID, but the WAL refers to TIDs.  Therefore, 
>> the WAL won't work as a re-do log to recover your transactions 
>> because the TIDs of the restored tables are all different.   
>
>True for current way of backing up - ie saving data in "external"
>(sql) format. But there is another way - saving data files in their
>natural (binary) format. WAL records may be applyed to
>such dump, right?

Right.  That's what's missing in PG 7.1, the existence of tools to
make such backups.  

Probably the best answer to the "what does WAL get us, if it doesn't
get us full recoverability" questions is to simply say "it's a prerequisite
to getting full recoverability, PG 7.1 sets the foundation and later
work will get us there".



- Don Baccus, Portland OR <dhogaza(at)pacifier(dot)com>
  Nature photos, on-line guides, Pacific Northwest
  Rare Bird Alert Service and other goodies at
  http://donb.photo.net.

In response to

Responses

pgsql-hackers by date

Next:From: Don BaccusDate: 2000-12-01 14:46:57
Subject: Re: beta testing version
Previous:From: mlwDate: 2000-12-01 14:25:41
Subject: Re: [Fwd: Re: 8192 BLCKSZ ?]

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group