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 waffle_ss on Thursday April 28, 2016 @11:41AM (#11589675)
How does this compare to WAL-E?

https://github.com/wal-e/wal-e

[ Parent | on HN ]
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 ]
Re:PGHoard: Tools for making PostgreSQL backups to cloud obj... by oskari on Thursday April 28, 2016 @12:53PM (#11590226)
PGHoard also supports Google Cloud which doesn't seem to be supported in WAL-E at the moment.
[ Parent | on HN ]