pglogical_origin

Overview

Latest PGDG DEB/catalog version is 2.4.7; PGDG RPM and Pigsty source remain on 2.4.6.

Version

Install

You can install pglogical directly. First, make sure the PGDG repository is added and enabled:

pig repo add pgdg -u          # Add PGDG repo and update cache

Install the extension using pig or apt/yum/dnf:

pig install pglogical;          # Install for current active PG version

pig ext install -y pglogical -v 18  # PG 18
pig ext install -y pglogical -v 17  # PG 17
pig ext install -y pglogical -v 16  # PG 16
pig ext install -y pglogical -v 15  # PG 15
pig ext install -y pglogical -v 14  # PG 14

dnf install -y pglogical_18       # PG 18
dnf install -y pglogical_17       # PG 17
dnf install -y pglogical_16       # PG 16
dnf install -y pglogical_15       # PG 15
dnf install -y pglogical_14       # PG 14

apt install -y postgresql-18-pglogical   # PG 18
apt install -y postgresql-17-pglogical   # PG 17
apt install -y postgresql-16-pglogical   # PG 16
apt install -y postgresql-15-pglogical   # PG 15
apt install -y postgresql-14-pglogical   # PG 14

Create Extension:

CREATE EXTENSION pglogical_origin;

Usage

pglogical_origin: Dummy extension for compatibility when upgrading from Postgres 9.4

The pglogical_origin extension is a compatibility shim provided alongside pglogical. It exists solely to facilitate upgrades from PostgreSQL 9.4, where replication origin tracking was handled by the pglogical extension itself rather than by PostgreSQL core.

Enabling

CREATE EXTENSION pglogical_origin;

Overview

Starting with PostgreSQL 9.5, replication origin tracking became a built-in PostgreSQL feature (pg_replication_origin). The pglogical_origin extension is a dummy/empty extension that:

• Prevents errors when upgrading databases that previously depended on it
• Provides a smooth migration path from pglogical on PostgreSQL 9.4 to newer versions
• Contains no actual functionality – all origin tracking is handled by PostgreSQL core

When to Use

This extension is only needed when:

• Upgrading a database from PostgreSQL 9.4 that used pglogical
• The database has existing references to the pglogical_origin extension

For new installations, this extension is not required. Use pglogical directly, which leverages PostgreSQL’s built-in replication origin support.