Re: Recovery from Archive files

On Thu, Oct 20, 2011 at 10:01 AM, senthilnathan
<senthilnathan(dot)t(at)gmail(dot)com>wrote:

> Thanks John.,
>
> Yes its from WAL Archives. I dont have the basebackup instead i am having
> all the WAL files that are archived right from the server start. My
> question
> is how(steps?) to to build whole setup(postgres server)by replaying all WAL
> files
> (from 000000010000000000000001....................000000010000000100000027)
>
>
I think you should give a try on any test box.

Am assuming you are having $PGDATA (data directory) and their WAL Archives.
Take a copy of these to your test box and follow below steps.

1. Remove postmaster.pid from $PGDATA
2. Create recovery.conf file in $PGDATA directory.
vi recovery.conf
restore_command = ' cp /WAL Archives destination/%f %p'
recovery_target_time = '2011-10-20 14:30:25'
:wq

Note: Here target_time is your current rebuild time, because you want to
replay all WAL Archives which are available.

3. Start the instance and check $PGDATA/pg_log/.log file on to know how
recovery process went.

---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/