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

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

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 https://www.postgresql.org/download/

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

# Import the repository signing key:
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | 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