Re: Is there a continuous backup for pg ?

2018-03-04 Thread Sameer Kumar
On Mon, Mar 5, 2018 at 6:58 AM wrote: > Gary M wrote: > > > Vick, > > > > I would love to use ZFS, this project requires RHEL/SeLinux MLS. Without > > MLS and RH support, ZFS is a no-go. > > btrfs could be an option. it does mostly the same things as zfs. > AFAIK, btrfs is also not supported on

Re: Is there a continuous backup for pg ?

2018-03-04 Thread raf
Gary M wrote: > Vick, > > I would love to use ZFS, this project requires RHEL/SeLinux MLS. Without > MLS and RH support, ZFS is a no-go. btrfs could be an option. it does mostly the same things as zfs. > On Fri, Mar 2, 2018 at 2:34 PM, Vick Khera wrote: > > > On Fri, Mar 2, 2018 at 2:34 PM, G

Re: Is there a continuous backup for pg ?

2018-03-02 Thread Gary M
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 wrote: > On Fri, Mar 2, 2018 at 2:34 PM, Gary M wrote: > >> Thanks Josh, >> >> PITR is the option I was recommending. Project management

Re: Is there a continuous backup for pg ?

2018-03-02 Thread Vick Khera
On Fri, Mar 2, 2018 at 2:34 PM, Gary M 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

Re: Is there a continuous backup for pg ?

2018-03-02 Thread Gary M
Thanks everyone !! I think I have enough alternatives for this project. I'll start testing on Monday.. have a good weekend -g On Fri, Mar 2, 2018 at 12:55 PM, David Steele wrote: > Hi Gary, > > On 3/2/18 2:05 PM, Gary M wrote: > > Hi, > > > > I have an unusual requirement for schema based, liv

Re: Is there a continuous backup for pg ?

2018-03-02 Thread David Steele
Hi Gary, On 3/2/18 2:05 PM, Gary M wrote: > Hi, > > I have an unusual requirement for schema based, live backup of a 24/7 > database processing 100K inserts/updates per hour. The data store is > around 100TB. > > The requirement is supporting an incremental backup of 10 minute > windows.  Replic

Re: Is there a continuous backup for pg ?

2018-03-02 Thread Gary M
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. On Fri, Mar 2, 2018 at 12:16 PM, Joshua D. Drake wrote: > On 03/02/2018 11:05 AM, Gary M wrote: > >> Hi,

Re: Is there a continuous backup for pg ?

2018-03-02 Thread Steve Atkins
> On Mar 2, 2018, at 11:05 AM, Gary M wrote: > > Hi, > > I have an unusual requirement for schema based, live backup of a 24/7 > database processing 100K inserts/updates per hour. The data store is around > 100TB. > > The requirement is supporting an incremental backup of 10 minute windows.

Re: Is there a continuous backup for pg ?

2018-03-02 Thread Joshua D. Drake
On 03/02/2018 11:05 AM, Gary M wrote: Hi, I have an unusual requirement for schema based, live backup of a 24/7 database processing 100K inserts/updates per hour. The data store is around 100TB. The requirement is supporting an incremental backup of 10 minute windows.  Replication is not co

Is there a continuous backup for pg ?

2018-03-02 Thread Gary M
Hi, I have an unusual requirement for schema based, live backup of a 24/7 database processing 100K inserts/updates per hour. The data store is around 100TB. The requirement is supporting an incremental backup of 10 minute windows. Replication is not considered backup from malicious action. Are t