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
[ Parent
| on HN ]
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.