Question

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

Posted on October 25, 2022
Databases DigitalOcean Managed PostgreSQL Database Python
Asked by d1c689ff6efa4b46b74caf3353

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

Submit an answer

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

Site Moderator

• 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/