Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgadmin-hackerspgsql-adminpgsql-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

pgsql-hackers by date

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

pgsql-admin by date

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

pgadmin-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group