Hacker News new | ask | show | jobs
by Ocha 251 days ago
Until coolify and similar projects support DB backups with streaming replication, it will just remain as a hobby project and won’t be used for anything customer facing.

Docker compose and bash script is all I need to run 2 vms, with hourly backups to s3 + wal streaming to s3 + PG and redis streaming replication to another vm. That is bare minimum for production

1 comments

Any pointers in how you run the backups and Wal streaming?
Not the original commenter, but I've used https://github.com/wal-g/wal-g before for this and had a good experience with it.

If you haven't done so already, I'd highly recommend reading the postgres documentation about continuous backups before setting it up, as it teaches the fundamentals: https://www.postgresql.org/docs/current/continuous-archiving...