ddl_historization

Historize the ddl changes inside PostgreSQL database

ddl_historization : Historize the ddl changes inside PostgreSQL database

Overview

ID	Extension	Package	Version	Category	License	Language
4310	ddl_historization	ddl_historization	`0.2`	UTIL	GPL-2.0	SQL

Attribute	Has Binary	Has Library	Need Load	Has DDL	Relocatable	Trusted
----d--	No	No	No	Yes	no	no

Relationships
Requires	plpgsql
Need By	schedoc
See Also	pgmemento table_log data_historization table_version pgaudit periods temporal_tables emaj provsql pgmnemo

Packages

Type	Repo	Version	PG Major Compatibility	Package Pattern	Dependencies
EXT	PIGSTY	`0.2`	18 17 16 15 14	`ddl_historization`	`plpgsql`
RPM	PIGSTY	`0.2`	18 17 16 15 14	`ddl_historization_$v`	-
DEB	PIGSTY	`0.2`	18 17 16 15 14	`postgresql-$v-ddl-historization`	-

Linux / PG	PG18	PG17	PG16	PG15	PG14
el8.x86_64	PIGSTY 0.2	PIGSTY 0.2	PIGSTY 0.2	PIGSTY 0.2	PIGSTY 0.2
el8.aarch64	PIGSTY 0.2	PIGSTY 0.2	PIGSTY 0.2	PIGSTY 0.2	PIGSTY 0.2
el9.x86_64	PIGSTY 0.2	PIGSTY 0.2	PIGSTY 0.2	PIGSTY 0.2	PIGSTY 0.2
el9.aarch64	PIGSTY 0.2	PIGSTY 0.2	PIGSTY 0.2	PIGSTY 0.2	PIGSTY 0.2
el10.x86_64	PIGSTY 0.2	PIGSTY 0.2	PIGSTY 0.2	PIGSTY 0.2	PIGSTY 0.2
el10.aarch64	PIGSTY 0.2	PIGSTY 0.2	PIGSTY 0.2	PIGSTY 0.2	PIGSTY 0.2
d12.x86_64	PIGSTY 0.2	PIGSTY 0.2	PIGSTY 0.2	PIGSTY 0.2	PIGSTY 0.2
d12.aarch64	PIGSTY 0.2	PIGSTY 0.2	PIGSTY 0.2	PIGSTY 0.2	PIGSTY 0.2
d13.x86_64	PIGSTY 0.2	PIGSTY 0.2	PIGSTY 0.2	PIGSTY 0.2	PIGSTY 0.2
d13.aarch64	PIGSTY 0.2	PIGSTY 0.2	PIGSTY 0.2	PIGSTY 0.2	PIGSTY 0.2
u22.x86_64	PIGSTY 0.2	PIGSTY 0.2	PIGSTY 0.2	PIGSTY 0.2	PIGSTY 0.2
u22.aarch64	PIGSTY 0.2	PIGSTY 0.2	PIGSTY 0.2	PIGSTY 0.2	PIGSTY 0.2
u24.x86_64	PIGSTY 0.2	PIGSTY 0.2	PIGSTY 0.2	PIGSTY 0.2	PIGSTY 0.2
u24.aarch64	PIGSTY 0.2	PIGSTY 0.2	PIGSTY 0.2	PIGSTY 0.2	PIGSTY 0.2
u26.x86_64	PIGSTY 0.2	PIGSTY 0.2	PIGSTY 0.2	PIGSTY 0.2	PIGSTY 0.2
u26.aarch64	PIGSTY 0.2	PIGSTY 0.2	PIGSTY 0.2	PIGSTY 0.2	PIGSTY 0.2

