From: Morus Walter <morus.walter@tanto.de>
To: Pallav Kalva <pkalva@deg.cc>
Subject: Re: Online Backup and WAL archives
Date: Wed, 2 Feb 2005 16:07:29 +0100
Message-ID: <16896.60593.751654.61839@tanto-xipolis.de> (raw)
In-Reply-To: <4200E2DC.6020803@deg.cc>
References: <16895.32035.914311.612690@tanto-xipolis.de>
<15479.1107277351@sss.pgh.pa.us>
<4200E2DC.6020803@deg.cc>
Pallav Kalva writes:
>
> If I want to restore to a particular point in time lets say to the
> point in time like a day back when one of my table was dropped
> accidentally and if i want restore the archive log only to that
> particular archive log file . what is the procedure we should follow ?
> just keep the archive logs in the directory until the last archive log
> file i need or is there a command something like " restore only until
> at this archive log file " ? Also what happens to the transaction log
> files in pg_xlog directory in this scenario ? do i have to still keep
> them or they get created by themself since i am going a day back ?
>
> Is this possible in postgres 8
>
Yes. That's what PITR is about. Read the manual for details.
If you look at the recovery.conf.sample you'll find a variable
recovery_target_time that must be set. Unless I missed something this
isn't explicitly stated in the docs but the comment in the sample conf
is pretty clear.
Alternatively you can define a transaction id (recovery_target_xid).
Of course you must have a backup created before the incident and all WALs
up to the time of the incident.
Morus
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: morus.walter@tanto.de, pkalva@deg.cc
Subject: Re: Online Backup and WAL archives
In-Reply-To: <16896.60593.751654.61839@tanto-xipolis.de>
References: <16895.32035.914311.612690@tanto-xipolis.de> <15479.1107277351@sss.pgh.pa.us> <4200E2DC.6020803@deg.cc> <16896.60593.751654.61839@tanto-xipolis.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox