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

From Zeugswetter Andreas SB
Subject AW: Re: Backup and Recovery
Date
Msg-id 11C1E6749A55D411A9670001FA687963368368@sdexcsrv1.f000.d0188.sd.spardat.at
Whole thread Raw
Responses Re: AW: Re: Backup and Recovery  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> > 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.

Unless we have UNDO we also need to roll forward the physical changes of 
aborted transactions, or later redo records will "sit on a wrong physical image".

Andreas


pgsql-hackers by date:

Previous
From: Matthew Hagerty
Date:
Subject: Proper use of select() parameter nfds?
Next
From: "Jean-Francois Leveque"
Date:
Subject: Database Users Management and Privileges