Re: PITR WAL Restore and configuration - Mailing list pgsql-admin

From Albe Laurenz
Subject Re: PITR WAL Restore and configuration
Date
Msg-id A737B7A37273E048B164557ADEF4A58B17D22E7F@ntex2010i.host.magwien.gv.at
Whole thread Raw
In response to Re: PITR WAL Restore and configuration  (Techie <techchavez@gmail.com>)
List pgsql-admin
Techie wrote:
> Thanks man, I think I understand  after re-reading the PITR WAL documentation a little better. I think that I need
theWAL log or logs mentioned in the .backup file.
 
> So for example when I run the pg_start_bkup and pg_stop_backup It outputs something like this into the .backup file
>
> START WAL LOCATION: 111/CD000020 (file 0000000200000111000000CD)
> STOP WAL LOCATION: 111/CD0000A8 (file 0000000200000111000000CD)

[...]

> This means that in ordrt to restore this base backup I need the contents of the base backup and this WAL log
0000000200000111000000CD,is that correct?
 

Yes.

Yours,
Laurenz Albe

pgsql-admin by date:

Previous
From: Techie
Date:
Subject: Re: PITR WAL Restore and configuration
Next
From: Khangelani Gama
Date:
Subject: upgrading postgres 7.3.4 to 9.1.9