Summary
User is experiencing a connection failure when using Airbyte as a destination for a PostgreSQL instance with SSL enabled. The connection works with psql client and as an Airbyte source, but fails with a ‘FATAL: connection requires a valid client certificate’ error when configured as a destination.
Question
Hello
I have a postgres instance running on a public ec2. I have enabled ssl configurations (verify-full) so that client is required to provide a valid certificate for making a connection. Connection is successful using psql client
psql "host=ip-x-x-x-x.us-east-2.compute.internal dbname=tsdb user=postgres sslmode=verify-full sslcert=./client.crt sslkey=./client.key sslrootcert=./ca.crt"
Similarly when I connect to the same database instance as airbyte source, connection remain successful. But when I try to connect this database instance as airbyte destination with same ssl key/certificate it fails and gives the following error. In both cases, I am using ‘verify-full’ with same ssl certificate/key and same db configurations (host, db, user).
State code: 28000; Message: FATAL: connection requires a valid client certificate
Any suggestions ?
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.