Re: Replaying archived wal files after a dump restore?

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Jeff Frost <jeff(at)frostconsultingllc(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Replaying archived wal files after a dump restore?
Date: 2005-10-25 03:09:51
Message-ID: 20051025030951.GA16642@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers pgsql-admin pgsql-hackers

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(at)frostconsultingllc(dot)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.

In response to

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message svn 2005-10-25 07:30:19 SVN Commit by dpage: r4613 - in trunk/pgadmin3: . pkg/win32/src
Previous Message svn 2005-10-24 16:56:41 SVN Commit by andreas: r4612 - trunk/www/pgadmin3/cnt

Browse pgsql-admin by date

  From Date Subject
Next Message Gourish Singbal 2005-10-25 09:08:33 Re: excluding a table from pg_dump
Previous Message Scott Marlowe 2005-10-24 15:28:02 Re: [PERFORM] Need help in setting optimal configuration

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruno Wolff III 2005-10-25 03:20:39 Re: PG Killed by OOM Condition
Previous Message Tom Lane 2005-10-25 03:09:39 Re: [GENERAL] 'a' == 'a '