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

0
votes

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!

1
javapostgresqlintellij-ideajdbc
do you have proper permission setup in pg_hba.conf file? looks like insufficient access rights. - Yuri Win

1 Answers

0
votes

Try to connect with settings from this example

enter image description here

I think you will set hostname wrongly