How can I update or import my database in digital ocean?

Posted on October 25, 2022

DigitalOcean Managed PostgreSQL Database

I am new to digital ocean, I have a project in django (python) that has already been uploaded, previously it saved data without problems. I did an update and when saving data it sends me errors like:

relationship “Customers_representative” does not exist LINE 1: INSERT IN “Customers_representative” (“representative”, "na…

I guess the problem is with the database, I was told by a developer that I have to import the database into Digital Ocean My question is as follows:

How do I import my database to my project?
Do I have to hire a service to host the database and update it there?
Why did it work before and save data without contracting the database service and now it doesn’t?

Thank you

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!

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.

KFSys

October 25, 2022

Hi @d1c689ff6efa-4b46-b74c-af3353,

You need to have your Data stored in a database somewhere. It’s not specifically needed to be done on DigitalOcean. Having said that, it is easier to manage everything from one space.

I’ll recommend using DigitalOcean’s Manage Database solutions. There is the documentation for almost everything and just following it you should be able to deploy it without a problem:

https://docs.digitalocean.com/products/databases/

In terms of PostgreSQL you can check the following link:

https://docs.digitalocean.com/products/databases/postgresql/

Here is the know-how to upload :

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