pglogical 2.5.3

pglogical 2.5.3

Bug Fixes

Fixed rapid manager worker cycling for databases without pglogical extension

When pglogical is loaded via shared_preload_libraries, manager workers were rapidly cycling (start, exit, restart) for databases that do not have the pglogical extension installed. This caused excessive log noise and wasted system resources.

Symptoms:

• Log messages like manager worker [PID] at slot N generation G detaching cleanly repeating constantly
• Generation counter incrementing rapidly (hundreds per minute)
• High CPU usage from worker process churn

Fix: Manager workers now set a flag before exiting due to missing extension, preventing the supervisor from being woken immediately. The supervisor will restart managers on its normal timeout (30s on Windows, 180s on Unix) instead of immediately, eliminating the rapid cycling.

---

Installation

Linux

# Download and extract
tar -xzf pglogical-2.5.3-pg17-linux-x64.tar.gz
cd pglogical-2.5.3-pg17-linux-x64

# Install (uses pg_config to find PostgreSQL directories)
./install.sh

macOS

# Download and extract
tar -xzf pglogical-2.5.3-pg17-macos-arm64.tar.gz
cd pglogical-2.5.3-pg17-macos-arm64

# Install
./install.sh

Windows (MSI Installer)

1. Download the MSI for your PostgreSQL version
2. Run the installer - it will auto-detect PostgreSQL location
3. Or use the ZIP package and copy files manually

Windows (ZIP Package)

1. Extract the ZIP to a temporary location
2. Copy files from lib/ to your PostgreSQL lib directory
3. Copy files from share/extension/ to your PostgreSQL share/extension directory

Configuration (postgresql.conf)

wal_level = 'logical'
max_worker_processes = 10
max_replication_slots = 10
max_wal_senders = 10
shared_preload_libraries = 'pglogical'

Restart PostgreSQL after changing these settings.

Enable the Extension

CREATE EXTENSION pglogical;

Verify Checksums

Download checksums.txt and verify your download:

sha256sum -c checksums.txt --ignore-missing

Supported Platforms

• Linux x64 (Ubuntu, Debian, RHEL, CentOS)
• Windows x64 (Windows 10, Windows 11, Windows Server 2019+)
• macOS ARM64 (Apple Silicon)

PostgreSQL Versions

• PostgreSQL 15, 16, 17, 18

---

What's Changed

• fix(worker): prevent rapid manager cycling for databases without extension by @willibrandon in #3

Full Changelog: v2.5.2...v2.5.3