Postgresql destination connection fails

Kazram · April 13, 2022, 5:39pm

I am getting following error when connecting airbyte to postgresql destination present on gcp.
Could not connect with provided configuration. Cannot create PoolableConnectionFactory (The connection attempt failed.)
Do I need to setup sql proxy server?

sreeling · April 13, 2022, 5:44pm

Is this a docker install on a windows machine?

Kazram · April 13, 2022, 5:47pm

docker install on ubuntu

marcosmarxm · April 13, 2022, 5:49pm

Please look in this other topic about it: Could not connect with provided configuration. Error: Cannot create PoolableConnectionFactory

sreeling · April 13, 2022, 5:49pm

I had that issue on my windows machine until i used the host “host.docker.internal” instead of the typical localhost or 127.0.0.1.

Kazram · April 13, 2022, 5:58pm

In my case I am not using local db.It is local/ubuntu airbyte docker connecting to remote gcp cloudsql/postgresql as airbyte destination. Do I still need to pull dockerRepository and dockerImageTag fields and then do docker-compose up as suggested in the link you shared?

marcosmarxm · April 13, 2022, 6:03pm

Mosts cases for this situations @Kazram is because the instance doesn’t have the connection to your database. Can you double check the Airbyte Server instance is allow to access the database one?