PostgreSQL connection error

Options
aad34210
aad34210 Partner, Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Registered Posts: 25 Partner

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.

Tagged:

Answers

  • aad34210
    aad34210 Partner, Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Registered Posts: 25 Partner
    Options

    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.

Setup Info
    Tags
      Help me…