docker-postgres-backup-local VS docker-vackup

Hey! I'm using this docker image => https://github.com/prodrigestivill/docker-postgres-backup-local Now I can create .sql.gz files in this container but when i try to restore my postgres db with this file i get errors.

Then went with https://github.com/prodrigestivill/docker-postgres-backup-local for remote productive Postgres backups, https://github.com/foorschtbar/pyd2b2 for local self-hosted docker database backups and might check out https://github.com/tiredofit/docker-db-backup because it looks promising.

I use a postgres database in a container and back it up with another container, prodrigestivill/postgres-backup-local. It dumps the database to .sql files on a schedule for me.

image: prodrigestivill/postgres-backup-local

I can highly recommend using https://github.com/prodrigestivill/docker-postgres-backup-local to back up the database to a local directory and then use duplicati or a different tool for offsite backup. A similar tool exists for MySQL, but why use MySQL? ;)

I used vackup [1] that’s been obsoleted but still works for me. However, you still need to turn of the container temporarily.

[1] https://github.com/BretFisher/docker-vackup

You need this in your life: https://github.com/BretFisher/docker-vackup

Will look into that one as the recent docker volume backup extension seems to only be for docker desktop https://www.docker.com/blog/back-up-and-share-docker-volumes-with-this-extension/ unlike its origin https://github.com/BretFisher/docker-vackup.

Docker came up with https://hub.docker.com/extensions/docker/volumes-backup-extension, to be used in Docker Desktop 4m10 or up, which is the continuation of Vackup https://github.com/BretFisher/docker-vackup.

I have also have been using Vackup for a RPi4 running docker that doesn't have ZFS.

Look at using something like vackup occasionally to backup volumes. Or occasionally run application level backups (mysqldump, pg_dump) that get stored to some location outside docker.