Best Database Backup Solution

[yohaoquan]

First Check

• I added a very descriptive title here.
• I used the GitHub search to find a similar question and didn't find it.
• I searched in the documentation/README.
• I already searched in Google "How to do X" and didn't find any information.
• I already read and followed all the tutorial in the docs/README and didn't find an answer.

Commit to Help

• I commit to help with one of those options 👆

Example Code

N/A

Description

Hi all!

I have been trying to adopt this project for my self-hosted dashboard and I want to make sure that DB is regularly backed up to host/an alternative location.

The docker-compose.yml setup ensured that the DB was not directly accessible from the host in a production environment, which is a good security practice, but this also limited the number of options(and all of the solutions I regularly use) by quite a bit.

Could someone recommend me a good way to do this without compromising security?

Operating System

Linux

Operating System Details

N/A

Python Version

Python 3.12.2

Additional Context

No response

[peter-cognicode]

i have used this in the past:
https://github.com/eeshugerman/postgres-backup-s3

It is running in docker, do it can have access to your db, and it will upload an encrypted backup of the database to an S3 bucket. You could use any cloud provider for that or a cheap hosting alternative is Contabo