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 <j...@commandprompt.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. ***** > >