Postgres Pro
Downloads
Home   >   mailing lists

Re: Setting up continuous archiving - Mailing list pgsql-general

From David Steele
Subject Re: Setting up continuous archiving
Date
Msg-id 5d166fa2-6612-91d3-f33b-299e479d3571@pgmasters.net
Whole thread Raw
In response to Setting up continuous archiving  (Yuri Kanivetsky <yuri.kanivetsky@gmail.com>)
List pgsql-general
Tree view 
On 9/26/18 8:20 AM, Yuri Kanivetsky wrote:
> 
> I'm trying to compile a basic set of instruction needed to set up
> continuous archiving and to recover from a backup. I'm running
> PostgreSQL 9.3 on Debian Stretch system.

This is an incredibly complex topic and it is very difficult to 
implement correctly.

My advice is that you use a mature backup solution like pgBackRest or 
barman rather than rolling your own.

-- 
-David
david@pgmasters.net

pgsql-general by date:

Previous
From: Yuri Kanivetsky
Date:
Subject: Setting up continuous archiving
Next
From: Wanglin
Date:
Subject: using the nextval('sequence_name') in sql, the result maybe is notright