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

Re: replay WAL segments without a "base backup" ?

From: Greg Spiegelberg <gspiegelberg(at)gmail(dot)com>
To: Kevin Kempter <kevink(at)consistentstate(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: replay WAL segments without a "base backup" ?
Date: 2009-08-11 15:14:16
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
On Tue, Aug 11, 2009 at 9:05 AM, Kevin Kempter

> Hi all;
> due to operator error at one of my client sites we're trying to restore a
> deleted db.
> We did a restore with a pgdump that went fine but the dump is 3weeks old.
> they
> do have WAL segments and they claim that the WAL segments are exactly in
> line
> with the needed transactions - from a timing perspective.  However no base
> backup with pg_start_backup() and pg_stop_backup() was ever run.
> Is there any way to trick postgres into thinking that it needs to play fwd
> these WAL's?  Would it work to simply place them in a dir, create a
> recovery.conf file pointing to that dir and restart the cluster?
Doubtful.  I'm sure someone more in-the-know than I can give all the
explanation needed but if my memory serves the problem is the transaction
ID.  You restored a database in an existing cluster or new cluster and those
transactions locked up in those WAL files either A) have already occurred or
B) have not yet occurred in that cluster.

That is my understanding of it.  There may be more to it.

It'd be a neat service if such a restore were possible.
 * Have all WAL logs from the creation of database X to it's current state
 * Be able to apply those WAL logs to any cluster saying "restore only
database X to time/transaction Y"


In response to

pgsql-admin by date

Next:From: Kevin GrittnerDate: 2009-08-11 15:49:04
Subject: Re: replay WAL segments without a "base backup" ?
Previous:From: Kevin KempterDate: 2009-08-11 15:05:28
Subject: replay WAL segments without a "base backup" ?

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