| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Frost | 2008-05-16 16:38:27 | Re: Can't reinstall b/c don't know the very long installation password |
| Previous Message | Mark Steben | 2008-05-16 15:35:03 | error message in PITR restore: |