data_historization
PLPGSQL Script to historize data in partitionned table
Module:
Categories:
Overview
PIGSTY 3rd Party Extension: data_historization
: PLPGSQL Script to historize data in partitionned table
Information
- Extension ID: 4220
- Extension Name:
data_historization
- Package Name:
data_historization
- Category:
UTIL
- License: PostgreSQL
- Website: https://github.com/rodo/postgresql-data-historization
- Language: SQL
- Extra Tags: N/A
- Comment: N/A
Metadata
- Latest Version: 1.1.0
- Postgres Support:
17
,16
,15
,14
,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION
DDL - Relocatable: Can be installed into other schemas
- Trusted: Trusted, Can be created by user with
CREATE
Privilege - Schemas: N/A
- Requires:
plpgsql
RPM / DEB
- RPM Repo: PIGSTY
- RPM Name:
data_historization_$v
- RPM Ver :
1.1.0
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-data-historization
- DEB Ver :
1.1.0
- DEB Deps: N/A
Packages
Installation
Install data_historization
via the pig
CLI tool:
pig ext install data_historization
Install data_historization
via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["data_historization"]}' # -l <cls>
Install data_historization
RPM from YUM repo directly:
dnf install data_historization_17;
dnf install data_historization_16;
dnf install data_historization_15;
dnf install data_historization_14;
dnf install data_historization_13;
Install data_historization
DEB from APT repo directly:
apt install postgresql-17-data-historization;
apt install postgresql-16-data-historization;
apt install postgresql-15-data-historization;
apt install postgresql-14-data-historization;
apt install postgresql-13-data-historization;
Enable data_historization
extension on PostgreSQL cluster:
CREATE EXTENSION data_historization CASCADE;
Feedback
Was this page helpful?
Glad to hear it! Please tell us how we can improve.
Sorry to hear that. Please tell us how we can improve.