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.
Answers
-
aad34210 Partner, Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Registered Posts: 25 Partner
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.