Question

Django Managed Postgres DB How to access DB. to CREATE SCHEMA

Posted July 4, 2021 238 views
PostgreSQLDjango

I’ve deployed Django App on APP PLATFORM successfuly. My App requires the setup of Postgres DB Schemas … used with sub-domains in a multi tenancy application. I have setup a Managed Database [production]. How do I access this database so as to CREATE schemas?

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

Hi @Softserveapps,

You can go to the database cluster overview page and fetch the Postgres database cluster connection string to connect.

The below links can guide you with connection to Postgres Managed database:

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

https://docs.digitalocean.com/products/app-platform/how-to/manage-databases/#connect-to-a-database

I hope this helps!

Regards,
Rajkishore

  • @Rajkishore … Yes it did … now trying to migrate tables to database via the console … Django …* ./manage.py makemigrations* results in the process hanging on “OpenBLAS WARNING - could not determine the L2 cache size on this system, assuming 256k” … am I missing something?

  • Hi again … any feedback … really need to know how to proceed … if not possible in App Platform then I must try the Droplet approach. Please advise …

    ALSO: The database tag on OVERVIEW page is highlighted in RED … why is this? Anything I need to know?