ddl_historization

Historize the ddl changes inside PostgreSQL database

Overview

ID	Extension	Package	Version	Category	License	Language
4310	ddl_historization	ddl_historization	`0.0.7`	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	pg_readme data_historization table_version gzip bzip zstd http pg_net

Packages

Type	Repo	Version	PG Major Availability	Package Pattern	Dependencies
EL	PIGSTY	`0.0.7`	18 17 16 15 14 13	`ddl_historization_$v`	-
Debian	PIGSTY	`0.0.7`	18 17 16 15 14 13	`postgresql-$v-ddl-historization`	-

Linux / PG	PG18	PG17	PG16	PG15	PG14	PG13
el8.x86_64	PIGSTY 0.0.7	PIGSTY 0.0.7	PIGSTY 0.0.7	PIGSTY 0.0.7	PIGSTY 0.0.7	PIGSTY 0.0.7
el8.aarch64	PIGSTY 0.0.7	PIGSTY 0.0.7	PIGSTY 0.0.7	PIGSTY 0.0.7	PIGSTY 0.0.7	PIGSTY 0.0.7
el9.x86_64	PIGSTY 0.0.7	PIGSTY 0.0.7	PIGSTY 0.0.7	PIGSTY 0.0.7	PIGSTY 0.0.7	PIGSTY 0.0.7
el9.aarch64	PIGSTY 0.0.7	PIGSTY 0.0.7	PIGSTY 0.0.7	PIGSTY 0.0.7	PIGSTY 0.0.7	PIGSTY 0.0.7
el10.x86_64	PIGSTY 0.0.7	PIGSTY 0.0.7	PIGSTY 0.0.7	PIGSTY 0.0.7	PIGSTY 0.0.7	PIGSTY 0.0.7
el10.aarch64	PIGSTY 0.0.7	PIGSTY 0.0.7	PIGSTY 0.0.7	PIGSTY 0.0.7	PIGSTY 0.0.7	PIGSTY 0.0.7
d12.x86_64	MISS	PIGSTY 0.0.7	PIGSTY 0.0.7	PIGSTY 0.0.7	PIGSTY 0.0.7	PIGSTY 0.0.7
d12.aarch64	MISS	PIGSTY 0.0.7	PIGSTY 0.0.7	PIGSTY 0.0.7	PIGSTY 0.0.7	PIGSTY 0.0.7
d13.x86_64	MISS	MISS	MISS	MISS	MISS	MISS
d13.aarch64	MISS	MISS	MISS	MISS	MISS	MISS
u22.x86_64	MISS	PIGSTY 0.0.7	PIGSTY 0.0.7	PIGSTY 0.0.7	PIGSTY 0.0.7	PIGSTY 0.0.7
u22.aarch64	MISS	PIGSTY 0.0.7	PIGSTY 0.0.7	PIGSTY 0.0.7	PIGSTY 0.0.7	PIGSTY 0.0.7
u24.x86_64	MISS	PIGSTY 0.0.7	PIGSTY 0.0.7	PIGSTY 0.0.7	PIGSTY 0.0.7	PIGSTY 0.0.7
u24.aarch64	MISS	PIGSTY 0.0.7	PIGSTY 0.0.7	PIGSTY 0.0.7	PIGSTY 0.0.7	PIGSTY 0.0.7

Package	Version	OS	ORG	SIZE	File URL
`ddl_historization_18`	0.0.7	`el8.x86_64`	pigsty	16.0 KiB	ddl_historization_18-0.0.7-1PIGSTY.el8.x86_64.rpm
`ddl_historization_18`	0.0.7	`el8.aarch64`	pigsty	16.0 KiB	ddl_historization_18-0.0.7-1PIGSTY.el8.aarch64.rpm
`ddl_historization_18`	0.0.7	`el9.x86_64`	pigsty	15.9 KiB	ddl_historization_18-0.0.7-1PIGSTY.el9.x86_64.rpm
`ddl_historization_18`	0.0.7	`el9.aarch64`	pigsty	15.8 KiB	ddl_historization_18-0.0.7-1PIGSTY.el9.aarch64.rpm
`ddl_historization_18`	0.0.7	`el10.x86_64`	pigsty	15.9 KiB	ddl_historization_18-0.0.7-1PIGSTY.el10.x86_64.rpm
`ddl_historization_18`	0.0.7	`el10.aarch64`	pigsty	15.9 KiB	ddl_historization_18-0.0.7-1PIGSTY.el10.aarch64.rpm

