Re: PITR and base + full backups

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: "Joey K(dot)" <pguser(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: PITR and base + full backups
Date: 2008-09-17 05:59:29
Message-ID: 1221631169.3913.1965.camel@ebony.2ndQuadrant
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrus 2008-09-17 08:12:27 How to remove duplicate subqueries
Previous Message lighthouse.software 2008-09-17 00:01:23 Re: DbLink Compilation on Solaris 10