Re: Is there a continuous backup for pg ?

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 <jd(at)commandprompt(dot)com>
wrote:

> 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 considered backup from malicious action.
>>
>> Are there any best practices or solutions that can meet these
>> requirements ?
>>
>
> A cold standby using PITR?
>
> JD
>
>
>> b/r
>> gary
>>
>
>
> --
> Command Prompt, Inc. || http://the.postgres.company/ || @cmdpromptinc
>
> PostgreSQL centered full stack support, consulting and development.
> Advocate: @amplifypostgres || Learn: https://postgresconf.org
> ***** Unless otherwise stated, opinions are my own. *****
>
>