Skip site navigation (1) Skip section navigation (2)

Re: error message in PITR restore:

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: Mark Steben <msteben(at)autorevenue(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: error message in PITR restore:
Date: 2008-05-16 16:30:21
Message-ID: 1210955421.18922.63.camel@ebony.site (view raw or flat)
Thread:
Lists: pgsql-admin
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


In response to

Responses

pgsql-admin by date

Next:From: Jeff FrostDate: 2008-05-16 16:38:27
Subject: Re: Can't reinstall b/c don't know the very long installation password
Previous:From: Mark StebenDate: 2008-05-16 15:35:03
Subject: error message in PITR restore:

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group