From: Simon Riggs <simon@2ndquadrant.com>
To: Mark Steben <msteben@autorevenue.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: error message in PITR restore:
Date: Fri, 16 May 2008 17:30:21 +0100
Message-ID: <1210955421.18922.63.camel@ebony.site> (raw)
In-Reply-To: <006b01c8b76a$690c0170$14010a0a@dei26g028575>
References: <006b01c8b76a$690c0170$14010a0a@dei26g028575>
On Fri, 2008-05-16 at 11:35 -0400, Mark Steben wrote:
> I’m in the process of implementing PITR backups and restores and
> learning as I practice. I restored
>
> Using tar –xzf (backup-name) followed by restarting postgres and
> having the server replay the logs.
>
> I used a recovery_target_time of 1 day prior to current_date
> Postgres seems to come up OK but
>
Did you use pg_start_backup()?
That sequence of events can occur if the backup_label file is missing,
since that won't constrain the stop point from being earlier than it
should be. Is there a backup_label file as part of the tar?
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: simon@2ndquadrant.com, msteben@autorevenue.com
Subject: Re: error message in PITR restore:
In-Reply-To: <1210955421.18922.63.camel@ebony.site>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox