On Tue, Apr 24, 2018 at 10:50 AM, David Gauthier
wrote:
> Typically, I would think doing a weekly full backup, daily incremental
> backups and turn on journaling to capture what goes on since the last
> backup.
>
This is almost the whole concept of the streaming replication built into
postgres,
On 04/24/2018 07:50 AM, David Gauthier wrote:
Hi: I need some advise on how best to backup a PG DB.
PG 9.5.2 on RHEL6
The requirement is to be able to restore the DB after catastrophic
failure and lose no more than the last 15 minutes worth of data. Also,
we would like to be able to do the b
Hi: I need some advise on how best to backup a PG DB.
PG 9.5.2 on RHEL6
The requirement is to be able to restore the DB after catastrophic failure
and lose no more than the last 15 minutes worth of data. Also, we would
like to be able to do the backups on-line (no down time). There is no need
f
