Connecting to TimescaleDB with Compression

Slack Knowledge Base Q&A Connector Questions
, , , ,
1

Summary

Error encountered when syncing a Progress DB with compression in TimescaleDB. Error message: java.lang.RuntimeException: org.postgresql.util.PSQLException: ERROR: transparent decompression only supports tableoid system column. Need help troubleshooting the sync issue.


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", "progress-db", "sync-error", "transparent-decompression"]