Hi @Nickolus Plowden,
I'm a student that is now learning how to use IBM watsonx.
Is is possible to set a postgresql database run locally from a docker as a data source on IBM watsonx?
I'll paste a community thread not written by me but that explains exactly the problem i'm having: 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?
thanks if there is answers