VWsFriend icon indicating copy to clipboard operation
VWsFriend copied to clipboard

configurable regular database backup

Open upelectric opened this issue 2 years ago • 3 comments

I have a suggestion for a new feature. It would be nice if I could configure a regular backup of the database to a backup volume. Currently I have to backup the database manually with the UI.

upelectric avatar Jun 23 '22 18:06 upelectric

I like the idea and it is probably pretty easy to implement. What would you think is necessary to configure. The storage location, interval and the number of backups to keep?

tillsteinbach avatar Jun 24 '22 06:06 tillsteinbach

In the meantime you can also backup the database with somethign like this:

docker exec -t your-db-container pg_dumpall -c -U postgres > dump_`date +%d-%m-%Y"_"%H_%M_%S`.sql

in a cronjob

tillsteinbach avatar Jun 24 '22 06:06 tillsteinbach

Yeah, I think storage location, interval and number of backups to keep should be enough. In the meantime I will use the docker command.

upelectric avatar Jun 24 '22 07:06 upelectric