Re: Question on Wal time lines

From: dabicho <tsukebumi(at)gmail(dot)com>
To:
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Question on Wal time lines
Date: 2011-05-03 23:15:41
Message-ID: BANLkTi=ZcHz0MahhrgiWuTeE4hkDPBQXfw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

El may 3, 2011 5:59 p.m., "John R Pierce" <pierce(at)hogranch(dot)com> 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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rob Sargent 2011-05-03 23:36:00 Re: pervasiveness of surrogate (also called synthetic) keys
Previous Message John R Pierce 2011-05-03 22:54:11 Re: Question on Wal time lines