How to connect to remote database on digital Ocean with pycharm ?

Posted on January 6, 2020

DigitalOcean Managed PostgreSQL Database

I am using Pycharm and I would like to connect to remote database to edit it. However I have this following error : [08P01] ERROR: no such database: [08P01] ERROR: no such database: ` I insert those features in the correct properties of pycharm :

username = api_admin password = **************** show host = db-postgresql-lon1-49627-do-user-6682481-0.db.ondigitalocean.com port = 25061 database = Test sslmode = require

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.

alexdo

February 29, 2020

Hello, @devjo

Can you make sure that the database name is named Test with a capital “T” ? My assumption will be that there might be a typo here, hence you’re getting the error - [08P01] ERROR: no such database

Let me know how it goes.

Regards, Alex