Package	Version	OS	ORG	SIZE	File URL
`ddl_historization_18`	`0.2`	el8.x86_64	pigsty	15.2 KiB	ddl_historization_18-0.2-1PIGSTY.el8.x86_64.rpm
`ddl_historization_18`	`0.2`	el8.aarch64	pigsty	15.2 KiB	ddl_historization_18-0.2-1PIGSTY.el8.aarch64.rpm
`ddl_historization_18`	`0.2`	el9.x86_64	pigsty	15.1 KiB	ddl_historization_18-0.2-1PIGSTY.el9.x86_64.rpm
`ddl_historization_18`	`0.2`	el9.aarch64	pigsty	15.1 KiB	ddl_historization_18-0.2-1PIGSTY.el9.aarch64.rpm
`ddl_historization_18`	`0.2`	el10.x86_64	pigsty	15.2 KiB	ddl_historization_18-0.2-1PIGSTY.el10.x86_64.rpm
`ddl_historization_18`	`0.2`	el10.aarch64	pigsty	15.2 KiB	ddl_historization_18-0.2-1PIGSTY.el10.aarch64.rpm
`postgresql-18-ddl-historization`	`0.2`	d12.x86_64	pigsty	2.2 KiB	postgresql-18-ddl-historization_0.2-1PIGSTY~bookworm_amd64.deb
`postgresql-18-ddl-historization`	`0.2`	d12.aarch64	pigsty	2.2 KiB	postgresql-18-ddl-historization_0.2-1PIGSTY~bookworm_arm64.deb
`postgresql-18-ddl-historization`	`0.2`	d13.x86_64	pigsty	2.2 KiB	postgresql-18-ddl-historization_0.2-1PIGSTY~trixie_amd64.deb
`postgresql-18-ddl-historization`	`0.2`	d13.aarch64	pigsty	2.2 KiB	postgresql-18-ddl-historization_0.2-1PIGSTY~trixie_arm64.deb
`postgresql-18-ddl-historization`	`0.2`	u22.x86_64	pigsty	2.1 KiB	postgresql-18-ddl-historization_0.2-1PIGSTY~jammy_amd64.deb
`postgresql-18-ddl-historization`	`0.2`	u22.aarch64	pigsty	2.1 KiB	postgresql-18-ddl-historization_0.2-1PIGSTY~jammy_arm64.deb
`postgresql-18-ddl-historization`	`0.2`	u24.x86_64	pigsty	2.1 KiB	postgresql-18-ddl-historization_0.2-1PIGSTY~noble_amd64.deb
`postgresql-18-ddl-historization`	`0.2`	u24.aarch64	pigsty	2.1 KiB	postgresql-18-ddl-historization_0.2-1PIGSTY~noble_arm64.deb
`postgresql-18-ddl-historization`	`0.2`	u26.x86_64	pigsty	2.1 KiB	postgresql-18-ddl-historization_0.2-1PIGSTY~resolute_amd64.deb
`postgresql-18-ddl-historization`	`0.2`	u26.aarch64	pigsty	2.1 KiB	postgresql-18-ddl-historization_0.2-1PIGSTY~resolute_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`ddl_historization_17`	`0.2`	el8.x86_64	pigsty	15.2 KiB	ddl_historization_17-0.2-1PIGSTY.el8.x86_64.rpm
`ddl_historization_17`	`0.2`	el8.aarch64	pigsty	15.2 KiB	ddl_historization_17-0.2-1PIGSTY.el8.aarch64.rpm
`ddl_historization_17`	`0.2`	el9.x86_64	pigsty	15.1 KiB	ddl_historization_17-0.2-1PIGSTY.el9.x86_64.rpm
`ddl_historization_17`	`0.2`	el9.aarch64	pigsty	15.1 KiB	ddl_historization_17-0.2-1PIGSTY.el9.aarch64.rpm
`ddl_historization_17`	`0.2`	el10.x86_64	pigsty	15.2 KiB	ddl_historization_17-0.2-1PIGSTY.el10.x86_64.rpm
`ddl_historization_17`	`0.2`	el10.aarch64	pigsty	15.2 KiB	ddl_historization_17-0.2-1PIGSTY.el10.aarch64.rpm
`postgresql-17-ddl-historization`	`0.2`	d12.x86_64	pigsty	2.2 KiB	postgresql-17-ddl-historization_0.2-1PIGSTY~bookworm_amd64.deb
`postgresql-17-ddl-historization`	`0.2`	d12.aarch64	pigsty	2.2 KiB	postgresql-17-ddl-historization_0.2-1PIGSTY~bookworm_arm64.deb
`postgresql-17-ddl-historization`	`0.2`	d13.x86_64	pigsty	2.2 KiB	postgresql-17-ddl-historization_0.2-1PIGSTY~trixie_amd64.deb
`postgresql-17-ddl-historization`	`0.2`	d13.aarch64	pigsty	2.2 KiB	postgresql-17-ddl-historization_0.2-1PIGSTY~trixie_arm64.deb
`postgresql-17-ddl-historization`	`0.2`	u22.x86_64	pigsty	2.1 KiB	postgresql-17-ddl-historization_0.2-1PIGSTY~jammy_amd64.deb
`postgresql-17-ddl-historization`	`0.2`	u22.aarch64	pigsty	2.1 KiB	postgresql-17-ddl-historization_0.2-1PIGSTY~jammy_arm64.deb
`postgresql-17-ddl-historization`	`0.2`	u24.x86_64	pigsty	2.1 KiB	postgresql-17-ddl-historization_0.2-1PIGSTY~noble_amd64.deb
`postgresql-17-ddl-historization`	`0.2`	u24.aarch64	pigsty	2.1 KiB	postgresql-17-ddl-historization_0.2-1PIGSTY~noble_arm64.deb
`postgresql-17-ddl-historization`	`0.2`	u26.x86_64	pigsty	2.1 KiB	postgresql-17-ddl-historization_0.2-1PIGSTY~resolute_amd64.deb
`postgresql-17-ddl-historization`	`0.2`	u26.aarch64	pigsty	2.1 KiB	postgresql-17-ddl-historization_0.2-1PIGSTY~resolute_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`ddl_historization_16`	`0.2`	el8.x86_64	pigsty	15.2 KiB	ddl_historization_16-0.2-1PIGSTY.el8.x86_64.rpm
`ddl_historization_16`	`0.2`	el8.aarch64	pigsty	15.2 KiB	ddl_historization_16-0.2-1PIGSTY.el8.aarch64.rpm
`ddl_historization_16`	`0.2`	el9.x86_64	pigsty	15.1 KiB	ddl_historization_16-0.2-1PIGSTY.el9.x86_64.rpm
`ddl_historization_16`	`0.2`	el9.aarch64	pigsty	15.1 KiB	ddl_historization_16-0.2-1PIGSTY.el9.aarch64.rpm
`ddl_historization_16`	`0.2`	el10.x86_64	pigsty	15.2 KiB	ddl_historization_16-0.2-1PIGSTY.el10.x86_64.rpm
`ddl_historization_16`	`0.2`	el10.aarch64	pigsty	15.2 KiB	ddl_historization_16-0.2-1PIGSTY.el10.aarch64.rpm
`postgresql-16-ddl-historization`	`0.2`	d12.x86_64	pigsty	2.2 KiB	postgresql-16-ddl-historization_0.2-1PIGSTY~bookworm_amd64.deb
`postgresql-16-ddl-historization`	`0.2`	d12.aarch64	pigsty	2.2 KiB	postgresql-16-ddl-historization_0.2-1PIGSTY~bookworm_arm64.deb
`postgresql-16-ddl-historization`	`0.2`	d13.x86_64	pigsty	2.2 KiB	postgresql-16-ddl-historization_0.2-1PIGSTY~trixie_amd64.deb
`postgresql-16-ddl-historization`	`0.2`	d13.aarch64	pigsty	2.2 KiB	postgresql-16-ddl-historization_0.2-1PIGSTY~trixie_arm64.deb
`postgresql-16-ddl-historization`	`0.2`	u22.x86_64	pigsty	2.1 KiB	postgresql-16-ddl-historization_0.2-1PIGSTY~jammy_amd64.deb
`postgresql-16-ddl-historization`	`0.2`	u22.aarch64	pigsty	2.1 KiB	postgresql-16-ddl-historization_0.2-1PIGSTY~jammy_arm64.deb
`postgresql-16-ddl-historization`	`0.2`	u24.x86_64	pigsty	2.1 KiB	postgresql-16-ddl-historization_0.2-1PIGSTY~noble_amd64.deb
`postgresql-16-ddl-historization`	`0.2`	u24.aarch64	pigsty	2.1 KiB	postgresql-16-ddl-historization_0.2-1PIGSTY~noble_arm64.deb
`postgresql-16-ddl-historization`	`0.2`	u26.x86_64	pigsty	2.1 KiB	postgresql-16-ddl-historization_0.2-1PIGSTY~resolute_amd64.deb
`postgresql-16-ddl-historization`	`0.2`	u26.aarch64	pigsty	2.1 KiB	postgresql-16-ddl-historization_0.2-1PIGSTY~resolute_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`ddl_historization_15`	`0.2`	el8.x86_64	pigsty	15.2 KiB	ddl_historization_15-0.2-1PIGSTY.el8.x86_64.rpm
`ddl_historization_15`	`0.2`	el8.aarch64	pigsty	15.2 KiB	ddl_historization_15-0.2-1PIGSTY.el8.aarch64.rpm
`ddl_historization_15`	`0.2`	el9.x86_64	pigsty	15.1 KiB	ddl_historization_15-0.2-1PIGSTY.el9.x86_64.rpm
`ddl_historization_15`	`0.2`	el9.aarch64	pigsty	15.1 KiB	ddl_historization_15-0.2-1PIGSTY.el9.aarch64.rpm
`ddl_historization_15`	`0.2`	el10.x86_64	pigsty	15.2 KiB	ddl_historization_15-0.2-1PIGSTY.el10.x86_64.rpm
`ddl_historization_15`	`0.2`	el10.aarch64	pigsty	15.2 KiB	ddl_historization_15-0.2-1PIGSTY.el10.aarch64.rpm
`postgresql-15-ddl-historization`	`0.2`	d12.x86_64	pigsty	2.2 KiB	postgresql-15-ddl-historization_0.2-1PIGSTY~bookworm_amd64.deb
`postgresql-15-ddl-historization`	`0.2`	d12.aarch64	pigsty	2.2 KiB	postgresql-15-ddl-historization_0.2-1PIGSTY~bookworm_arm64.deb
`postgresql-15-ddl-historization`	`0.2`	d13.x86_64	pigsty	2.2 KiB	postgresql-15-ddl-historization_0.2-1PIGSTY~trixie_amd64.deb
`postgresql-15-ddl-historization`	`0.2`	d13.aarch64	pigsty	2.2 KiB	postgresql-15-ddl-historization_0.2-1PIGSTY~trixie_arm64.deb
`postgresql-15-ddl-historization`	`0.2`	u22.x86_64	pigsty	2.1 KiB	postgresql-15-ddl-historization_0.2-1PIGSTY~jammy_amd64.deb
`postgresql-15-ddl-historization`	`0.2`	u22.aarch64	pigsty	2.1 KiB	postgresql-15-ddl-historization_0.2-1PIGSTY~jammy_arm64.deb
`postgresql-15-ddl-historization`	`0.2`	u24.x86_64	pigsty	2.1 KiB	postgresql-15-ddl-historization_0.2-1PIGSTY~noble_amd64.deb
`postgresql-15-ddl-historization`	`0.2`	u24.aarch64	pigsty	2.1 KiB	postgresql-15-ddl-historization_0.2-1PIGSTY~noble_arm64.deb
`postgresql-15-ddl-historization`	`0.2`	u26.x86_64	pigsty	2.1 KiB	postgresql-15-ddl-historization_0.2-1PIGSTY~resolute_amd64.deb
`postgresql-15-ddl-historization`	`0.2`	u26.aarch64	pigsty	2.1 KiB	postgresql-15-ddl-historization_0.2-1PIGSTY~resolute_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`ddl_historization_14`	`0.2`	el8.x86_64	pigsty	15.2 KiB	ddl_historization_14-0.2-1PIGSTY.el8.x86_64.rpm
`ddl_historization_14`	`0.2`	el8.aarch64	pigsty	15.2 KiB	ddl_historization_14-0.2-1PIGSTY.el8.aarch64.rpm
`ddl_historization_14`	`0.2`	el9.x86_64	pigsty	15.1 KiB	ddl_historization_14-0.2-1PIGSTY.el9.x86_64.rpm
`ddl_historization_14`	`0.2`	el9.aarch64	pigsty	15.1 KiB	ddl_historization_14-0.2-1PIGSTY.el9.aarch64.rpm
`ddl_historization_14`	`0.2`	el10.x86_64	pigsty	15.2 KiB	ddl_historization_14-0.2-1PIGSTY.el10.x86_64.rpm
`ddl_historization_14`	`0.2`	el10.aarch64	pigsty	15.2 KiB	ddl_historization_14-0.2-1PIGSTY.el10.aarch64.rpm
`postgresql-14-ddl-historization`	`0.2`	d12.x86_64	pigsty	2.2 KiB	postgresql-14-ddl-historization_0.2-1PIGSTY~bookworm_amd64.deb
`postgresql-14-ddl-historization`	`0.2`	d12.aarch64	pigsty	2.2 KiB	postgresql-14-ddl-historization_0.2-1PIGSTY~bookworm_arm64.deb
`postgresql-14-ddl-historization`	`0.2`	d13.x86_64	pigsty	2.2 KiB	postgresql-14-ddl-historization_0.2-1PIGSTY~trixie_amd64.deb
`postgresql-14-ddl-historization`	`0.2`	d13.aarch64	pigsty	2.2 KiB	postgresql-14-ddl-historization_0.2-1PIGSTY~trixie_arm64.deb
`postgresql-14-ddl-historization`	`0.2`	u22.x86_64	pigsty	2.1 KiB	postgresql-14-ddl-historization_0.2-1PIGSTY~jammy_amd64.deb
`postgresql-14-ddl-historization`	`0.2`	u22.aarch64	pigsty	2.1 KiB	postgresql-14-ddl-historization_0.2-1PIGSTY~jammy_arm64.deb
`postgresql-14-ddl-historization`	`0.2`	u24.x86_64	pigsty	2.1 KiB	postgresql-14-ddl-historization_0.2-1PIGSTY~noble_amd64.deb
`postgresql-14-ddl-historization`	`0.2`	u24.aarch64	pigsty	2.1 KiB	postgresql-14-ddl-historization_0.2-1PIGSTY~noble_arm64.deb
`postgresql-14-ddl-historization`	`0.2`	u26.x86_64	pigsty	2.1 KiB	postgresql-14-ddl-historization_0.2-1PIGSTY~resolute_amd64.deb
`postgresql-14-ddl-historization`	`0.2`	u26.aarch64	pigsty	2.1 KiB	postgresql-14-ddl-historization_0.2-1PIGSTY~resolute_arm64.deb

