News for hackers. Stuff that matters.

A comment on PGHoard: Tools for making PostgreSQL backups to cloud object storages.

Re:PGHoard: Tools for making PostgreSQL backups to cloud obj... by anarazel on Thursday April 28, 2016 @12:14PM (#11589911)
Do you prevent segments from being removed while they're not yet received by pg_receivexlog? wal_keep_segments or replication slots?
[ Parent | on HN ]
Re:PGHoard: Tools for making PostgreSQL backups to cloud obj... by melor on Thursday April 28, 2016 @12:19PM (#11589941)
A replication slot can be used by defining it in the pghoard.json configuration. However, the slot needs to be created (and removed after no longer needed, important!) manually. We've been planning to add more automatic replication slot management to PGHoard.
[ Parent | on HN ]
Re:PGHoard: Tools for making PostgreSQL backups to cloud obj... by anarazel on Thursday April 28, 2016 @01:00PM (#11590295)
Good. Without archiving or slots in place, you really can't rely on such backups...
[ Parent | on HN ]