Skip to main content

Postgres changelog

Availability
Available CoreAvailable StandardAvailable PlusAvailable ProAvailable Enterprise FlexAvailable PyAirbyte
Connector type
Available Data replicationNot available Agent(learn more)
Support Level
Airbyte
Connector Version
3.8.10 (last updated 12 days ago)
Sync Success Rate
High
Usage Rate
High
Data workers used
0.5 per sync (Learn more)
Definition ID
decd338e-5647-4c0b-adf4-da0e75f5a750

This page lists changes to the Postgres source connector for versions 3.x.

For other versions, see versions 0.x–2.x.

VersionDatePull RequestSubject
3.8.112026-10-2189637Upgrade to Bulk CDK 1.2.3: fix critical CVEs in Apache MINA (mina-core 2.0.31), MINA SSHD 2.20.0 and BouncyCastle 1.86; Kafka 4.1.2, Jetty 12.0.40, plexus-utils 3.6.2.
3.8.102026-10-2189623Upgrade to Bulk CDK 1.2.1, which brings Debezium 3.4.3 (CDC requires PostgreSQL 14 or later; the JDBC driver's keep-alive no longer advances the replication slot while the captured tables are idle, so configure the Debezium heartbeat query on low-activity databases), CDC records written while Debezium shuts down are counted in the final checkpoint, Kotlin 2.4 / K2 runtime, Micronaut 4.10.31, Jackson 2.21.7.
3.8.92026-10-1488485Cold-start the CDC initial snapshot when the saved stream state is an empty object instead of skipping the stream.
3.8.82026-10-1288498Classify unreachable-host connection errors (connection refused, unknown host, connect timeout) as configuration errors that point to the host and port, the Postgres remote-connection settings and the Airbyte Cloud IP allowlist. Explain the Discovered zero tables. connection-test failure: the message now names the schema USAGE and table SELECT grants to add and asks to check the database name, the Schemas setting and the table filters. On Airbyte Cloud, reject localhost without an SSH tunnel and a URL or host:port pasted into Host with an explicit message before the connection is attempted.
3.8.72026-10-0988431Upgrade to Bulk CDK 1.1.14.
3.8.62026-09-1686369Fix NULL array columns taking the previous record's value on the socket/protobuf CDC path.
3.8.52026-07-2982773Fix ClassCastException when an interval column has a default value during CDC.
3.8.42026-07-2879110Fix PostGIS geometry/geography columns returning NULL on CDC path. Values now always use hex-WEKB format, for both CDC and snapshots.
3.8.32026-07-2782782Remove the non-functional invalid_cdc_cursor_position_behavior option; invalidated replication slots always fail the sync.
3.8.22026-07-2482728Fix sync failures on money columns over the socket/protobuf output path.
3.8.12026-06-0479120Allow connecting without a password for passwordless auth methods.
3.8.02026-06-0275637Initial release of rewritten connector on the bulk CDK
3.7.22026-03-0474294Fix CDC bug where a replication slot can be advanced too far, losing needed WAL segments. Remove CVEs.
3.7.12026-01-2772396This version causes issues discovering streams for some users. Do not use.
3.7.02025-08-1257511Add configurations for Azure authentication to Azure Postgres servers.
3.6.352025-06-1861527Add error handling for connection issues and adopt the latest CDK version.
3.6.342025-05-2960876Cache CDC initial state once constructed.
3.6.332025-05-1360214Migrate to new Gradle flow.
3.6.322025-05-0859722Consolidate gradle set up.
3.6.312025-04-2458132Fix vulnerabilities in dependencies.
3.6.302025-03-0655234Update base image version for certified DB source connectors
3.6.292025-02-1353649Fix issue that column default value did not get converted
3.6.282024-12-2350870Use airbyte/java-connector-base:2.0.0
3.6.272024-12-2350410Use a non root base image.
3.6.262024-12-2048495Increase MAX_FIRST_RECORD_WAIT_TIME and use Debezium 3.0.1
3.6.252024-12-1749838Use a base image: airbyte/java-connector-base:1.0.0
3.6.242024-12-1649469Simplify CTID_TABLE_BLOCK_SIZE query for Postgres integration
3.6.232024-11-1348482Convert large integer typed using NUMERIC(X, 0) into a BigInteger. l
3.6.222024-10-0246900Fixed a bug where source docs won't render on Airbyte 1.1
3.6.212024-10-0246322Support CDC against a read-replica (continuation)
3.6.202024-10-0146299Make postgres source compile and use the latest CDK
3.6.192024-09-1745639Adopt latest CDK to use the latest apache sshd mina to handle tcpkeepalive requests.
3.6.182024-08-2844878Enable tcpKeepAlive for jdbc connection.
3.6.172024-08-2744841Adopt latest CDK.
3.6.162024-08-1544119Fix incorrect final state on initial read in CDC mode.
3.6.152024-08-1243945Add missing replication slot config error.
3.6.142024-08-0843418Adopt latest CDK.
3.6.132024-07-3042869Adopt latest CDK.
3.6.122024-07-3042550Correctly report stream states.
3.6.112024-07-2942852Bump CDK version to latest to use new bug fixes on error translation.
3.6.102024-07-2342417Handle null error message in ConnectorExceptionHandler.
3.6.92024-07-2342421Remove final transient error emitter iterators.
3.6.82024-07-2241622Bump CDK version to latest.
3.6.72024-07-2242411Hide the "initial load timeout in hours" field by default in UI
3.6.62024-07-2241622Fix bug in CDC syncing
3.6.52024-07-2242024Fix a bug on resuming from a failed attempt.
3.6.42024-07-1742087Translate more errors for Postgres source.
3.6.32024-07-1942122Improve wass error message + logging.
3.6.22024-07-1842108Disable incremental sync for view streams in xmin replication mode
3.6.12024-07-0540716Fix typo in connector specification
3.6.02024-07-1740208Start using the new error Postgres source error handler that comes with a new error translation layer.
3.5.22024-07-1742068Add analytics for WASS case occurrence.
3.5.12024-07-1742055Add debezium heartbeat timeout back to shutdown debezium.
3.5.02024-07-1741651Implement WASS algo - large initial snapshots shouldn't block CDC.
3.4.262024-07-1541654Allow null value for array typed columns in CDC.
3.4.252024-07-1241651Throw transient error if tables of interest and undergoing full vacuum.
3.4.242024-07-0541067Fix Postgres sending duplicated streams
3.4.232024-07-0140757Rollback 3.4.22.
3.4.222024-07-0540719Fix Postgres sending duplicated streams (rolled back in 3.4.23)
3.4.212024-07-0140516Remove dbz hearbeat.
3.4.202024-06-2340559Remove strict check for stream states of unknown types
3.4.192024-06-2340223Revert the changes introduced in version 3.4.15.
3.4.182024-06-1439349Full refresh stream sending internal count metadata.
3.4.172024-06-1339460Bump postgres JDBC driver version
3.4.162024-05-2939474Adopt latest CDK.
3.4.152024-05-2938773Connect with adaptiveFetch=true.
3.4.142024-06-0839353Upgrade Debezium to 2.6.2
3.4.132024-06-0438875read() throws config exception upon detecting transaction ID wraparound.
3.4.122024-06-0438836check() throws config error upon detecting transaction ID wraparound.
3.4.112024-06-0438848Improve UI message and doc on xmin
3.4.102024-05-2938584Set is_resumable flag in discover.
3.4.92024-05-2938775Publish CDK
3.4.92024-05-2838716Publish CDK
3.4.82024-05-2838716Stream status for postgres
3.4.72024-05-2038365Rollback a previously version (3.4.6)
3.4.62024-05-2038289Connect with adaptiveFetch=true (rolled back in 3.4.7)
3.4.52024-05-1638303Streams not in the CDC publication still have a cursor and PK.
3.4.42024-05-1538208disable counts in full refresh stream in state message.
3.4.32024-05-1338104Handle transient error messages.
3.4.22024-05-1038171Bug fix on final state setup.
3.4.12024-05-1038130Bug fix on old PG where ctid column not found when stream is a view.
3.4.02024-04-2937112resumeable full refresh.
3.3.332024-05-0738030Mark PG hot standby error as transient.
3.3.322024-04-3037758Correct previous release to disable debezium retries
3.3.312024-04-3037754Add CDC logs
3.3.302024-04-3037726Remove debezium retries
3.3.292024-04-2337509remove excessive logs
3.3.282024-04-2337509Better error messages on switching between sync modes.
3.3.272024-04-2237445Remove legacy bad values handling code.
3.3.262024-04-1036982Populate airbyte_meta.changes for xmin path
3.3.252024-04-1036981Track latest CDK
3.3.242024-04-1036865Track latest CDK
3.3.232024-04-0236759Track latest CDK
3.3.222024-04-0136739Fix useLocalCdk flag.
3.3.212024-03-2536584Adopt Kotlin CDK.
3.3.202024-03-2536432Failure to serialize values from Postgres DB shouldn't fail sync.
3.3.192024-03-1236333Use newest CDK - deprecate dbz iterator
3.3.182024-03-1235599Use newest CDK
3.3.172024-03-1235939Use lsn_commit value instead of lsn_proc for CDC checkpointing logic.
3.3.162024-03-1135904Adopt Java CDK 0.23.1- debezium retries.
3.3.152024-02-2934724Add record count in state message.
3.3.142024-03-0635842Add logging to understand cases with a large number of records with the same LSN.
3.3.132024-02-2735675Fix invalid cdc error message.
3.3.122024-02-2235569Fix logging bug.
3.3.112024-02-2035304Add config to throw an error on invalid CDC position and enable it by default.
3.3.102024-02-1334751Emit analytics message for invalid CDC cursor.
3.3.92024-02-1335224Adopt CDK 0.20.4
3.3.82024-02-0834751Adopt CDK 0.19.0
3.3.72024-02-0834781Add a setting in the setup page to advance the LSN.
3.3.62024-02-0734892Adopt CDK v0.16.6
3.3.52024-02-0734948Adopt CDK v0.16.5
3.3.42024-01-3134723Adopt CDK v0.16.3
3.3.32024-01-2634573Adopt CDK v0.16.0
3.3.22024-01-2434465Check xmin only if user selects xmin sync mode.
3.3.12024-01-1034119Adopt java CDK version 0.11.5.
3.3.02023-12-1933437Remove LEGACY state flag
3.2.272023-12-1833605Advance Postgres LSN for PG 14 & below.
3.2.262023-12-1132961Support for better debugging tools.
3.2.252023-11-2932961Bump debezium wait time default to 20 min.
3.2.242023-11-2832686Better logging to understand dbz closing reason attribution.
3.2.232023-11-2832891Fix CDK dependency in build.
3.2.222023-11-2232656Adopt java CDK version 0.5.0.
3.2.212023-11-0731856handle date/timestamp infinity values properly
3.2.202023-11-0632193Adopt java CDK version 0.4.1.
3.2.192023-11-0332050Adopt java CDK version 0.4.0.
3.2.182023-11-0129038Fix typo (s/Airbtye/Airbyte/)
3.2.172023-11-0132068Bump Debezium 2.2.0Final -> 2.4.0Final
3.2.162023-10-3131976Speed up tests involving Debezium
3.2.152023-10-3031960Adopt java CDK version 0.2.0.
3.2.142023-10-2431792fail sync when debezeum fails to shutdown cleanly
3.2.142023-10-2431792Fix error message link on issue with standby
3.2.132023-10-1631029Enforces encrypted traffic settings when env var DEPLOYMENT_MODE = CLOUD.
3.1.132023-10-1331309Addressed decimals being incorrectly deserialized into scientific notation.
3.1.122023-10-1231328Improvements to initial load of tables in older versions of postgres.
3.1.112023-10-1131322Correct previous release
3.1.102023-09-2930806Cap log line length to 32KB to prevent loss of records.
3.1.92023-09-2530534Fix JSONB[] column type handling bug.
3.1.82023-09-2030125Improve initial load performance for older versions of PostgreSQL.
3.1.72023-09-0529672Handle VACUUM happening during initial sync
3.1.62023-08-2429821Set replication_method display_type to radio, update titles and descriptions, and make CDC the default choice
3.1.52023-08-2229534Support "options" JDBC URL parameter
3.1.42023-08-2128687Under the hood: Add dependency on Java CDK v0.0.2.
3.1.32023-08-0328708Enable checkpointing snapshots in CDC connections
3.1.22023-08-0128954Fix an issue that prevented use of tables with names containing uppercase letters
3.1.12023-07-3128892Fix an issue that prevented use of cursor columns with names containing uppercase letters
3.1.02023-07-2528339Checkpointing initial load for incremental syncs: enabled for xmin and cursor based only.
3.0.22023-07-1828336Add full-refresh mode back to Xmin syncs.
3.0.12023-07-1428345Increment patch to trigger a rebuild
3.0.02023-07-1227442Set _ab_cdc_lsn as the source defined cursor for CDC mode to prepare for Destination v2 normalization