0 votes

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.

by

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             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.

 

ago by
1,188 questions
1,220 answers
1,363 comments
11,751 users

┬ęDataiku 2012-2018 - Privacy Policy