Postgres Pro
Downloads
Home   >   mailing lists

Re: Is there a continuous backup for pg ? - Mailing list pgsql-general

From Gary M
Subject Re: Is there a continuous backup for pg ?
Date
Msg-id CAGwOJnxt9me3czwkAi+XQG44KR0Z0+dqDnXtN3SZd7YDZg5bpA@mail.gmail.com
Whole thread Raw
In response to Re: Is there a continuous backup for pg ?  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: Is there a continuous backup for pg ?  (Vick Khera <vivek@khera.org>)
List pgsql-general
Tree view
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@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.   *****


pgsql-general by date:

Previous
From: Steve Atkins
Date:
Subject: Re: Is there a continuous backup for pg ?
Next
From: David Steele
Date:
Subject: Re: Is there a continuous backup for pg ?