Re: backup.old - Mailing list pgsql-general

From David G. Johnston
Subject Re: backup.old
Date
Msg-id CAKFQuwbuOHVYfBZqNjB5FtJKBCE3A3bcyAMXY34evK-W7CajVA@mail.gmail.com
Whole thread Raw
In response to Re: backup.old  (Steve Pribyl <Steve.Pribyl@akunacapital.com>)
Responses Re: backup.old
List pgsql-general
On Wed, Oct 7, 2015 at 3:16 PM, Steve Pribyl <Steve.Pribyl@akunacapital.com> wrote:

Great, dur(rtfm), so is it save to delete the backup.old, if the db is not in backup mode.   

​I don't see anything that would cause "backup.old" to be linked to an active backup if there was one in progress...and as far as I can tell a successfully completed backup doesn't leave around any such file either.  So it should be safe to delete regardless of what pg_is_in_backup returns.  If that returns true then I would be concerned that something (or someone) else is messing with the backup/data directory ​and that something likely also introduced backup.old

David J.

pgsql-general by date:

Previous
From: Paul Ramsey
Date:
Subject: PostGIS 2.2.0 Released
Next
From: Marc Mamin
Date:
Subject: Re: Best practices for aggregate table design