Hello Airbyte enthusiasts! I am working on setting up a connection that needs to decrypt (PGP) the data as it pulls it from PostGres. Does anyone have some documentation recommendations or git examples? I'm having trouble getting this one implemented. Any help would be much appreciated.

Hello Christopher Brunton, it's been a while without an update from us. Are you still having problems or did you find a solution?

@Marcos Marx (Airbyte) thanks for responding. Yes this is still something I am grappling with. Would be thrilled if you could direct me to resources or examples.

Hey Christopher, I don't believe the postgres source supports pgp decryption, you'd have to modify the source code of the postgres connector to make this work with the pgcrypto module. My guess is that you'll have to implement a decrypt function in PostgresSourceOperations.java and then modify the PostgresSource.java file. But it's not an easy change. I'd suggest making an issue on Github and perhaps someone from our community can chime in on a possible strategy for implementation.

Hi Sajarin and thank you for your response. While I was surprised to hear that functionality did not exist to deal with PostGres's native encryption, having a definitive answer has helped our org navigate a path forward. I'm grateful for your response.