I have two components in my App Platform: a PostgreSQL database and Node. I occasionally want to export a backup of my database so that I can import it locally. How can I do this on AppPlatform? I’ve tried a few things, but there have been restrictions (such as not being able to run sudo or not being able to push to github) that have caused those attempts to not work

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.

×
Submit an Answer
1 answer

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

  • @dikshith thanks for your response. You answered something that I didn’t know I needed to know, but I’m glad you did because I surely would have ran into that problem!
    The main thing I was originally trying to find out (sorry for not making this more clear) is, once you have your db backup, how can you get it into your local computer? I tried GitHub, but it seems like there’s some sort of block preventing me from pushing, and I can’t install aws CLI tools to push to an S3 bucket because I can’t use sudo