News for hackers. Stuff that matters.
Re:PGHoard – PostgreSQL backup and restore service for cloud... by scottshamus on Friday March 01, 2019 @05:28PM (#19285968)
I'm going to look at this more later, but my first thought is how does this compare to WAL-e https://github.com/wal-e/wal-e
Re:PGHoard – PostgreSQL backup and restore service for cloud... by bruce_one on Friday March 01, 2019 @05:32PM (#19285988)
[WAL-G](https://github.com/wal-g/wal-g) is another alternative, and is sold as a successor to WAL-E, just in case if you haven't heard of it :-)
Re:PGHoard – PostgreSQL backup and restore service for cloud... by bjoko on Friday March 01, 2019 @05:41PM (#19286048)
There has been a discussion about WAL-G just a few days ago here on HN https://news.ycombinator.com/item?id=19259099
Re:PGHoard – PostgreSQL backup and restore service for cloud... by AznHisoka on Friday March 01, 2019 @06:32PM (#19286332)
In my experience, WAL-E is very brittle and fails with weird errors at times such as when your database restarts, or when it fails to upload a segment.

I have gone back to using pg_dump even though its not a real-time snapshot. In the end, replication + pg_dump gets the job done

Re:PGHoard – PostgreSQL backup and restore service for cloud... by brianwawok on Friday March 01, 2019 @10:31PM (#19287337)
I added a pager duty alert to my wall-e when backups stop. Happen once or so a month. Not ideal but I just poke it with a stick and it comes back.
Re:PGHoard – PostgreSQL backup and restore service for cloud... by Tostino on Friday March 01, 2019 @11:38PM (#19287599)
I switched from wal-e to pgbackrest a couple years ago. Totally worth it.