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

From Joshua D. Drake
Subject Re: Is there a continuous backup for pg ?
Date
Msg-id 04017120-1936-3e85-c079-bc0d8083dbfd@commandprompt.com
Whole thread Raw
In response to Is there a continuous backup for pg ?  (Gary M <garym@oedata.com>)
Responses Re: Is there a continuous backup for pg ?  (Gary M <garym@oedata.com>)
List pgsql-general
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: Gary M
Date:
Subject: Is there a continuous backup for pg ?
Next
From: Steve Atkins
Date:
Subject: Re: Is there a continuous backup for pg ?