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