pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Replaying archived wal files after a dump restore?
4+ messages / 3 participants
[nested] [flat]

* Replaying archived wal files after a dump restore?
@ 2005-10-03 18:25  Jeff Frost <jeff@frostconsultingllc.com>
  0 siblings, 1 reply; 4+ messages in thread

From: Jeff Frost @ 2005-10-03 18:25 UTC (permalink / raw)
  To: pgsql-admin

Is it at all possible to manually replay archived WAL files after restoring 
from a pg_dump dumpfile?

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



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Replaying archived wal files after a dump restore?
@ 2005-10-25 03:09  Bruno Wolff III <bruno@wolff.to>
  parent: Jeff Frost <jeff@frostconsultingllc.com>
  0 siblings, 1 reply; 4+ messages in thread

From: Bruno Wolff III @ 2005-10-25 03:09 UTC (permalink / raw)
  To: Jeff Frost <jeff@frostconsultingllc.com>; +Cc: 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.



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Replaying archived wal files after a dump restore?
@ 2005-10-25 15:55  Jeff Frost <jeff@frostconsultingllc.com>
  parent: Bruno Wolff III <bruno@wolff.to>
  0 siblings, 1 reply; 4+ messages in thread

From: Jeff Frost @ 2005-10-25 15:55 UTC (permalink / raw)
  To: Bruno Wolff III <bruno@wolff.to>; +Cc: pgsql-admin

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

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@frostconsultingllc.com>
Frost Consulting, LLC 	http://www.frostconsultingllc.com/
Phone: 650-780-7908	FAX: 650-649-1954



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Replaying archived wal files after a dump restore?
@ 2005-10-25 20:33  Alvaro Herrera <alvherre@alvh.no-ip.org>
  parent: Jeff Frost <jeff@frostconsultingllc.com>
  0 siblings, 0 replies; 4+ messages in thread

From: Alvaro Herrera @ 2005-10-25 20:33 UTC (permalink / raw)
  To: Jeff Frost <jeff@frostconsultingllc.com>; +Cc: Bruno Wolff III <bruno@wolff.to>; pgsql-admin

Jeff Frost wrote:

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

Oh, so the data in the log must be very valuable to you.  I guess you
could extract the data if you processed the WAL logs.  A tool to do this
doesn't exist as far as I know, but you could write your own.  There was
a crude hack by Tom Lane, which you can find on the archives:

From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Mohan, Ross" <RMohan@arbinet.com>
Cc: pgsql-admin@postgresql.org
Date: Wed, 13 Apr 2005 10:26:09 -0400
Subject: Re: [ADMIN] question about wal and point in time recovery

It would be nice to expand on this tool.

-- 
Alvaro Herrera                                http://www.PlanetPostgreSQL.org
"Coge la flor que hoy nace alegre, ufana. ¿Quién sabe si nacera otra mañana?"



^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2005-10-25 20:33 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-10-03 18:25 Replaying archived wal files after a dump restore? Jeff Frost <jeff@frostconsultingllc.com>
2005-10-25 03:09 ` Bruno Wolff III <bruno@wolff.to>
2005-10-25 15:55   ` Jeff Frost <jeff@frostconsultingllc.com>
2005-10-25 20:33     ` Alvaro Herrera <alvherre@alvh.no-ip.org>

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