search

fradelg / docker-mysql-cron-backup

Docker image to backup all your databases periodically
Apache License 2.0
290 stars 111 forks source link

Feature Request: Support for Postgres backup #98

Open g-nardiello opened 1 year ago

g-nardiello commented 1 year ago

I really like this project, as it is simple and it works well! As I'm searching for a postgres/postgis backup mechanism like this, does it exists an equivalent solution for that? Or do you think it could be done in the future?

PS: As this project follows a very simple architecture, I don't know if it could be right to add postgres/postgis support directly into this repository. However, if it not exists an equivalent project, it could be else a good idea to develop a parallel project for supporting each different database could be intresting. This Issue could be seen not only as a directly feature request to this project, but as a starting point for others too, so I think here should be the best place to ask it!

Thank you very much Giuseppe

fradelg commented 1 year ago

Hi,

Glad you like this project! :-)

I am not aware of any postgres backup container like this but I haven't searched too much as I have always worked with MySQL. I think this project could be extended to support more than one database as long as this does not require to change the Docker base image or the programming language, which I think you wouldn't need to.

You can make you suggestion and create a PR to discuss the way this can be integrated into the code and try to reuse as much as possible the current script and code that we already have for MySQL.

Thank you for your contributions!

Technoguyfication commented 1 year ago

I plan to fork this project and convert it to run with Postgres. I have both MariaDB and Postgres databases running and this script works so well.

Skaronator commented 1 year ago

Here is a container that works with Postgres: https://github.com/prodrigestivill/docker-postgres-backup-local