Re: File system snapshots for multiple file systems - Mailing list pgsql-hackers

From Gregory Stark
Subject Re: File system snapshots for multiple file systems
Date
Msg-id 871w5g40xo.fsf@oxford.xeocode.com
Whole thread Raw
In response to Re: File system snapshots for multiple file systems  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: File system snapshots for multiple file systems  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
"Tom Lane" <tgl@sss.pgh.pa.us> writes:

> Whether it's a good idea or not is a bit debatable though.  I'm
> concerned about the WAL partition filling up (--> PANIC), especially
> if you forget to pg_stop_backup after getting your backup.

We check if pg_start_backup in effect when we an ENOSPC error on the WAL
partition and if so turn it off, clean old WAL segments, and march on.

The major concern being that someone might have a bad backup. pg_stop_backup()
could scream but they might not notice. Not sure how much more we could do
about that.

--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com Ask me about EnterpriseDB's PostGIS support!


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [PATCHES] libpq type system 0.9a
Next
From: Tom Lane
Date:
Subject: Re: [PATCHES] libpq type system 0.9a