0 votes

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.


1 Answer

0 votes

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               ident

[After change]
local   all             all                                     trust
host    all             all               trust 

But these change are for test connection purpose only.
I recommend to consider each usage situation / environment security settings.


1,299 questions
1,327 answers
11,867 users

┬ęDataiku 2012-2018 - Privacy Policy