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 md5host all all 127.0.0.1/32 ident
[After change]local all all trusthost 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.