Error while creating a postgresql Connection.

Abhishek_Chandran

Hi everyone, i am trying to add a postgresql connection but when i am testing the connection it shows the following error.

Operating system used: windows

Operating system used: windows

Sean

https://community.dataiku.com/discussion/44907/error-while-creating-a-postgresql-connection

Hi @Abhishek_Chandran , am I correct that you're on the free edition and so don't have a support widget on the bottom right of the screen?

It will be difficult for Dataiku to help in this situation because the problem you're having seems to be on the PostgreSQL side. From a basic search, I've found when you get a connection refused on localhost:5432, it almost always means your PostgreSQL server either isn’t running, isn’t listening on TCP/IP, or your firewall/network settings are blocking you.

Some steps that might help:
- Verify Postgres is running.
- Check that Postgres is listening on TCP/IP.
- Verify pg_hba.conf allows local TCP connections.
- Test with psql.
- Check for firewalls or port conflicts.
- Update your Dataiku connection settings.

Abhishek_Chandran

https://community.dataiku.com/discussion/comment/45767#Comment_45767

I have done the first 5 steps, but regarding updating the dataiku connection setting what change needs to be done?