Re: Is there a continuous backup for pg ?

> On Mar 2, 2018, at 11:05 AM, Gary M <garym(at)oedata(dot)com> 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 ?

Sounds almost like you're looking for point-in-time recovery, which will let you restore an entire cluster to any time in the past (if you can afford the storage), using physical replication.

https://www.postgresql.org/docs/current/static/continuous-archiving.html

There are several sets of third-party tools that'll help with the setup, monitoring and other tooling. Look for omnipitr or pitrtools.

(I'd guess you could build something similar that would let you do logical recovery by recording changesets from a logical replication connection, but I don't know if anyone has put that together.)

Cheers,
Steve