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