Re: [HACKERS] Point in Time 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: Mark Kirkwood <markir(at)coretech(dot)co(dot)nz>, Simon Riggs <simon(at)2ndquadrant(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: [HACKERS] Point in Time Recovery
Date: 2004-07-22 03:42:22
Message-ID: 2654.1090467742@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-hackers pgsql-patches

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> Agreed, it might not be possible, but your report does point out a
> limitation in our implementation --- that a shutdown database contains
> more information than a backup and the archive logs. That is not
> intuitive.

That's only because you are clinging to the broken assumption that
pg_xlog/ is part of the database, rather than part of the logs.
Separate that out as a distinct entity, and all gets better.

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bruce Momjian 2004-07-22 03:54:48 Re: [HACKERS] Point in Time Recovery
Previous Message Bruce Momjian 2004-07-22 03:36:05 Re: [HACKERS] Point in Time Recovery

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2004-07-22 03:54:48 Re: [HACKERS] Point in Time Recovery
Previous Message Christopher Kings-Lynne 2004-07-22 03:41:24 Re: Sorting out acl fixes

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2004-07-22 03:54:48 Re: [HACKERS] Point in Time Recovery
Previous Message Bruce Momjian 2004-07-22 03:36:05 Re: [HACKERS] Point in Time Recovery