Related

How much database space remains available? Question Question
Is it possible to set trusted sources for managed databases from the API or doctl? Question Question

Question

What is the recommended way to backup my managed PostgreSQL database?

Posted March 27, 2020 455 views
DigitalOcean 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

Add a comment
l0qii
By:
l0qii
Add a comment

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.

×
1 answer
alexdo March 28, 2020

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:

https://www.digitalocean.com/docs/databases/postgresql/how-to/

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

https://www.digitalocean.com/docs/databases/postgresql/how-to/restore-from-backups/

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

https://tute.io/automatic-backup-postgresql-dokku-digitalocean-spaces

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

dokku postgres:backup dbname bucketname

Hope this helps!

Regards,
Alex

Reply Report
Submit an Answer

Related

Looking for something else?

Ask a new question Search for more help