Search Postgresql Archives

Re: Question on Wal time lines

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




El may 3, 2011 5:59 p.m., "John R Pierce" <pierce@xxxxxxxxxxxx> escribiÃ:
>
> On 05/03/11 3:07 PM, dabicho wrote:
>>
>>
>> For restoring a database from wal files, if I omit a target on the recovery.conf file, can I make it so the database continues the time line instead of starting one?
>> Or is there a tool to pick the most recent time line from a bunch of wal files?
>>
>> thankyou.
>>
>
> you need to playback all the wal files from when you started the base backup. Âof course, you need that base backup, too.
>
I did that.
I restored the database, put the recovery file in place along with previous wal files and the last wall files, and after start up there was a new time line.
Am I missing something?
This is postgres 9.0
>
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux