Re: unorthodox use of PG for a customer

2018-08-25 Thread Gary M
Hmmm I usually don't participate in forums and accidentally sent my reply to David Gauthier directly. This issue sounds interesting I'll give it another try and send the reply to the group. >From my simple, engineering hat perspective I feel this question is difficult to answer without hard num

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 w

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 unus

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: >

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