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

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

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Kevin Kempter" <kevink(at)consistentstate(dot)com>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: replay WAL segments without a "base backup" ?
Date: 2009-08-11 17:35:59
Message-ID: 4A8165AF02000025000298A6@gw.wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-admin
Kevin Kempter <kevink(at)consistentstate(dot)com> wrote: 
 
> Would there be a  way to force postgres to recognize the wal
> segments that werte created earlier (which according to the client
> include all tx from 3 weeks ago thru today) ?
 
No.
 
The database restored from the output of pg_dump won't have the same
object IDs, row IDs, page locations, etc.  Page images in the WAL
files won't correspond to your new database.  At all.  Period.
 
Making a PITR backup *now* (as you suggest) will allow you to recover
to what is in the database now, or (as long as you accumulate WAL
files) any future point in time.  It won't rearrange the pages in your
current database to resemble the pages in the lost database.
 
-Kevin

In response to

pgsql-admin by date

Next:From: mattcwoodDate: 2009-08-11 18:48:29
Subject: Re: PITR archive_timeout Command
Previous:From: Kevin KempterDate: 2009-08-11 17:14:07
Subject: Re: replay WAL segments without a "base backup" ?

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