Skip to content

v0.14

Compare
Choose a tag to compare
@dimitri dimitri released this 20 Nov 14:35
· 193 commits to main since this release
8d305a5

pgcopydb v0.14 (November 20, 2023)

This is a bugfix release with a strong focus on reliability, in particular
in the logical decoding parts of pgcopydb (the --follow implementation).

Added

  • Implement multi-value inserts (#465)
  • feat(container): multi arch build (#480)
  • Add support for database properties. (#491)
  • Add tests coverage for Postgres 16. (#478)
  • Set Process Titles as seen in ps/top/htop etc. (#435)
  • Implement same-table concurrency using Postgres CTID column. (#410)
  • When applying --follow changes, set synchronous_commit to off. (#425)
  • Use PREPARE/EXECUTE statements for applying DML in follow mode. (#420)
  • Use --table-jobs processes when computing pgcopydb compare data. (#419)
  • Implement concurrent workers for Large Objects data copy. (#411)

Changed

  • Improve migration speed by using same connection in a LOB worker. (#533)
  • Improve and fix connection timeout and total retry timeout. (#528)
  • Have the follow process read the schema from disk when it's been exported. (#523)
  • use LOG_WARN for warnings instead of LOG_ERROR (#506)
  • Improve Handling of replay_lsn for Idle Source (#519)
  • Update the lib/parson vendored-in library to a new version. (#512)
  • Review logical decoding client tracking of LSNs. (#502)
  • Add check constraint, language entry mapping (#497)
  • Ensure transactions are not read only by default (#490)
  • Switch to using libpq async API. (#488)
  • Improve error handling when COPY fails. (#485)
  • Switch our call to PQgetCopyData to async in pg_copy(). (#479)
  • Rewrite the ad-hoc parser for Postgres Archive TOC items. (#469)
  • Use an intermediate file on-disk for pg_restore --list output. (#467)
  • Add a way to debug parsing a list file. (#470)
  • Improve connection string TCP keepalive parameters handling. (#457)
  • Review the TCP keepalives settings. (#436)
  • Do not reset sequences on copy --follow failure. (#424)
  • Refactor the cli_compare code. (#418)
  • Use Postgres async queries to compute checksums. (#416)
  • Improve pgcopydb compare data checksum computation. (#407)

Fix

  • fix inherit data copy (#538)
  • Use dynamically allocated QMessage for msgrcv. (#534)
  • exclude generated columns from COPY statements (#517)
  • Update pgcopydb sentinel in the main follow process. (#521)
  • Remove the usage of txn metadata file (#525)
  • fix password handling in safeURI (#522)
  • Update README.md (One Typo Fixed) (#527)
  • Fix lib/subcommands.c sprintf usage. (#520)
  • Ensure NULL-termination of string when unescaping single-quotes (#514)
  • add archive entry mapping for LARGE OBJECTS and ROW SECURITY (#515)
  • Use target dbname when setting db parameters (#509)
  • Fix various issues with docs (#494)
  • Fix data loss when reading large transaction bodies (#495)
  • Fix test runs for outside contributors
  • Review static memory size of Postgres identifier names. (#486)
  • Fix column name escaping with test_decoding plugin (#482)
  • Fixing PING documentation (#476)
  • fix drop cascade issue (#475)
  • Fix SQL identifier quoting, generalize using format %I. (#464)
  • Fix error handling of fork() calls. (#459)
  • Fix set_ps_title to avoid calling sformat() on possibly short buffers. (#437)
  • Fix escaping double-quotes in SQL identifiers. (#434)
  • Fix memory leaks in transform code (#433)
  • Assorted fixes from review, including stream_read_context retry loop. (#423)
  • Fix a SEGFAULT that was hidden by our waitpid() calls. (#422)
  • Fix exit() calls that should have been return false; (#421)
  • Fix filtering on schema names. (#415)
  • Fix a compile warning on Linux related to printf format strings. (#406)