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

Re: Replaying archived wal files after a dump restore?

From: Jeff Frost <jeff(at)frostconsultingllc(dot)com>
To: Bruno Wolff III <bruno(at)wolff(dot)to>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Replaying archived wal files after a dump restore?
Date: 2005-10-25 15:55:06
Message-ID: Pine.LNX.4.64.0510250851380.17611@discord.dyndns.org (view raw or flat)
Thread:
Lists: pgadmin-hackerspgsql-adminpgsql-hackers
On Mon, 24 Oct 2005, Bruno Wolff III wrote:

> Please don't reply to existing threads to start new ones. That is probably why
> your message didn't get any replies.

Point taken, but fortunately, Simon got back to me and essentially indicated 
that I was out of luck.

> 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.

Unfortunately, diffing the 8.0.4 docs against the 8.1 docs shows almost no 
useful differences.  I was mostly hoping someone with knowledge of the WAL 
internal format could tell me how to extract the transactions from some and 
manually replay them in the db via psql with lots of copy/paste action.

-- 
Jeff Frost, Owner 	<jeff(at)frostconsultingllc(dot)com>
Frost Consulting, LLC 	http://www.frostconsultingllc.com/
Phone: 650-780-7908	FAX: 650-649-1954

In response to

Responses

pgsql-hackers by date

Next:From: Yohanes SantosoDate: 2005-10-25 16:29:21
Subject: determining random_page_cost value
Previous:From: Tom LaneDate: 2005-10-25 15:16:29
Subject: Re: [PATCHES] Win32 CHECK_FOR_INTERRUPTS() performance

pgsql-admin by date

Next:From: Josh.ZeckserDate: 2005-10-25 16:28:53
Subject: Re: excluding a table from pg_dump
Previous:From: Jeff FrostDate: 2005-10-25 15:44:40
Subject: files to ignore during pitr base backup

pgadmin-hackers by date

Next:From: Andreas PflugDate: 2005-10-25 16:30:40
Subject: Re: Default extension for sql scripts
Previous:From: Florian G. PflugDate: 2005-10-25 15:09:28
Subject: Default extension for sql scripts

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