News for hackers. Stuff that matters.

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

Re:PGHoard: Tools for making PostgreSQL backups to cloud obj... by melor on Thursday April 28, 2016 @11:56AM (#11589793)
Both do mostly the same thing with some differences. The biggest difference currently could be that WAL-E uses the PostgreSQL "archive_command" to send incremental backups (WAL files) in complete 16 megabyte chunks, whereas PGHoard uses real-time streaming with "pg_receivexlog", making the data loss window much smaller in case of a disaster.
[ Parent | on HN ]
Re:PGHoard: Tools for making PostgreSQL backups to cloud obj... by willlll on Thursday April 28, 2016 @01:37PM (#11590577)
You can set archive_timeout to something like 1 minute to bound the window.
[ Parent | on HN ]