Question

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

Posted January 6, 2020 306 views
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

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.

×
1 answer

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

Submit an Answer