Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Error while creating a postgresql Connection.
Added on April 7, 2025 10:55AM
Likes: 0
Replies: 2
Abhishek_Chandran
Registered Posts: 2 ✭✭
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
Answers
-
Sean Dataiker, Alpha Tester, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Moderator Posts: 174 DataikerHi @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. -
I have done the first 5 steps, but regarding updating the dataiku connection setting what change needs to be done?