pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_start_backup without WAL archiving
5+ messages / 4 participants
[nested] [flat]
* pg_start_backup without WAL archiving
@ 2007-11-25 14:24 Peter Eisentraut <peter_e@gmx.net>
0 siblings, 2 replies; 5+ messages in thread
From: Peter Eisentraut @ 2007-11-25 14:24 UTC (permalink / raw)
To: pgsql-admin
Why is it not allowed to call pg_start_backup when WAL archiving is off?
Wouldn't this be useful as a discrete file system backup without PITR
capability?
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: pg_start_backup without WAL archiving
@ 2007-11-25 15:33 Jeff Larsen <jlar310@gmail.com>
parent: Peter Eisentraut <peter_e@gmx.net>
1 sibling, 1 reply; 5+ messages in thread
From: Jeff Larsen @ 2007-11-25 15:33 UTC (permalink / raw)
To: pgsql-admin
On Nov 25, 2007 8:24 AM, Peter Eisentraut <peter_e@gmx.net> wrote:
> Why is it not allowed to call pg_start_backup when WAL archiving is off?
> Wouldn't this be useful as a discrete file system backup without PITR
> capability?
Because a file system level backup is no good unless the database is
stopped, or you are using PITR.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: pg_start_backup without WAL archiving
@ 2007-11-25 16:04 Peter Eisentraut <peter_e@gmx.net>
parent: Jeff Larsen <jlar310@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: Peter Eisentraut @ 2007-11-25 16:04 UTC (permalink / raw)
To: pgsql-admin; +Cc: Jeff Larsen <jlar310@gmail.com>
Jeff Larsen wrote:
> On Nov 25, 2007 8:24 AM, Peter Eisentraut <peter_e@gmx.net> wrote:
> > Why is it not allowed to call pg_start_backup when WAL archiving is off?
> > Wouldn't this be useful as a discrete file system backup without PITR
> > capability?
>
> 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.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: pg_start_backup without WAL archiving
@ 2007-11-25 18:02 Tom Lane <tgl@sss.pgh.pa.us>
parent: Peter Eisentraut <peter_e@gmx.net>
0 siblings, 0 replies; 5+ messages in thread
From: Tom Lane @ 2007-11-25 18:02 UTC (permalink / raw)
To: Peter Eisentraut <peter_e@gmx.net>; +Cc: pgsql-admin@postgresql.org, "Jeff Larsen" <jlar310@gmail.com>
Peter Eisentraut <peter_e@gmx.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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: pg_start_backup without WAL archiving
@ 2007-11-26 08:20 Simon Riggs <simon@2ndquadrant.com>
parent: Peter Eisentraut <peter_e@gmx.net>
1 sibling, 0 replies; 5+ messages in thread
From: Simon Riggs @ 2007-11-26 08:20 UTC (permalink / raw)
To: Peter Eisentraut <peter_e@gmx.net>; +Cc: pgsql-admin
On Sun, 2007-11-25 at 15:24 +0100, Peter Eisentraut wrote:
> Why is it not allowed to call pg_start_backup when WAL archiving is off?
> Wouldn't this be useful as a discrete file system backup without PITR
> capability?
I'm submitting a patch today that better describes PITR facilities for
making a standalone backup.
--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2007-11-26 08:20 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-11-25 14:24 pg_start_backup without WAL archiving Peter Eisentraut <peter_e@gmx.net>
2007-11-25 15:33 ` Jeff Larsen <jlar310@gmail.com>
2007-11-25 16:04 ` Peter Eisentraut <peter_e@gmx.net>
2007-11-25 18:02 ` Tom Lane <tgl@sss.pgh.pa.us>
2007-11-26 08:20 ` Simon Riggs <simon@2ndquadrant.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox