Postgres Pro
Downloads
Home   >   mailing lists

Re: How does the WAL work? Need to recovery the database to a specific point of time - Mailing list pgsql-admin

From Simon Riggs
Subject Re: How does the WAL work? Need to recovery the database to a specific point of time
Date
Msg-id CA+U5nMLxwa7vn+o6xtGV-F-M7MRisZuuTHJr1CEnKHYxC8V=QA@mail.gmail.com
Whole thread Raw
In response to How does the WAL work? Need to recovery the database to a specific point of time  ("Wang, Mary Y" <mary.y.wang@boeing.com>)
List pgsql-admin
Tree view 
On 22 April 2014 16:40, Wang, Mary Y <mary.y.wang@boeing.com> wrote:
> Hi All,
>
>
>
> I’d like to recovery the database to a specific point of time. I see some
> WAL files in the pg_xlog directories.
>
> I read some blogs, and some have indicated that a recovery.conf needs to be
> updated.  I do not see a recovery.conf file in the $PG_DATA directory ( I
> see pg_hba.conf and postgresql.conf).
>
>
>
> 1.       Do I need to create a recovery.conf file?
>
> 2.       What specific settings should I set?
>
> 3.       How do I ensure that postgres will read the recovery.conf file?
>
> 4.       What is the start/stop postgres command to use when working with a
> recovery.conf file?
>
>
>
> I am running on Postgres 8.4.11 and RHEL 6.4.

Point in Time Recovery is supported, though you have to have done some
planning beforehand. The settings and commands you'll use depend upon
the exact nature of your problem and the backups and other file copies
you possess.

http://www.postgresql.org/docs/devel/static/continuous-archiving.html
etc

--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

pgsql-admin by date:

Previous
From: Matheus de Oliveira
Date:
Subject: Re: How does the WAL work? Need to recovery the database to a specific point of time
Next
From: "Wang, Mary Y"
Date:
Subject: How to undo an update to a table?