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

Re: pg_start_backup without WAL archiving

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: pgsql-admin(at)postgresql(dot)org, "Jeff Larsen" <jlar310(at)gmail(dot)com>
Subject: Re: pg_start_backup without WAL archiving
Date: 2007-11-25 18:02:56
Message-ID: 18382.1196013776@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> Jeff Larsen wrote:
>> Because a file system level backup is no good unless the database is
>> stopped, or you are using PITR.

> You are begging the question.  If I enable WAL archiving, make a base backup 
> to a safe place, and my data center goes up in flame immediately afterwards 
> without a WAL segment being archived, that base backup should still be 
> usable.  Or maybe not.  That's the question.

And the answer is still "no".  If you don't have the entire series of
WAL files made over the period of the base backup, you're out of luck.

			regards, tom lane

In response to

pgsql-admin by date

Next:From: Stefan KaltenbrunnerDate: 2007-11-25 18:08:44
Subject: Re: Error while compiling PostgreSQL with Java
Previous:From: Jeff DavisDate: 2007-11-25 18:01:29
Subject: Re: EAV or not to EAV?

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