Export database backups in App Platform

Hello @oliverullman,

You won’t be able to connect to the database cluster using the console or cloud panel. You have to make sure that your local IP address is allowed to connect to the database via trusted sources and then you can connect to the cluster by referring to the documentation link below:

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

Once you connect to the database cluster then you can export it using pg_dump command as demonstrated in the below docs:

https://docs.digitalocean.com/products/databases/postgresql/how-to/import-databases/#export-an-existing-database

Cheers, Dikshith

Hello there,

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 PostgreSQL cluster from Backups:

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

You can also manually back up 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!

I’m curious about this too. Haven’t tried it yet.

They are not providing this out-of-the-box because they want to push the managed database solution.

As long as you’re able to run a script (along your application server) that will frequently generate a dump and is able to upload it on a S3 (or equivalent) frequently, it should be good. (The server is backing him himself)