2ndQuadrant is proud to announce the release of pglogical 2.3 [https://www.2ndquadrant.com/en/resources/pglogical/], the next generation in logical replication for PostgreSQL. This release includes support for PostgreSQL 12, the latest major release of the world's most advanced open source database.
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 fixes including:
- Allow replicating tables and sequences to different names on the target node
- Add option to only synchronize the structure of replicated relations
- Add a new "force_text_transfer" subscription option
- Allow tables to be resynchronized in state SYNC_STATUS_SYNCDONE
- Fix pglogical_wait_for_sync_complete with unknown table