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]