| From: | "Kevin Grittner" <kgrittn(at)mail(dot)com> |
|---|---|
| To: | "wd" <wd(at)wdicc(dot)com>,"Jeff Janes" <jeff(dot)janes(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Restore postgres to specific time |
| Date: | 2012-11-27 14:59:39 |
| Message-ID: | 20121127145939.127690@gmx.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
wd wrote:
> the time is between backup start and stop.
That is the problem -- until the point where pg_stop_backup() was
run PostgreSQL can't be sure of having a consistent database. It is
waiting from enough WAL to get it there. My practice is always to
keep the last two base backups and all WAL from the start of the
earlier one to current. If I want to recover to a point in time
which was during a backup, I use the previous base backup, which is
complete and usable.
It does seem that there is an opportunity here to make it more
clear what is happening.
-Kevin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2012-11-27 15:06:14 | Re: Restore postgres to specific time |
| Previous Message | Gareth Lyons | 2012-11-27 13:38:04 | Streaming Replication error - relation uninitialized and WAL contains references to invalid pages |