watsonx.data

 View Only

 Unable to Connect Local PostgreSQL Database to Watson X – Need Help- watson trial login

  • watsonx.data
K KARTHICK's profile image
K KARTHICK posted Wed November 13, 2024 12:02 AM

Hi Watson Community,

I’m currently trying to connect my local PostgreSQL database to Watson X(Trial login), but I keep encountering connection failures. Here’s a quick rundown of my setup and what I’ve tried so far:

  • Database Setup: My PostgreSQL instance is local (not on IBM Cloud).
  • Network Configuration: I’ve set listen_addresses = '*' in postgresql.conf and updated pg_hba.conf to allow connections from my local IP.
  • Connection String: I’ve double-checked the host, port, database name, username, and password in my connection string, and everything appears to be correct.
  • Firewall Settings: I’ve confirmed that PostgreSQL’s default port (5432) is open on my firewall.

Issue: Despite these configurations, Watson X still isn’t able to establish a connection. I’m wondering if there are any additional steps or specific settings needed to connect a local PostgreSQL database with Watson X. Also, does Watson X require SSL connections for local PostgreSQL, or could there be other compatibility requirements I’m missing?

Any advice or similar experiences would be greatly appreciated. Thanks in advance for your help!