java - Cannot connect to database through Intellij's Data Sources and Drivers

Question

I have a problem with displaying my databse structure through Intellij's Data Sources and Drivers page. I can connect to my database which is hosted on a redhat server through using application.properties of my spring project:

spring.datasource.url=jdbc:postgresql://192.168.0.38:5432/cms_database

which works fine. Although, whenever I try to use Intellij's Data Sources and Drivers page I get an Error Message:

[3D000] FATAL: database "cms_database" does not exist.

I can test to connect to database "postgres" which returns a Connection:

DBMS: PostgreSQL (ver. 13.0) Case sensitivity: plain=lower, delimited=exact Driver: PostgreSQL JDBC Driver (ver. 42.2.5, JDBC4.2) Ping: 16 ms SSL: no

Any help would be appreciated. If you need any extra info I would be happy to post!

question from:https://stackoverflow.com/questions/65646647/cannot-connect-to-database-through-intellijs-data-sources-and-drivers

Answer 1

Try to connect with settings from this example

I think you will set hostname wrongly