Re: Is there a continuous backup for pg ? - Mailing list pgsql-general

From Gary M
Subject Re: Is there a continuous backup for pg ?
Date
Msg-id CAGwOJnygd+KEU=ebjTVPxVr6JO8u4HNuok94k0CXPVr=xEaxGw@mail.gmail.com
Whole thread Raw
In response to Re: Is there a continuous backup for pg ?  (Vick Khera <vivek@khera.org>)
Responses Re: Is there a continuous backup for pg ?  (raf@raf.org)
List pgsql-general
Vick,

I would love to use ZFS, this project requires RHEL/SeLinux MLS. Without MLS and RH support, ZFS is a no-go.  

On Fri, Mar 2, 2018 at 2:34 PM, Vick Khera <vivek@khera.org> wrote:
On Fri, Mar 2, 2018 at 2:34 PM, Gary M <garym@oedata.com> wrote:
Thanks Josh,

PITR is the option I was recommending. Project management diligence dictates I need at least one other option from a different recommending source, two other options optimally. 

File system snapshot on a robust system like ZFS. Rollback to any snapshot almost trivially, and view any snapshot trivially. 

pgsql-general by date:

Previous
From: Paul Costello
Date:
Subject: Re: Jira database won't start after disk filled up
Next
From: Dale Seaburg
Date:
Subject: SQL syntax