Open leschiffres opened 3 weeks ago
You'll need a few things for that to work, and it's pretty much the same list for any data source. :smile:
You'll need to know the correct IP address (or dns domain name or similar) for connecting to the database
The data source (PostgreSQL in this instance) has to be actually listening on that IP address and not have anything blocking incoming connections from your source IP address
If the data source has its own security & authentication mechanisms, these have to be configured to allow access
pg_hba.conf
) to configure which IP addresses it'll allow connections from. Redash will generally give an error message with details about your source IP not being allowed when this is the problem. Generally it's not too hard to fix.... and I'm pretty sure there's one more thing that's obvious which is not coming immediately to mind though. Hmmm, I probably need more coffee. :wink:
Anyway, the above 3 should get you started in resolving the problem. If the connection is just timing out when it tries to connect, then it's probably either item 1 or 2 above.
I have set up locally a redash instance and I try to access my local postgres instances, but connection fails. However I can access these with the same credentials from my terminal. What do I need to do, to establish connection?