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

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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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:49:14
Message-ID: 10039.1250005754@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
Kevin Kempter <kevink(at)consistentstate(dot)com> writes:
> 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?

No, there is exactly 0 hope here.  You would need a filesystem-level
backup to work from.  A restore from a pg_dump is not going to reproduce
any of the low-level details (such as OID assignments or tuple
placement) that WAL replay needs to have match.

			regards, tom lane

In response to

Responses

pgsql-admin by date

Next:From: Benjamin KrajmalnikDate: 2009-08-11 16:40:10
Subject: Re: Max connections
Previous:From: Kevin GrittnerDate: 2009-08-11 15:49:04
Subject: Re: replay WAL segments without a "base backup" ?

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