Re: [GENERAL] Recovery from Archive files

2011-10-24 Thread Ian Harding
On Thu, Oct 20, 2011 at 11:42 AM, Raghavendra wrote: > On Thu, Oct 20, 2011 at 11:58 PM, John R Pierce wrote: >> >> On 10/20/11 2:33 AM, Raghavendra wrote: >>> >>> Am assuming you are having $PGDATA (data directory) and their WAL >>> Archives. >> >> he said he does not have the base backup ($PGDA

Re: [GENERAL] Recovery from Archive files

2011-10-20 Thread Raghavendra
On Thu, Oct 20, 2011 at 11:58 PM, John R Pierce wrote: > On 10/20/11 2:33 AM, Raghavendra wrote: > >> Am assuming you are having $PGDATA (data directory) and their WAL >> Archives. >> > > he said he does not have the base backup ($PGDATA), so this is pointless. > > Ahh.. Agreed. I mis-read, I tho

Re: [GENERAL] Recovery from Archive files

2011-10-20 Thread John R Pierce
On 10/20/11 2:33 AM, Raghavendra wrote: Am assuming you are having $PGDATA (data directory) and their WAL Archives. he said he does not have the base backup ($PGDATA), so this is pointless. -- john r pierceN 37, W 122 santa cruz ca mid-left

Re: [GENERAL] Recovery from Archive files

2011-10-20 Thread Raghavendra
On Thu, Oct 20, 2011 at 10:01 AM, senthilnathan 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 replayin

Re: [GENERAL] Recovery from Archive files

2011-10-20 Thread John R Pierce
On 10/19/11 9:31 PM, senthilnathan 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 WAL f

Re: [GENERAL] Recovery from Archive files

2011-10-19 Thread senthilnathan
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 000100010

Re: [GENERAL] Recovery from Archive files

2011-10-19 Thread John R Pierce
On 10/19/11 4:57 AM, senthilnathan wrote: How to recover a standalone postgres setup using archive files alone? What are the steps/config involved? 'archive files' ? you mean a WAL archive? you need the base backup *and* all WAL files since to recover with that. -- john r pierce