Re: Re: Backup and Recovery - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Re: Backup and Recovery
Date
Msg-id 6122.994383197@sss.pgh.pa.us
Whole thread Raw
In response to Re: Re: Backup and Recovery  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Re: Backup and Recovery
List pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.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


pgsql-hackers by date:

Previous
From: Hiroshi Inoue
Date:
Subject: Re: Re: Buffer access rules, and a probable bug
Next
From: ncm@zembu.com (Nathan Myers)
Date:
Subject: Re: Re: Backup and Recovery