pglogical 2.2.1 Released – Now with support for PostgreSQL 11

Oxford, United Kingdom – October 29, 2018

2ndQuadrant is proud to announce the release of pglogical 2.2.1, the next generation in logical replication for PostgreSQL. Implemented entirely as a PostgreSQL extension, pglogical is a logical replication system that serves as a highly efficient method of replicating data as an alternative to physical replication.

pglogical 2.2.1 includes full compatibility with PostgreSQL 11, the newest major release announced by the community on October 18, 2018.

This release presents important enhancements and bug fixes, such as:

• Add pglogical.wait_for_subscription_sync_complete and pglogical.wait_for_table_sync_complete functions
• Allow passing of arguments to pg_basebackup via pglogical_create_subscriber
• Update pglReorderBufferCleanSerializedTXNs to match core code
• Improve confusing ‘natts mismatch’ error
• Improve performance when several table resyncs are done
• Ensure notifications sent by ENABLE REPLICA triggers are sent promptly
• Add pglogical.xact_commit_timestamp_origin to look up the replication origin associated with a transaction id
• Rewrite worker signalling to address possible loss of messages when multiple signals are delivered, causing issues with sync and apply
• Stop using pglogical.alter_node_drop_interface to drop an interface that is used by a current subscription
• Race condition between pglogical managers trying to register new workers after a crash
• Fix a case where apply crashes are not recovered by the manager
• Fix a memory leak in apply worker trace logic leading to unbounded memory growth in ErrorContext
• Fix uninitialized field causing occasional log messages about “none worker”
• Fix use of the same restore-point name by pglogical_create_subscriber that could cause the wrong restore-point to be stopped at and an incomplete initial sync

Download and installation instructions are available here.

For more information, please send an email to [email protected]