Re: Replaying archived wal files after a dump restore? - Mailing list pgsql-admin

From Bruno Wolff III
Subject Re: Replaying archived wal files after a dump restore?
Date
Msg-id 20051025030951.GA16642@wolff.to
Whole thread Raw
In response to Replaying archived wal files after a dump restore?  (Jeff Frost <jeff@frostconsultingllc.com>)
Responses Re: Replaying archived wal files after a dump restore?  (Jeff Frost <jeff@frostconsultingllc.com>)
List pgsql-admin
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.

pgsql-admin by date:

Previous
From: sualeh.fatehi@gmail.com
Date:
Subject: Re: Monitoring database for changes - backup purposes
Next
From: Gourish Singbal
Date:
Subject: Re: excluding a table from pg_dump