Connecting to Local Services with abctl in Airbyte

Summary

Airbyte running via abctl does not support connecting to local services via localhost like the old docker-compose setup. User needs to connect to a postgres database running in a separate application via localhost:5432.


Question

Anyway to connect to local services when running airbyte on a host machine with abctl.
I have a postgres database running in a separate application via docker compose and I need to connect to that database via localhost:5432.

Running airbyte via abctl doesn’t seem to have the ability to connect to the host via localhost like you could with the old docker-compose setup



This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.

Join the conversation on Slack

["connect-local-services", "abctl", "airbyte-platform", "postgres-database", "localhost"]

After some digging it is possible to connect to PostgreSQL


kubectx kind-airbyte-abctl

kubens airbyte-abctl

kubectl port-forward airbyte-db-0 5432:5432```
and then you can connect with whatever tool
database: db-airbyte
username: airbyte
password: airbyte
host: localhost
port: 5432

kubectx, kubens are provided by <https://github.com/ahmetb/kubectx>

I am actually trying to connect to a database running on localhost on my mac to a source within airbyte. And airbyte is unable to talk to localhost on my machine.

Do some research how to bind your database to 0.0.0.0 instead of 127.0.0.1, then you should be able to use IP address of your Macbook (e,g, returned by ifconfig en0) in connector configuration

If you need anything more, you need to do more research how to do networking in kind clusters https://kind.sigs.k8s.io