pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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



view thread (7+ messages)

Message-ID: <200504181706.j3IH65m27532@candle.pha.pa.us>
Permalink:  ../200504181706.j3IH65m27532@candle.pha.pa.us/
Also on:    postgresql.org/message-id/200504181706.j3IH65m27532@candle.pha.pa.us

 · 

reply

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