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

Re: Replaying archived wal files after a dump restore?

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Jeff Frost <jeff(at)frostconsultingllc(dot)com>
Cc: Bruno Wolff III <bruno(at)wolff(dot)to>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Replaying archived wal files after a dump restore?
Date: 2005-10-25 20:33:45
Message-ID: (view raw or whole thread)
Lists: pgadmin-hackerspgsql-adminpgsql-hackers
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(at)sss(dot)pgh(dot)pa(dot)us>
To: "Mohan, Ross" <RMohan(at)arbinet(dot)com>
Cc: pgsql-admin(at)postgresql(dot)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                      
"Coge la flor que hoy nace alegre, ufana. ¿Quién sabe si nacera otra mañana?"

In response to

pgsql-hackers by date

Next:From: Yohanes SantosoDate: 2005-10-25 20:37:34
Subject: Re: determining random_page_cost value
Previous:From: Robert TreatDate: 2005-10-25 20:04:35
Subject: Re: expanded \df+ display broken in beta4

pgsql-admin by date

Next:From: Alvaro HerreraDate: 2005-10-25 20:35:35
Subject: Re: files to ignore during pitr base backup
Previous:From: Kishore BDate: 2005-10-25 20:18:16
Subject: Why different execution times for different instances for the same query?

pgadmin-hackers by date

Next:From: Florian G. PflugDate: 2005-10-26 15:56:10
Subject: Re: Default extension for sql scripts
Previous:From: svnDate: 2005-10-25 20:01:31
Subject: SVN Commit by dpage: r4618 - trunk/pgadmin3/pkg/mac

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