Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
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.
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.