Is it possible to connect to a Postgres instance from a Dremio instance when both of them are running on the same host and via Docker using host's IP?

1

Hi all!

I was wondering if it is possible to connect to a Postgres instance from a Dremio instance when both of them are running on the same host (machine 1) and via Docker. (I would like to use the host’s IP address instead of container’s IP address)

FYI 1: I ran another Dremio instance in another host (machine 2) and I was able to connect to the Postgres instance using machine 1’s IP address. But for some reason, when trying the same settings when both of the containers are in machine 1, it is not working.

FYI 2: I went inside the Dremio container and tried ping, nslookup and nmap, and all of them are working.

2

@DremioUser What error is the log printing? Could it be that pg_hba.conf does not have the righ IP address to alllow the Dremio host to access even though same machine

3

@DremioUser did you try with the correct hostname and port association? For example, for our case in postgres we have say hostname “example-host” and ports “9000:5432”. When we connect it with dremio as a source, for the host we write “example-host” and for the port “5432”