What is the recommended way to backup my managed PostgreSQL database?
I don’t see any backup options in the DO admin UI like I do for other droplets.
I’ve tried pg_dumpall but I get this error
FATAL: no pg_hba.conf entry for host “<IP>”, user “<ADMIN>”, database “template1”, SSL off
Also pgdump/pgdumpall would have to be run manually, I’m looking for a way to do scheduled regular backups of my database
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.×