Re: PITR and base + full backups - Mailing list pgsql-general

From Simon Riggs
Subject Re: PITR and base + full backups
Date
Msg-id 1221631169.3913.1965.camel@ebony.2ndQuadrant
Whole thread Raw
In response to PITR and base + full backups  ("Joey K." <pguser@gmail.com>)
List pgsql-general
On Tue, 2008-09-16 at 21:16 +0530, Joey K. wrote:

> This didn't work and not sure if this is supposed to work ;-)
>
> Or should I stick to just plain PITR?

Yes, just drop steps (3) and (5). If you don't trust it for some reason,
then don't use it at all - mixing modes like that won't work. But we add
info to WAL to ensure that inconsistencies are removed from any backup.

--
 Simon Riggs           www.2ndQuadrant.com
 PostgreSQL Training, Services and Support


pgsql-general by date:

Previous
From: "Andrus"
Date:
Subject: Re: Converting string to IN query
Next
From: Andrea Moretto
Date:
Subject: Pgpool-II and Slony-I : query lag, sequences and stored procedures need help