Re: [ADMIN] pg_start_backup without WAL archiving

2007-11-26 Thread Simon Riggs
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

[ADMIN] pg_start_backup without WAL archiving

2007-11-25 Thread Peter Eisentraut
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/ ---(end of broadcast)--- TIP

Re: [ADMIN] pg_start_backup without WAL archiving

2007-11-25 Thread Jeff Larsen
On Nov 25, 2007 8:24 AM, Peter Eisentraut [EMAIL PROTECTED] 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

Re: [ADMIN] pg_start_backup without WAL archiving

2007-11-25 Thread Peter Eisentraut
Jeff Larsen wrote: On Nov 25, 2007 8:24 AM, Peter Eisentraut [EMAIL PROTECTED] 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

Re: [ADMIN] pg_start_backup without WAL archiving

2007-11-25 Thread Tom Lane
Peter Eisentraut [EMAIL PROTECTED] 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