I am having issue to connect my Postgres (used as ...
# ask-community-for-troubleshooting
f
I am having issue to connect my Postgres (used as destination) all my infrastructure (airbyte, Postgres dwh, and production read replica) is in the same vpc. I have created the connection with the read replica straightforward but my destination which is a Postgres as well is facing this issue non-json response I don’t have ssh or jdbc required
a
this happened to me when I didn't have the IP whitelisted in the
pg_hba.conf
of postgreSQL. You will also need to reload postgres for it to take it into account
non-json basically means that it couldn't connect AFAIK
f
Thank you Alexander, am not familiar with this particular setting. My Postgres is aws rds instance, is the pg_gab different from security groups? Do I need to whitelist my airbyte ip in the destination Postgres?
a
I would think so yes
s
Hey @Faris, were you able to get this working following Alexander’s suggestions? (Thanks Alexandre!)
f
Yes, I have shared this with my devops guy and they fixed it.
u
Hello Faris, it's been a while without an update from us. Are you still having problems or did you find a solution?