2ndQuadrant is proud to announce the release of pglogical 2.2.1
[https://www.2ndquadrant.com/en/resources/pglogical/], 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:
https://www.2ndquadrant.com/en/resources/pglogical/pglogical-installation-instructions/
For more information, please send an email to info@2ndQuadrant.com
Monica Real Amores
Marketing & Communications
2ndQuadrant
PostgreSQL Training, Services and Support
monica.realamores@2ndquadrant.com | www.2ndquadrant.com