Re: Point in Time Recovery

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, mascarm(at)mascari(dot)com, ZeugswetterA(at)spardat(dot)at, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Point in Time Recovery
Date: 2004-07-13 14:29:44
Message-ID: 15780.1089728984@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-hackers pgsql-patches

Simon Riggs <simon(at)2ndquadrant(dot)com> writes:
> Please tell me that we can ignore the state of the clog,

We can.

The reason that keeping track of timelines is interesting for xlog is
simply to take pity on the poor DBA who needs to distinguish the various
archived xlog files he's got laying about, and so that we can detect
errors like supplying inconsistent sets of xlog segments during restore.

This does not apply to clog because it's not archived. It's no more
than a data file. If you think you have trouble recreating clog then
you have the same issues recreating data files.

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Stef 2004-07-13 15:07:57 Re: Bad dumps...
Previous Message Tom Lane 2004-07-13 14:24:36 Re: Bad dumps...

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2004-07-13 14:57:09 Re: Assisting developers
Previous Message Christopher Kings-Lynne 2004-07-13 14:28:18 Re: Assisting developers

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2004-07-13 16:48:16 pgsql-server: Have \dn+ show permissions and description for schemas.
Previous Message Bruce Momjian 2004-07-13 13:05:01 Re: Remove confusing commented-defaullts from postgresql.conf