Postgres Connection on Windows 10: Localhost:5432 refused

[donahuem21]

I am just getting started with Airbyte and am having trouble making a connection to my postgresql database. I followed the article and video on how to get Airbyte local opensource on to a windows computer. I have python v10, Ubunutu 22.04, hyper-v, docker desktop, docker compose, and git all installed and updated. I am using postgres v16 and cannot seem to get the port to connect to airbyte. I have checked that the port is open and went into the postgresql.conf and made sure the ports were listening on all frequencies. I have quadruple checked the authentication information. I cannot seem to get it to work, and could really use some help. Below is an image of the error and the log.

Stacktrace

Logs

2024-01-25 18:34:48 platform > Docker volume job log path: /tmp/workspace/a01f5806-938d-4fb0-8ba1-ab1d626fc380/0/logs.log
2024-01-25 18:34:48 platform > Executing worker wrapper. Airbyte version: 0.50.44
2024-01-25 18:34:48 platform > Attempt 0 to save workflow id for cancellation
2024-01-25 18:34:48 platform >
2024-01-25 18:34:48 platform > Using default value for environment variable SIDECAR_KUBE_CPU_LIMIT: '2.0'
2024-01-25 18:34:48 platform > ----- START CHECK -----
2024-01-25 18:34:48 platform > Using default value for environment variable SOCAT_KUBE_CPU_LIMIT: '2.0'
2024-01-25 18:34:48 platform >
2024-01-25 18:34:48 platform > Using default value for environment variable SIDECAR_KUBE_CPU_REQUEST: '0.1'
2024-01-25 18:34:48 platform > Using default value for environment variable SOCAT_KUBE_CPU_REQUEST: '0.1'
2024-01-25 18:34:48 platform > Using default value for environment variable LAUNCHDARKLY_KEY: ''
2024-01-25 18:34:48 platform > Checking if airbyte/destination-postgres:0.5.5 exists...
2024-01-25 18:34:49 platform > airbyte/destination-postgres:0.5.5 was found locally.
2024-01-25 18:34:49 platform > Creating docker container = destination-postgres-check-a01f5806-938d-4fb0-8ba1-ab1d626fc380-0-pndqi with resources io.airbyte.config.ResourceRequirements@6466911b[cpuRequest=,cpuLimit=,memoryRequest=,memoryLimit=,additionalProperties={}] and allowedHosts null
2024-01-25 18:34:49 platform > Preparing command: docker run --rm --init -i -w /data/a01f5806-938d-4fb0-8ba1-ab1d626fc380/0 --log-driver none --name destination-postgres-check-a01f5806-938d-4fb0-8ba1-ab1d626fc380-0-pndqi --network host -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -e DEPLOYMENT_MODE=OSS -e WORKER_CONNECTOR_IMAGE=airbyte/destination-postgres:0.5.5 -e AUTO_DETECT_SCHEMA=true -e LAUNCHDARKLY_KEY= -e SOCAT_KUBE_CPU_REQUEST=0.1 -e SOCAT_KUBE_CPU_LIMIT=2.0 -e FIELD_SELECTION_WORKSPACES= -e USE_STREAM_CAPABLE_STATE=true -e AIRBYTE_ROLE=dev -e WORKER_ENVIRONMENT=DOCKER -e APPLY_FIELD_SELECTION=false -e WORKER_JOB_ATTEMPT=0 -e OTEL_COLLECTOR_ENDPOINT=http://host.docker.internal:4317 -e FEATURE_FLAG_CLIENT=config -e AIRBYTE_VERSION=0.50.44 -e WORKER_JOB_ID=a01f5806-938d-4fb0-8ba1-ab1d626fc380 airbyte/destination-postgres:0.5.5 check --config source_config.json
2024-01-25 18:34:49 platform > Reading messages from protocol version 0.2.0
2024-01-25 18:34:53 platform > WARN StatusConsoleListener The use of package scanning to locate plugins is deprecated and will be removed in a future release
2024-01-25 18:34:53 platform > WARN StatusConsoleListener The use of package scanning to locate plugins is deprecated and will be removed in a future release
2024-01-25 18:34:53 platform > WARN StatusConsoleListener The use of package scanning to locate plugins is deprecated and will be removed in a future release
2024-01-25 18:34:53 platform > WARN StatusConsoleListener The use of package scanning to locate plugins is deprecated and will be removed in a future release
2024-01-25 18:34:54 platform > 2024-01-25 18:34:54 INFO i.a.i.d.p.PostgresDestination(main):128 - starting destination: class io.airbyte.integrations.destination.postgres.PostgresDestination
2024-01-25 18:34:54 platform > 2024-01-25 18:34:54 INFO i.a.c.i.b.IntegrationCliParser(parseOptions):126 - integration args: {check=null, config=source_config.json}

[donahuem21]

Been working on this for a few days now and my system admin just found the answer. Wanted to post here if anyone is having the same issue. We had Postgres downloaded on our local desktop and since Airbyte is running in Hyper-V the "host" name localhost was trying to connect airbyte to postgres on hyper-v (where it does not exist). So by setting the "host" name to the ip address of the virtual desktop we are on allows airbyte to connect to postgres. Hope this helps anyone else out there.

[rwask]

@donahuem21 Thanks for updating with the solution to your issue regarding the refused connection to Postgres! I have marked that as the answer and will close this out.