From: Bruno Wolff III <bruno@wolff.to>
To: Jeff Frost <jeff@frostconsultingllc.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Replaying archived wal files after a dump restore?
Date: Mon, 24 Oct 2005 22:09:51 -0500
Message-ID: <20051025030951.GA16642@wolff.to> (raw)
In-Reply-To: <Pine.LNX.4.63.0510031124330.5115@discord.dyndns.org>
References: <43407865.7090706@pse-consulting.de>
<20051003052744.GF4490@fetter.org>
<Pine.LNX.4.63.0510031124330.5115@discord.dyndns.org>
Please don't reply to existing threads to start new ones. That is probably why
your message didn't get any replies.
On Mon, Oct 03, 2005 at 11:25:25 -0700,
Jeff Frost <jeff@frostconsultingllc.com> wrote:
> Is it at all possible to manually replay archived WAL files after restoring
> from a pg_dump dumpfile?
You probably want to look at:
http://candle.pha.pa.us/main/writings/pgsql/sgml/backup-online.html
That is from the soon to be released 8.1 documentation. PITR is available
in 8.0, but I believe there were enhancements made to the tools for using
it in 8.1.
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: bruno@wolff.to, jeff@frostconsultingllc.com
Subject: Re: Replaying archived wal files after a dump restore?
In-Reply-To: <20051025030951.GA16642@wolff.to>
References: <43407865.7090706@pse-consulting.de> <20051003052744.GF4490@fetter.org> <Pine.LNX.4.63.0510031124330.5115@discord.dyndns.org> <20051025030951.GA16642@wolff.to>
* 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