Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Database incremental backups #145

Open
doug-leasure opened this issue Dec 19, 2024 · 0 comments
Open

Database incremental backups #145

doug-leasure opened this issue Dec 19, 2024 · 0 comments
Assignees
Labels
database Requires database changes

Comments

@doug-leasure
Copy link
Member

doug-leasure commented Dec 19, 2024

I wrote a shell script to do incremental backups using PostgreSQL 17 (2b2b030).

The script resulted in this error:

pg_basebackup: error: connection to server at "13.36.221.152", port 5432 failed: FATAL:  no pg_hba.conf entry for replication connection from host "82.6.90.142", user "postgres", no encryption

We will need to revise pg_hba.conf to allow appropriate connections, and this will require a bind mount to get the file into the docker container.

This is rather low priority because ./src/database/db_dump.sh is suitable for backups in the interim.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
database Requires database changes
Projects
None yet
Development

No branches or pull requests

2 participants