Announcing the Release of pglogical 2.2

Oxford, United Kingdom – March 20, 2018

2ndQuadrant is proud to announce the release of pglogical 2.2, 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.

This release presents important enhancements and bug fixes including:

  • Fixed a race condition that could cause table synchronization to fail.
  • pglogical.alter_subscription_synchronize() now removes synchronization info about orphaned tables.
  • Recreate replication slot on retry after table synchronization failure, which should improve table synchronization recovery after intermittent errors.
  • Report process identification based on log_line_prefix settings, making it easier to obtain pglogical messages from the server logs.
  • pglogical_create_subscriber no longer generates errors when run multiple times on the same provider.
  • Handle epoll_ctl failures cleanly to avoid internal error messages.
  • Improved memory management.

pglogical is supported by 2ndQuadrant’s 24/7 Production Support, providing the fastest and highest-rated response service for PostgreSQL and is available worldwide.

Download and installation instructions are available here.

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