Postgres Pro
Downloads
Home   >   mailing lists

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

From Wang, Mary Y
Subject How does the WAL work? Need to recovery the database to a specific point of time
Date
Msg-id 27F6554ED189174ABAA2EDB71E1350951AE59CBF@XCH-PHX-202.sw.nos.boeing.com
Whole thread Raw
Responses Re: How does the WAL work? Need to recovery the database to a specific point of time  (Steve Crawford <scrawford@pinpointresearch.com>)
Re: How does the WAL work? Need to recovery the database to a specific point of time  (Matheus de Oliveira <matioli.matheus@gmail.com>)
Re: How does the WAL work? Need to recovery the database to a specific point of time  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-admin
Tree view

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.

 

Thanks

Mary Wang

pgsql-admin by date:

Previous
From: Oscar Calderon
Date:
Subject: Re: PostgreSQL isn't enough scalable as Oracle or DB2
Next
From: Steve Crawford
Date:
Subject: Re: How does the WAL work? Need to recovery the database to a specific point of time