pglogical_origin

pglogical : Dummy extension for compatibility when upgrading from Postgres 9.4

Overview

Packages

Source

Install

Make sure PGDG repo available:

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

Install this extension with pig:

pig install pglogical;		# install via package name, for the active PG version
pig install pglogical_origin;		# install by extension name, for the current active PG version

pig install pglogical_origin -v 18;   # install for PG 18
pig install pglogical_origin -v 17;   # install for PG 17
pig install pglogical_origin -v 16;   # install for PG 16
pig install pglogical_origin -v 15;   # install for PG 15
pig install pglogical_origin -v 14;   # install for PG 14

Create this extension with:

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.