Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
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 ?
I resolved this issue myself.
pg_hba.conf file value set following "md5".
I changed this value "trust" then I can connect via DSS.
local all all md5
host all all 127.0.0.1/32 ident
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.