pglogical 2.5.1

pglogical 2.5.1

What's New

pglogical_create_subscriber now included in release packages

The pglogical_create_subscriber utility is now bundled with all release packages:

• Linux/macOS tar.gz: Executable located in bin/pglogical_create_subscriber
• Windows ZIP: Executable located in bin\pglogical_create_subscriber.exe
• Windows MSI: Automatically installed to PostgreSQL's bin directory

The install.sh script on Unix platforms now installs executables from the package's bin/ directory to PostgreSQL's bin directory (detected via pg_config --bindir).

This utility creates a new PostgreSQL instance ready to be a pglogical subscriber by cloning an existing provider node using pg_basebackup.

Installation

Linux

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

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

macOS

# Download and extract
tar -xzf pglogical-2.5.1-pg17-macos-arm64.tar.gz
cd pglogical-2.5.1-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
4. Copy files from bin/ to your PostgreSQL bin 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

Full Changelog: v2.5.0...v2.5.1