https://github.com/linz/postgresql-tableversion/
table_version is a PostgreSQL table versioning extension, recording row modifications and its history. The extension provides APIs for accessing snapshots of a table at certain revisions and the difference generated between any two given revisions. The extension uses a PL/PgSQL trigger based system to record and provide access to the row revisions
The accuracy of estimates produced by t-digests can be orders of magnitude more accurate than those produced by previous digest algorithms in spite of the fact that t-digests are much more compact when stored on disk.
The PostgreSQL RPM repository uses PostgreSQL version numbers in the RPM packages. For example table_version for PostgreSQL 17 is named as table_version_17. Similarly table_version for PostgreSQL 15 is named as table_version_15.
Install PGDG repository from: https://yum.postgresql.org/repopackages/
| OS | Command |
|---|---|
| RHEL / Rocky Linux / AlmaLinux / Fedora | dnf install table_version_17 (or change the version as described above) |
Connect to the database that you want to create the extension as superuser and run:
CREATE EXTENSION table_version;
| PostgreSQL version(s) | OS version | Arch | Status |
|---|---|---|---|
| 17,16,15,14,13 | RHEL / Rocky Linux / AlmaLinux 9 | x86_64, aarch64 | Available |
| 17,16,15,14,13 | RHEL / Rocky Linux / AlmaLinux 8 | x86_64, aarch64 | Available |
| 17,16,15,14,13 | Fedora Linux | x86_64 | Available |