On 03/02/2018 11:05 AM, Gary M wrote:

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?



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.   *****

Reply via email to