watsonx.data

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!