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