PostgreSQL connection error

aad34210
Level 3
PostgreSQL connection error

Hi.

I faced PostgreSQL connection error on "DSS Settings > Connections > New PostgreSQL connection" screen.

It shows error like following image when I click "TEST" button.



DSS server and PostgreSQL server has installed same AWS EC2 machine. 

And I can connect dvdrental database which in following image successfully using this user via psql.



Could anyone please advice me how to connect this PostgreSQL server via DSS ?





Best regards.

Thank you.

0 Kudos
1 Reply
aad34210
Level 3
Author

I resolved this issue myself.



pg_hba.conf file value set following "md5".

I changed this value "trust" then I can connect via DSS. 

====

[Before change]

local   all             all                                     md5

host    all             all             127.0.0.1/32            ident



[After change]

local   all             all                                     trust

host    all             all             127.0.0.1/32            trust 

====



But these change are for test connection purpose only.

I recommend to consider each usage situation / environment security settings.



 

0 Kudos