From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Alex Zendel <alexzendel@hotmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: question about wal and point in time recovery
Date: Mon, 18 Apr 2005 13:06:05 -0400 (EDT)
Message-ID: <200504181706.j3IH65m27532@candle.pha.pa.us> (raw)
In-Reply-To: <3098.1113366527@sss.pgh.pa.us>
Tom Lane wrote:
> > can the log be modified before recovery occurs.
>
> Not easily. If you were to hack any one log entry, you'd have to
> recompute the CRC checksum for it, and there's no way at all to make
> a change that would involve changing the size of a log entry. So
> really the only useful option you have here is to stop recovery short
> of a particular log entry you don't like.
>
> > my biggest concern is that somebody in my org, for example, deletes a
> > field or fudges an update query that changes a foreign key to a single
> > value - and therefore destroys table links. so what if this happens
> > and nobody notices it for several weeks?
>
> There is no automatic recovery mechanism that is going to help you in
> such a scenario. You can't expect to undo a long-ago change and not
> have that break some unknown number of consequent decisions.
I think it might be easier to somehow hack the binary that reads the WAL
file on recovery to adjust how it handles a certain WAL entry, rather
than modifying the WAL files itself.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: pgman@candle.pha.pa.us, tgl@sss.pgh.pa.us, alexzendel@hotmail.com
Subject: Re: question about wal and point in time recovery
In-Reply-To: <200504181706.j3IH65m27532@candle.pha.pa.us>
References: <3098.1113366527@sss.pgh.pa.us> <200504181706.j3IH65m27532@candle.pha.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox