Issue Connecting to TimescaleDB with Compression

Summary

User is experiencing a synchronization error with Airbyte when connecting to a TimescaleDB that uses compression, specifically encountering a PostgreSQL error related to transparent decompression.


Question

Can anyone help me out figuring out how to connect to a timescaledb that uses compression? Its a progress db, but for airbyte the compression seems to bork the sync. I get the error
java.lang.RuntimeException: org.postgresql.util.PSQLException: ERROR: transparent decompression only supports tableoid system column
and cannot get the db to sync, any ideas?



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.

Join the conversation on Slack

['timescaledb', 'compression', 'postgresql', 'airbyte', 'sync-error']