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

From Tom Lane
Subject Re: File system snapshots for multiple file systems
Date
Msg-id 6256.1207682776@sss.pgh.pa.us
Whole thread Raw
In response to Re: File system snapshots for multiple file systems  (Gregory Stark <stark@enterprisedb.com>)
Responses Re: File system snapshots for multiple file systems  (Magnus Hagander <magnus@hagander.net>)
List pgsql-hackers
Gregory Stark <stark@enterprisedb.com> writes:
> "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.

Not putting in the foot-gun in the first place is what we could do about
it.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [PATCHES] libpq type system 0.9a
Next
From: "Merlin Moncure"
Date:
Subject: Re: [PATCHES] libpq type system 0.9a