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