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 pg_dump/pg_dumpall would have to be run manually, I’m looking for a way to do scheduled regular backups of my database

Submit an answer

This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

Sign In or Sign Up to Answer

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.

Want to learn more? Join the DigitalOcean Community!

Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.

Hello, @l0qii

Backups are handled automatically and included to you at no additional fee. Full backups are taken everyday and write-ahead-logs are maintained to allow you to restore to any point-in-time during the retention period.

You an check our official Docs for the Managed PosfreSQL Database here:

And check the tutorial on how to restore a PosfreSQL cluster from Backups:

You can also manually backup your databases using the dokku-postgres plugin as well. You can check this article as well:

With this command you can manually backup PostgreSQL Database to DigitalOcean Spaces:

dokku postgres:backup dbname bucketname

Hope this helps!

Regards, Alex

I looked around and didn’t find this answer at the moment, followed the Postgres how to mostly. With default postgresql-client you might get an error because the client and server have different versions, for me the server had postgresql-server-11.

So install the same version for the client following the official guide

# Create the file repository configuration:
sudo sh -c 'echo "deb $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'

# Import the repository signing key:
wget --quiet -O - | sudo apt-key add -

# Update the package lists:
sudo apt-get update

# Install the latest version of PostgreSQL.
# If you want a specific version, use 'postgresql-12' or similar instead of 'postgresql':
sudo apt-get install postgresql-client-11

And when done you can backup

pg_dump -d your_db_uri_here > backup_yourDB_todayDate.sql