Source

Repository

github.com/rodo/pg_ddl_historization

Source Tarball

pg_ddl_historization-0.2.tar.gz

pig build pkg ddl_historization;		# build rpm/deb

Install

Make sure PGDG and PIGSTY repo available:

pig repo add pgsql -u   # add both repo and update cache

Install this extension with pig:

pig install ddl_historization;		# install via package name, for the active PG version

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

Create this extension with:

CREATE EXTENSION ddl_historization CASCADE; -- requires plpgsql

Usage

Sources: README, releases

ddl_historization is a PostgreSQL extension that records database DDL changes in a historization table. The upstream README documents installation via make install, pgxn install ddl_historization, and an AWS RDS path via pg_tle.

Enable logging

CREATE EXTENSION ddl_historization;

The README describes the extension as using PostgreSQL event triggers to historize DDL changes made in the database.

What upstream currently documents

Cluster-local install: make install
PGXN install: pgxn install ddl_historization
AWS RDS / pg_tle: build pgtle.ddl_historization-0.3.sql with make pgtle
Test suite: make test with pgTAP

Release notes worth knowing

Release 0.2 is the version requested by this refresh task.
Release 0.0.4 says it added functions to start and stop logging.
Release 0.0.6 says it added a ddl_history_column table.
Release 0.0.7 says it fixed a foreign-key related logging bug.

Caveat

The current upstream README is minimal and does not document the exact SQL signatures for the start/stop logging functions or the schema of the historization tables added in later releases. Keep this stub conservative unless the upstream README or release notes become more explicit.