Re: Re: Backup and Recovery

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Re: Backup and Recovery
Date: 2001-07-06 01:33:17
Message-ID: 6122.994383197@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> In other words, we keep the page images and row records in one file so
> we can do one fsync, but once we have written the page, we don't want to
> store them for later point-in-time recovery.

What we'd want to do is strip the page images from the version of the
logs that's archived for recovery purposes. Ideally the archiving
process would also discard records from aborted transactions, but I'm
not sure how hard that'd be to do.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Nathan Myers 2001-07-06 02:54:43 Re: Re: Backup and Recovery
Previous Message Hiroshi Inoue 2001-07-06 01:22:38 Re: Re: Buffer access rules, and a probable bug