Summary
The user is facing an error while trying to connect a Postgres source in Airbyte. The error message indicates a connection refusal to localhost:5432. The user has tried using both the default Postgres user and a dedicated read-only user, but the issue persists.
Question
Hi everyone.
We’re testing Airbyte open source and trying to add a Postgres source but I’m constantly getting this error.
“State code: 08001; Message: Connection to localhost:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.”
I’m using Mac and I’ve installed Airbyte through abctl. Python 3.11 and Postgres 16.
I tried giving both default postgres user and also dedicated read only user that I’ve created but still getting the same error.
I’ve checked Dbeaver it’s able to form a connection. So I’m kind of stuck.
Could someone who is using posgres as a source please help me out
Thanking you.
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.