New to Dataiku DSS? Try out our NEW Quick Start Programs today and get onboarded on the product in just one hour! Let's go

PostgreSQL connection error

Level 3
PostgreSQL connection error


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
Level 3

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.


0 Kudos
Labels (2)
A banner prompting to get Dataiku DSS