Package	Version	OS	ORG	SIZE	File URL
`ddl_historization_17`	0.0.7	`el8.x86_64`	pigsty	16.0 KiB	ddl_historization_17-0.0.7-1PIGSTY.el8.x86_64.rpm
`ddl_historization_17`	0.0.7	`el8.aarch64`	pigsty	16.0 KiB	ddl_historization_17-0.0.7-1PIGSTY.el8.aarch64.rpm
`ddl_historization_17`	0.0.7	`el9.x86_64`	pigsty	15.9 KiB	ddl_historization_17-0.0.7-1PIGSTY.el9.x86_64.rpm
`ddl_historization_17`	0.0.7	`el9.aarch64`	pigsty	15.8 KiB	ddl_historization_17-0.0.7-1PIGSTY.el9.aarch64.rpm
`ddl_historization_17`	0.0.7	`el10.x86_64`	pigsty	15.9 KiB	ddl_historization_17-0.0.7-1PIGSTY.el10.x86_64.rpm
`ddl_historization_17`	0.0.7	`el10.aarch64`	pigsty	15.9 KiB	ddl_historization_17-0.0.7-1PIGSTY.el10.aarch64.rpm
`postgresql-17-ddl-historization`	0.0.7	`d12.x86_64`	pigsty	3.0 KiB	postgresql-17-ddl-historization_0.0.7-1PIGSTY~bookworm_amd64.deb
`postgresql-17-ddl-historization`	0.0.7	`d12.aarch64`	pigsty	3.0 KiB	postgresql-17-ddl-historization_0.0.7-1PIGSTY~bookworm_arm64.deb
`postgresql-17-ddl-historization`	0.0.7	`u22.x86_64`	pigsty	2.7 KiB	postgresql-17-ddl-historization_0.0.7-1PIGSTY~jammy_amd64.deb
`postgresql-17-ddl-historization`	0.0.7	`u22.aarch64`	pigsty	2.7 KiB	postgresql-17-ddl-historization_0.0.7-1PIGSTY~jammy_arm64.deb
`postgresql-17-ddl-historization`	0.0.7	`u24.x86_64`	pigsty	2.7 KiB	postgresql-17-ddl-historization_0.0.7-1PIGSTY~noble_amd64.deb
`postgresql-17-ddl-historization`	0.0.7	`u24.aarch64`	pigsty	2.7 KiB	postgresql-17-ddl-historization_0.0.7-1PIGSTY~noble_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`ddl_historization_16`	0.0.7	`el8.x86_64`	pigsty	16.0 KiB	ddl_historization_16-0.0.7-1PIGSTY.el8.x86_64.rpm
`ddl_historization_16`	0.0.7	`el8.aarch64`	pigsty	16.0 KiB	ddl_historization_16-0.0.7-1PIGSTY.el8.aarch64.rpm
`ddl_historization_16`	0.0.7	`el9.x86_64`	pigsty	15.9 KiB	ddl_historization_16-0.0.7-1PIGSTY.el9.x86_64.rpm
`ddl_historization_16`	0.0.7	`el9.aarch64`	pigsty	15.8 KiB	ddl_historization_16-0.0.7-1PIGSTY.el9.aarch64.rpm
`ddl_historization_16`	0.0.7	`el10.x86_64`	pigsty	15.9 KiB	ddl_historization_16-0.0.7-1PIGSTY.el10.x86_64.rpm
`ddl_historization_16`	0.0.7	`el10.aarch64`	pigsty	15.9 KiB	ddl_historization_16-0.0.7-1PIGSTY.el10.aarch64.rpm
`postgresql-16-ddl-historization`	0.0.7	`d12.x86_64`	pigsty	3.0 KiB	postgresql-16-ddl-historization_0.0.7-1PIGSTY~bookworm_amd64.deb
`postgresql-16-ddl-historization`	0.0.7	`d12.aarch64`	pigsty	3.0 KiB	postgresql-16-ddl-historization_0.0.7-1PIGSTY~bookworm_arm64.deb
`postgresql-16-ddl-historization`	0.0.7	`u22.x86_64`	pigsty	2.7 KiB	postgresql-16-ddl-historization_0.0.7-1PIGSTY~jammy_amd64.deb
`postgresql-16-ddl-historization`	0.0.7	`u22.aarch64`	pigsty	2.7 KiB	postgresql-16-ddl-historization_0.0.7-1PIGSTY~jammy_arm64.deb
`postgresql-16-ddl-historization`	0.0.7	`u24.x86_64`	pigsty	2.7 KiB	postgresql-16-ddl-historization_0.0.7-1PIGSTY~noble_amd64.deb
`postgresql-16-ddl-historization`	0.0.7	`u24.aarch64`	pigsty	2.7 KiB	postgresql-16-ddl-historization_0.0.7-1PIGSTY~noble_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`ddl_historization_15`	0.0.7	`el8.x86_64`	pigsty	16.0 KiB	ddl_historization_15-0.0.7-1PIGSTY.el8.x86_64.rpm
`ddl_historization_15`	0.0.7	`el8.aarch64`	pigsty	16.0 KiB	ddl_historization_15-0.0.7-1PIGSTY.el8.aarch64.rpm
`ddl_historization_15`	0.0.7	`el9.x86_64`	pigsty	15.9 KiB	ddl_historization_15-0.0.7-1PIGSTY.el9.x86_64.rpm
`ddl_historization_15`	0.0.7	`el9.aarch64`	pigsty	15.8 KiB	ddl_historization_15-0.0.7-1PIGSTY.el9.aarch64.rpm
`ddl_historization_15`	0.0.7	`el10.x86_64`	pigsty	15.9 KiB	ddl_historization_15-0.0.7-1PIGSTY.el10.x86_64.rpm
`ddl_historization_15`	0.0.7	`el10.aarch64`	pigsty	15.9 KiB	ddl_historization_15-0.0.7-1PIGSTY.el10.aarch64.rpm
`postgresql-15-ddl-historization`	0.0.7	`d12.x86_64`	pigsty	3.0 KiB	postgresql-15-ddl-historization_0.0.7-1PIGSTY~bookworm_amd64.deb
`postgresql-15-ddl-historization`	0.0.7	`d12.aarch64`	pigsty	3.0 KiB	postgresql-15-ddl-historization_0.0.7-1PIGSTY~bookworm_arm64.deb
`postgresql-15-ddl-historization`	0.0.7	`u22.x86_64`	pigsty	2.7 KiB	postgresql-15-ddl-historization_0.0.7-1PIGSTY~jammy_amd64.deb
`postgresql-15-ddl-historization`	0.0.7	`u22.aarch64`	pigsty	2.7 KiB	postgresql-15-ddl-historization_0.0.7-1PIGSTY~jammy_arm64.deb
`postgresql-15-ddl-historization`	0.0.7	`u24.x86_64`	pigsty	2.7 KiB	postgresql-15-ddl-historization_0.0.7-1PIGSTY~noble_amd64.deb
`postgresql-15-ddl-historization`	0.0.7	`u24.aarch64`	pigsty	2.7 KiB	postgresql-15-ddl-historization_0.0.7-1PIGSTY~noble_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`ddl_historization_14`	0.0.7	`el8.x86_64`	pigsty	16.0 KiB	ddl_historization_14-0.0.7-1PIGSTY.el8.x86_64.rpm
`ddl_historization_14`	0.0.7	`el8.aarch64`	pigsty	16.0 KiB	ddl_historization_14-0.0.7-1PIGSTY.el8.aarch64.rpm
`ddl_historization_14`	0.0.7	`el9.x86_64`	pigsty	15.9 KiB	ddl_historization_14-0.0.7-1PIGSTY.el9.x86_64.rpm
`ddl_historization_14`	0.0.7	`el9.aarch64`	pigsty	15.8 KiB	ddl_historization_14-0.0.7-1PIGSTY.el9.aarch64.rpm
`ddl_historization_14`	0.0.7	`el10.x86_64`	pigsty	15.9 KiB	ddl_historization_14-0.0.7-1PIGSTY.el10.x86_64.rpm
`ddl_historization_14`	0.0.7	`el10.aarch64`	pigsty	15.9 KiB	ddl_historization_14-0.0.7-1PIGSTY.el10.aarch64.rpm
`postgresql-14-ddl-historization`	0.0.7	`d12.x86_64`	pigsty	3.0 KiB	postgresql-14-ddl-historization_0.0.7-1PIGSTY~bookworm_amd64.deb
`postgresql-14-ddl-historization`	0.0.7	`d12.aarch64`	pigsty	3.0 KiB	postgresql-14-ddl-historization_0.0.7-1PIGSTY~bookworm_arm64.deb
`postgresql-14-ddl-historization`	0.0.7	`u22.x86_64`	pigsty	2.7 KiB	postgresql-14-ddl-historization_0.0.7-1PIGSTY~jammy_amd64.deb
`postgresql-14-ddl-historization`	0.0.7	`u22.aarch64`	pigsty	2.7 KiB	postgresql-14-ddl-historization_0.0.7-1PIGSTY~jammy_arm64.deb
`postgresql-14-ddl-historization`	0.0.7	`u24.x86_64`	pigsty	2.7 KiB	postgresql-14-ddl-historization_0.0.7-1PIGSTY~noble_amd64.deb
`postgresql-14-ddl-historization`	0.0.7	`u24.aarch64`	pigsty	2.7 KiB	postgresql-14-ddl-historization_0.0.7-1PIGSTY~noble_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`ddl_historization_13`	0.0.7	`el8.x86_64`	pigsty	16.0 KiB	ddl_historization_13-0.0.7-1PIGSTY.el8.x86_64.rpm
`ddl_historization_13`	0.0.7	`el8.aarch64`	pigsty	16.0 KiB	ddl_historization_13-0.0.7-1PIGSTY.el8.aarch64.rpm
`ddl_historization_13`	0.0.7	`el9.x86_64`	pigsty	15.9 KiB	ddl_historization_13-0.0.7-1PIGSTY.el9.x86_64.rpm
`ddl_historization_13`	0.0.7	`el9.aarch64`	pigsty	15.8 KiB	ddl_historization_13-0.0.7-1PIGSTY.el9.aarch64.rpm
`ddl_historization_13`	0.0.7	`el10.x86_64`	pigsty	15.9 KiB	ddl_historization_13-0.0.7-1PIGSTY.el10.x86_64.rpm
`ddl_historization_13`	0.0.7	`el10.aarch64`	pigsty	15.9 KiB	ddl_historization_13-0.0.7-1PIGSTY.el10.aarch64.rpm
`postgresql-13-ddl-historization`	0.0.7	`d12.x86_64`	pigsty	3.0 KiB	postgresql-13-ddl-historization_0.0.7-1PIGSTY~bookworm_amd64.deb
`postgresql-13-ddl-historization`	0.0.7	`d12.aarch64`	pigsty	3.0 KiB	postgresql-13-ddl-historization_0.0.7-1PIGSTY~bookworm_arm64.deb
`postgresql-13-ddl-historization`	0.0.7	`u22.x86_64`	pigsty	2.7 KiB	postgresql-13-ddl-historization_0.0.7-1PIGSTY~jammy_amd64.deb
`postgresql-13-ddl-historization`	0.0.7	`u22.aarch64`	pigsty	2.7 KiB	postgresql-13-ddl-historization_0.0.7-1PIGSTY~jammy_arm64.deb
`postgresql-13-ddl-historization`	0.0.7	`u24.x86_64`	pigsty	2.7 KiB	postgresql-13-ddl-historization_0.0.7-1PIGSTY~noble_amd64.deb
`postgresql-13-ddl-historization`	0.0.7	`u24.aarch64`	pigsty	2.7 KiB	postgresql-13-ddl-historization_0.0.7-1PIGSTY~noble_arm64.deb

Source

Repository

github.com/rodo/pg_ddl_historization

Source Tarball

pg_ddl_historization-0.0.7.tar.gz

pig build get ddl_historization; # get ddl_historization source code
pig build dep ddl_historization; # install build dependencies
pig build pkg ddl_historization; # build extension rpm or deb
pig build ext ddl_historization; # build extension rpms

Install

To add the required PGDG / PIGSTY upstream repository, use:

pig repo add pgsql -u   # add PGDG + Pigsty repo and update cache (leave existing repos)

Install this extension with:

pig ext install ddl_historization; # install by extension name, for the current active PG version
pig ext install ddl_historization; # install via package alias, for the active PG version
pig ext install ddl_historization -v 18;   # install for PG 18
pig ext install ddl_historization -v 17;   # install for PG 17
pig ext install ddl_historization -v 16;   # install for PG 16
pig ext install ddl_historization -v 15;   # install for PG 15
pig ext install ddl_historization -v 14;   # install for PG 14
pig ext install ddl_historization -v 13;   # install for PG 13

Create this extension with:

CREATE EXTENSION ddl_historization;

Last updated on 2025-11-02

pg_readme_test_extension data_historization