PostgreSQL agent changelog

Added the source lag probe, reporting the unread change backlog and how far behind the last read transaction is;

GSSD-534: a replication slot created by the agent is now dropped during teardown;

PostgreSQL: documented the output_plugin_libraries allowlist introduced by the PostgreSQL releases of August 13, 2026, whose default excludes wal2json and refuses the source with SQLSTATE 42501 (GSSD-1294);

PostgreSQL: the previous GSSD-1294 recipe used a quoted list for output_plugin_libraries and has been corrected;

GSSD-1120: Fixed deduplication logic for primary keys columns with case insensitive collation;

GSSD-1118: Fixed issue where the message read loop could break while a transaction is in progress;

Added possibility to change wal sender timeout value;

Improved error handling when no replication slot is available;

GSSD-1118: Fixed transaction loss when connection lost;

GSSD-1111: Added ANALYZE temp table before merge to avoid statement timeout on large targets;

GSSD-1092: Insert query improvements;

Added support for PgVector data type;

GSSD-1056: Fixed invalid syntax error in snapshot deletion filter query;

GSSD-1082: Fixed No Class Def Found Error org/postgresql/util/PGTimestamp when attempting to use multiple PgSQL instances;

Fixed write connection not closed in some circumstances;

Fixed insert query without physical primary key causing failure of "on conflict" statement in query;

GSSD-1032: Fixed performance issues with IS DISTINCT FROM clause;

GSSD-982: Added retry slot aquisition when PostgreSQL backend still holds the replication slot;

Added precision fallback for null datetime precision;

Added logic to recreate staging table for bulk operations to keep it aligned with entity schema;

Removed primary keys constraint from temp tables;

Fixed usage of the equality operator (=) instead of IS NOT DISTINCT FROM in UpdateAll join/where clauses to handle NULL key columns correctly;

GSSD-982: Fixed a OOM error causing the agent to leading the JVM to restart;

Extended compatibility for PostGIS data types by adding raster data type support (reading, batches, bulks);

Improved support for enhaced columns discovery (precision, lenght, scale);

GSSD-898: Fixed an issue that was causing the agent to fail with "Failed while writing to copy" error;

Fixed possible duplicate key error using bulk operations for target agent.

Snapshot performance enhancements;

GSSD-769: Added support to array data type;

Fixed an issue that was causing the agent to display a wrong e2e timing;

GSSD-760: Fix wrong bulk staging table queries with tables with only PKs;

Improved support for CHARACTER and CHARACTER VARYING data types;

Fixed String mapping choosing as default geometry;

GSSD-721: Fixed an issue that was causing the agent to fail with "Binary Write Failed" error (org.postgresql.util.PSQLException: ERROR: value too long for type character(1));

GSSD-749: Fixed an incompatibility issue with the PostGIS extension;

GSSD-654: Improved error handling and resilience when dealing with high latency connections;

Fixes for bulk load operations;

Optimized metadata queries;

GSSD-654: Mitigation of "Database connection failed when writing to copy" error;

Fixed bulk logic;

Replace drop of staging table with Truncate operation in case of Bulk loads usage;

Agent compatibility upgrade to Gluesync 2.2;