This is the multi-page printable view of this section.
Click here to print.
Return to the regular view of this page.
Category: ADMIN
ADMIN: Utilities for Bloat Control, DirtyRead, BufferInspect, DDL Generate, ChecksumVerify, Permission, Priority, Catalog,…
ADMIN category has 35 available extensions:
1 - pg_repack
Reorganize tables in PostgreSQL databases with minimal locks
Overview
PGDG 1st Party Extension: pg_repack : Reorganize tables in PostgreSQL databases with minimal locks
- Latest Version: 1.5.2
- 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: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PGDG
- RPM Name:
pg_repack_$v*
- RPM Ver :
1.5.2
- RPM Deps: N/A
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-repack
- DEB Ver :
1.5.2
- DEB Deps: N/A
Availability
Installation
Install pg_repack via the pig CLI tool:
pig ext install pg_repack
Install pg_repack via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_repack"]}' # -l <cls>
Install pg_repack RPM from YUM repo directly:
dnf install pg_repack_17*;
dnf install pg_repack_16*;
dnf install pg_repack_15*;
dnf install pg_repack_14*;
dnf install pg_repack_13*;
Install pg_repack DEB from APT repo directly:
apt install postgresql-17-repack;
apt install postgresql-16-repack;
apt install postgresql-15-repack;
apt install postgresql-14-repack;
apt install postgresql-13-repack;
Create pg_repack extension on PostgreSQL cluster:
CREATE EXTENSION pg_repack;
2 - pg_squeeze
A tool to remove unused space from a relation.
Overview
PGDG 1st Party Extension: pg_squeeze : A tool to remove unused space from a relation.
- Latest Version: 1.8.0
- Postgres Support:
17,16,15,14,13
- Need Load: Explicit Loading Required
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Can be installed into other schemas
- Trusted: Untrusted, Require Superuser to Create
- Schemas:
squeeze
- Requires: N/A
RPM / DEB
- RPM Repo: PGDG
- RPM Name:
pg_squeeze_$v*
- RPM Ver :
1.8.0
- RPM Deps: N/A
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-squeeze
- DEB Ver :
1.8.0
- DEB Deps: N/A
Availability
Installation
Install pg_squeeze via the pig CLI tool:
pig ext install pg_squeeze
Install pg_squeeze via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_squeeze"]}' # -l <cls>
Install pg_squeeze RPM from YUM repo directly:
dnf install pg_squeeze_17*;
dnf install pg_squeeze_16*;
dnf install pg_squeeze_15*;
dnf install pg_squeeze_14*;
dnf install pg_squeeze_13*;
Install pg_squeeze DEB from APT repo directly:
apt install postgresql-17-squeeze;
apt install postgresql-16-squeeze;
apt install postgresql-15-squeeze;
apt install postgresql-14-squeeze;
apt install postgresql-13-squeeze;
Extension pg_squeeze has to be loaded via shared_preload_libraries
shared_preload_libraries = 'pg_squeeze'; # add to pg cluster config
Create pg_squeeze extension on PostgreSQL cluster:
CREATE EXTENSION pg_squeeze;
3 - pg_dirtyread
Read dead but unvacuumed rows from table
Overview
MIXED 3rd Party Extension: pg_dirtyread : Read dead but unvacuumed rows from table
- Latest Version: 2.7
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Can not install to arbitrary schema
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PIGSTY
- RPM Name:
pg_dirtyread_$v*
- RPM Ver :
2.7
- RPM Deps: N/A
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-dirtyread
- DEB Ver :
2.7
- DEB Deps: N/A
Availability
Installation
Install pg_dirtyread via the pig CLI tool:
pig ext install pg_dirtyread
Install pg_dirtyread via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_dirtyread"]}' # -l <cls>
Install pg_dirtyread RPM from YUM repo directly:
dnf install pg_dirtyread_17*;
dnf install pg_dirtyread_16*;
dnf install pg_dirtyread_15*;
dnf install pg_dirtyread_14*;
dnf install pg_dirtyread_13*;
Install pg_dirtyread DEB from APT repo directly:
apt install postgresql-17-dirtyread;
apt install postgresql-16-dirtyread;
apt install postgresql-15-dirtyread;
apt install postgresql-14-dirtyread;
apt install postgresql-13-dirtyread;
Create pg_dirtyread extension on PostgreSQL cluster:
CREATE EXTENSION pg_dirtyread;
4 - pgfincore
examine and manage the os buffer cache
Overview
PGDG 1st Party Extension: pgfincore : examine and manage the os buffer cache
- Latest Version: 1.3.1
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Can not install to arbitrary schema
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PGDG
- RPM Name:
pgfincore_$v*
- RPM Ver :
1.3.1
- RPM Deps: N/A
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-pgfincore
- DEB Ver :
1.3.1
- DEB Deps: N/A
Availability
Installation
Install pgfincore via the pig CLI tool:
pig ext install pgfincore
Install pgfincore via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pgfincore"]}' # -l <cls>
Install pgfincore RPM from YUM repo directly:
dnf install pgfincore_17*;
dnf install pgfincore_16*;
dnf install pgfincore_15*;
dnf install pgfincore_14*;
dnf install pgfincore_13*;
Install pgfincore DEB from APT repo directly:
apt install postgresql-17-pgfincore;
apt install postgresql-16-pgfincore;
apt install postgresql-15-pgfincore;
apt install postgresql-14-pgfincore;
apt install postgresql-13-pgfincore;
Create pgfincore extension on PostgreSQL cluster:
CREATE EXTENSION pgfincore;
5 - pg_cooldown
remove buffered pages for specific relations
Overview
PIGSTY 3rd Party Extension: pg_cooldown : remove buffered pages for specific relations
- Latest Version: 0.1
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Can not install to arbitrary schema
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PIGSTY
- RPM Name:
pg_cooldown_$v*
- RPM Ver :
0.1
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-pg-cooldown
- DEB Ver :
0.1
- DEB Deps: N/A
Availability
Installation
Install pg_cooldown via the pig CLI tool:
pig ext install pg_cooldown
Install pg_cooldown via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_cooldown"]}' # -l <cls>
Install pg_cooldown RPM from YUM repo directly:
dnf install pg_cooldown_17*;
dnf install pg_cooldown_16*;
dnf install pg_cooldown_15*;
dnf install pg_cooldown_14*;
dnf install pg_cooldown_13*;
Install pg_cooldown DEB from APT repo directly:
apt install postgresql-17-pg-cooldown;
apt install postgresql-16-pg-cooldown;
apt install postgresql-15-pg-cooldown;
apt install postgresql-14-pg-cooldown;
apt install postgresql-13-pg-cooldown;
Create pg_cooldown extension on PostgreSQL cluster:
CREATE EXTENSION pg_cooldown;
6 - ddlx
DDL eXtractor functions
Overview
MIXED 3rd Party Extension: pg_ddlx : DDL eXtractor functions
- Latest Version: 0.29
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Unknown
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PIGSTY
- RPM Name:
ddlx_$v
- RPM Ver :
0.29
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-ddlx
- DEB Ver :
0.29
- DEB Deps: N/A
Availability
Installation
Install ddlx via the pig CLI tool:
pig ext install pg_ddlx; # Extension Name
pig ext install ddlx; # normalized package name
Install pg_ddlx via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_ddlx"]}' # -l <cls>
Install pg_ddlx RPM from YUM repo directly:
dnf install ddlx_17;
dnf install ddlx_16;
dnf install ddlx_15;
dnf install ddlx_14;
dnf install ddlx_13;
Install pg_ddlx DEB from APT repo directly:
apt install postgresql-17-ddlx;
apt install postgresql-16-ddlx;
apt install postgresql-15-ddlx;
apt install postgresql-14-ddlx;
apt install postgresql-13-ddlx;
Create ddlx extension on PostgreSQL cluster:
7 - prioritize
get and set the priority of PostgreSQL backends
Overview
PGDG 1st Party Extension: pg_prioritize : get and set the priority of PostgreSQL backends
- Latest Version: 1.0.4
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Can not install to arbitrary schema
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PGDG
- RPM Name:
pg_prioritize_$v*
- RPM Ver :
1.0.4
- RPM Deps: N/A
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-prioritize
- DEB Ver :
1.0.4
- DEB Deps: N/A
Availability
Installation
Install prioritize via the pig CLI tool:
pig ext install pg_prioritize; # Extension Name
pig ext install prioritize; # normalized package name
Install pg_prioritize via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_prioritize"]}' # -l <cls>
Install pg_prioritize RPM from YUM repo directly:
dnf install pg_prioritize_17*;
dnf install pg_prioritize_16*;
dnf install pg_prioritize_15*;
Install pg_prioritize DEB from APT repo directly:
apt install postgresql-17-prioritize;
apt install postgresql-16-prioritize;
apt install postgresql-15-prioritize;
apt install postgresql-14-prioritize;
apt install postgresql-13-prioritize;
Create prioritize extension on PostgreSQL cluster:
CREATE EXTENSION prioritize;
8 - pg_checksums
Activate/deactivate/verify checksums in offline Postgres clusters
Overview
PGDG 1st Party Extension: pg_checksums : Activate/deactivate/verify checksums in offline Postgres clusters
- Latest Version: 1.2
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Dd not need
CREATE EXTENSION DDL
- Relocatable: Unknown
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PGDG
- RPM Name:
pg_checksums_$v*
- RPM Ver :
1.1
- RPM Deps: N/A
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-pg-checksums
- DEB Ver :
1.2
- DEB Deps: N/A
Availability
Installation
Install pg_checksums via the pig CLI tool:
pig ext install pg_checksums
Install pg_checksums via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_checksums"]}' # -l <cls>
Install pg_checksums RPM from YUM repo directly:
dnf install pg_checksums_16*;
dnf install pg_checksums_15*;
dnf install pg_checksums_14*;
dnf install pg_checksums_13*;
Install pg_checksums DEB from APT repo directly:
apt install postgresql-17-pg-checksums;
apt install postgresql-16-pg-checksums;
apt install postgresql-15-pg-checksums;
apt install postgresql-14-pg-checksums;
apt install postgresql-13-pg-checksums;
Extension %s does not need CREATE EXTENSION command
9 - pg_readonly
cluster database read only
Overview
PGDG 1st Party Extension: pg_readonly : cluster database read only
- Latest Version: 1.0.3
- 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: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PGDG
- RPM Name:
pg_readonly_$v*
- RPM Ver :
1.0.3
- RPM Deps: N/A
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-pg-readonly
- DEB Ver :
1.0.0
- DEB Deps: N/A
Availability
Installation
Install pg_readonly via the pig CLI tool:
pig ext install pg_readonly
Install pg_readonly via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_readonly"]}' # -l <cls>
Install pg_readonly RPM from YUM repo directly:
dnf install pg_readonly_17*;
dnf install pg_readonly_16*;
dnf install pg_readonly_15*;
dnf install pg_readonly_14*;
dnf install pg_readonly_13*;
Install pg_readonly DEB from APT repo directly:
apt install postgresql-17-pg-readonly;
apt install postgresql-16-pg-readonly;
apt install postgresql-15-pg-readonly;
apt install postgresql-14-pg-readonly;
apt install postgresql-13-pg-readonly;
Create pg_readonly extension on PostgreSQL cluster:
CREATE EXTENSION pg_readonly;
10 - pgdd
Introspect pg data dictionary via standard SQL
Overview
PIGSTY 3rd Party Extension: pgdd : Introspect pg data dictionary via standard SQL
- Latest Version: 0.6.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:
dd
- Requires: N/A
RPM / DEB
- RPM Repo: PIGSTY
- RPM Name:
pgdd_$v
- RPM Ver :
0.6.0
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-pgdd
- DEB Ver :
0.6.0
- DEB Deps: N/A
Availability
Installation
Install pgdd via the pig CLI tool:
Install pgdd via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pgdd"]}' # -l <cls>
Install pgdd RPM from YUM repo directly:
dnf install pgdd_17;
dnf install pgdd_16;
dnf install pgdd_15;
dnf install pgdd_14;
dnf install pgdd_13;
Install pgdd DEB from APT repo directly:
apt install postgresql-17-pgdd;
apt install postgresql-16-pgdd;
apt install postgresql-15-pgdd;
apt install postgresql-14-pgdd;
apt install postgresql-13-pgdd;
Create pgdd extension on PostgreSQL cluster:
11 - pg_permissions
view object permissions and compare them with the desired state
Overview
MIXED 3rd Party Extension: pg_permissions : view object permissions and compare them with the desired state
- Latest Version: 1.3
- 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: N/A
RPM / DEB
- RPM Repo: PGDG
- RPM Name:
pg_permissions_$v
- RPM Ver :
1.3
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-pg-permissions
- DEB Ver :
1.3
- DEB Deps: N/A
Availability
Installation
Install pg_permissions via the pig CLI tool:
pig ext install pg_permissions
Install pg_permissions via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_permissions"]}' # -l <cls>
Install pg_permissions RPM from YUM repo directly:
dnf install pg_permissions_17;
dnf install pg_permissions_16;
dnf install pg_permissions_15;
dnf install pg_permissions_14;
dnf install pg_permissions_13;
Install pg_permissions DEB from APT repo directly:
apt install postgresql-17-pg-permissions;
apt install postgresql-16-pg-permissions;
apt install postgresql-15-pg-permissions;
apt install postgresql-14-pg-permissions;
apt install postgresql-13-pg-permissions;
Create pg_permissions extension on PostgreSQL cluster:
CREATE EXTENSION pg_permissions;
12 - pgautofailover
pg_auto_failover
Overview
PGDG 1st Party Extension: pgautofailover : pg_auto_failover
- Latest Version: 2.2
- Postgres Support:
17,16,15,14,13
- Need Load: Explicit Loading Required
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Can be installed into other schemas
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires:
btree_gist
RPM / DEB
- RPM Repo: PGDG
- RPM Name:
pg_auto_failover_$v*
- RPM Ver :
2.2
- RPM Deps: N/A
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-auto-failover
- DEB Ver :
2.1
- DEB Deps: N/A
Availability
Installation
Install pgautofailover via the pig CLI tool:
pig ext install pgautofailover
Install pgautofailover via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pgautofailover"]}' # -l <cls>
Install pgautofailover RPM from YUM repo directly:
dnf install pg_auto_failover_16*;
dnf install pg_auto_failover_15*;
dnf install pg_auto_failover_14*;
dnf install pg_auto_failover_13*;
Install pgautofailover DEB from APT repo directly:
apt install postgresql-17-auto-failover;
apt install postgresql-16-auto-failover;
apt install postgresql-15-auto-failover;
apt install postgresql-14-auto-failover;
apt install postgresql-13-auto-failover;
Extension pgautofailover has to be loaded via shared_preload_libraries
shared_preload_libraries = 'pgautofailover'; # add to pg cluster config
Create pgautofailover extension on PostgreSQL cluster:
CREATE EXTENSION pgautofailover CASCADE;
13 - pg_catcheck
Diagnosing system catalog corruption
Overview
PGDG 1st Party Extension: pg_catcheck : Diagnosing system catalog corruption
- Latest Version: 1.6.0
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Unknown
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PGDG
- RPM Name:
pg_catcheck_$v*
- RPM Ver :
1.6.0
- RPM Deps: N/A
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-pg-catcheck
- DEB Ver :
1.4.0
- DEB Deps: N/A
Availability
Installation
Install pg_catcheck via the pig CLI tool:
pig ext install pg_catcheck
Install pg_catcheck via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_catcheck"]}' # -l <cls>
Install pg_catcheck RPM from YUM repo directly:
dnf install pg_catcheck_17*;
dnf install pg_catcheck_16*;
dnf install pg_catcheck_15*;
dnf install pg_catcheck_14*;
dnf install pg_catcheck_13*;
Install pg_catcheck DEB from APT repo directly:
apt install postgresql-17-pg-catcheck;
apt install postgresql-16-pg-catcheck;
apt install postgresql-15-pg-catcheck;
apt install postgresql-14-pg-catcheck;
apt install postgresql-13-pg-catcheck;
Create pg_catcheck extension on PostgreSQL cluster:
CREATE EXTENSION pg_catcheck;
14 - pre_prepare
Pre Prepare your Statement server side
Overview
MIXED 3rd Party Extension: preprepare : Pre Prepare your Statement server side
- Latest Version: 0.9
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Can not install to arbitrary schema
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PIGSTY
- RPM Name:
preprepare_$v*
- RPM Ver :
0.9
- RPM Deps: N/A
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-preprepare
- DEB Ver :
0.9
- DEB Deps: N/A
Availability
Installation
Install pre_prepare via the pig CLI tool:
pig ext install preprepare; # Extension Name
pig ext install pre_prepare; # normalized package name
Install preprepare via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["preprepare"]}' # -l <cls>
Install preprepare RPM from YUM repo directly:
dnf install preprepare_17*;
dnf install preprepare_16*;
dnf install preprepare_15*;
dnf install preprepare_14*;
dnf install preprepare_13*;
Install preprepare DEB from APT repo directly:
apt install postgresql-17-preprepare;
apt install postgresql-16-preprepare;
apt install postgresql-15-preprepare;
apt install postgresql-14-preprepare;
apt install postgresql-13-preprepare;
Create pre_prepare extension on PostgreSQL cluster:
CREATE EXTENSION pre_prepare;
15 - pg_upless
Detect Useless UPDATE
Overview
PIGSTY 3rd Party Extension: pg_upless : Detect Useless UPDATE
- Latest Version: 0.0.3
- 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:
pg_upless_$v
- RPM Ver :
0.0.3
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-pg-upless
- DEB Ver :
0.0.3
- DEB Deps: N/A
Availability
Installation
Install pg_upless via the pig CLI tool:
pig ext install pg_upless
Install pg_upless via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_upless"]}' # -l <cls>
Install pg_upless RPM from YUM repo directly:
dnf install pg_upless_17;
dnf install pg_upless_16;
dnf install pg_upless_15;
dnf install pg_upless_14;
dnf install pg_upless_13;
Install pg_upless DEB from APT repo directly:
apt install postgresql-17-pg-upless;
apt install postgresql-16-pg-upless;
apt install postgresql-15-pg-upless;
apt install postgresql-14-pg-upless;
apt install postgresql-13-pg-upless;
Create pg_upless extension on PostgreSQL cluster:
CREATE EXTENSION pg_upless CASCADE;
16 - pgcozy
Pre-warming shared buffers according to previous pg_buffercache snapshots for PostgreSQL.
Overview
PIGSTY 3rd Party Extension: pgcozy : Pre-warming shared buffers according to previous pg_buffercache snapshots for PostgreSQL.
- Latest Version: 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: Unknown
- Trusted: Unknown
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PIGSTY
- RPM Name:
pgcozy_$v
- RPM Ver :
1.0
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-pgcozy
- DEB Ver :
1.0
- DEB Deps: N/A
Availability
Installation
Install pgcozy via the pig CLI tool:
Install pgcozy via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pgcozy"]}' # -l <cls>
Install pgcozy RPM from YUM repo directly:
dnf install pgcozy_17;
dnf install pgcozy_16;
dnf install pgcozy_15;
dnf install pgcozy_14;
dnf install pgcozy_13;
Install pgcozy DEB from APT repo directly:
apt install postgresql-17-pgcozy;
apt install postgresql-16-pgcozy;
apt install postgresql-15-pgcozy;
apt install postgresql-14-pgcozy;
apt install postgresql-13-pgcozy;
Create pgcozy extension on PostgreSQL cluster:
17 - pg_orphaned
Deal with orphaned files
Overview
PIGSTY 3rd Party Extension: pg_orphaned : Deal with orphaned files
- Latest Version: 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: Unknown
- Trusted: Unknown
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PIGSTY
- RPM Name:
pg_orphaned_$v*
- RPM Ver :
1.0
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-pg-orphaned
- DEB Ver :
1.0
- DEB Deps: N/A
Availability
Installation
Install pg_orphaned via the pig CLI tool:
pig ext install pg_orphaned
Install pg_orphaned via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_orphaned"]}' # -l <cls>
Install pg_orphaned RPM from YUM repo directly:
dnf install pg_orphaned_17*;
dnf install pg_orphaned_16*;
dnf install pg_orphaned_15*;
dnf install pg_orphaned_14*;
dnf install pg_orphaned_13*;
Install pg_orphaned DEB from APT repo directly:
apt install postgresql-17-pg-orphaned;
apt install postgresql-16-pg-orphaned;
apt install postgresql-15-pg-orphaned;
apt install postgresql-14-pg-orphaned;
apt install postgresql-13-pg-orphaned;
Create pg_orphaned extension on PostgreSQL cluster:
CREATE EXTENSION pg_orphaned;
18 - pg_crash
Send random signals to random processes
Overview
PIGSTY 3rd Party Extension: pg_crash : Send random signals to random processes
- Latest Version: 1.0
- Postgres Support:
17,16,15,14,13
- Need Load: Explicit Loading Required
- Need DDL: Dd not need
CREATE EXTENSION DDL
- Relocatable: Can be installed into other schemas
- Trusted: Unknown
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PIGSTY
- RPM Name:
pg_crash_$v*
- RPM Ver :
1.0
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-pg-crash
- DEB Ver :
1.0
- DEB Deps: N/A
Availability
Installation
Install pg_crash via the pig CLI tool:
Install pg_crash via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_crash"]}' # -l <cls>
Install pg_crash RPM from YUM repo directly:
dnf install pg_crash_17*;
dnf install pg_crash_16*;
dnf install pg_crash_15*;
dnf install pg_crash_14*;
dnf install pg_crash_13*;
Install pg_crash DEB from APT repo directly:
apt install postgresql-17-pg-crash;
apt install postgresql-16-pg-crash;
apt install postgresql-15-pg-crash;
apt install postgresql-14-pg-crash;
apt install postgresql-13-pg-crash;
Extension pg_crash has to be loaded via shared_preload_libraries
shared_preload_libraries = 'pg_crash'; # add to pg cluster config
Extension %s does not need CREATE EXTENSION command
19 - pg_cheat_funcs
Provides cheat (but useful) functions
Overview
PIGSTY 3rd Party Extension: pg_cheat_funcs : Provides cheat (but useful) functions
- Latest Version: 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 not install to arbitrary schema
- Trusted: Unknown
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PIGSTY
- RPM Name:
pg_cheat_funcs_$v*
- RPM Ver :
1.0
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-pg-cheat-funcs
- DEB Ver :
1.0
- DEB Deps: N/A
Availability
Installation
Install pg_cheat_funcs via the pig CLI tool:
pig ext install pg_cheat_funcs
Install pg_cheat_funcs via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_cheat_funcs"]}' # -l <cls>
Install pg_cheat_funcs RPM from YUM repo directly:
dnf install pg_cheat_funcs_17*;
dnf install pg_cheat_funcs_16*;
dnf install pg_cheat_funcs_15*;
dnf install pg_cheat_funcs_14*;
dnf install pg_cheat_funcs_13*;
Install pg_cheat_funcs DEB from APT repo directly:
apt install postgresql-17-pg-cheat-funcs;
apt install postgresql-16-pg-cheat-funcs;
apt install postgresql-15-pg-cheat-funcs;
apt install postgresql-14-pg-cheat-funcs;
apt install postgresql-13-pg-cheat-funcs;
Create pg_cheat_funcs extension on PostgreSQL cluster:
CREATE EXTENSION pg_cheat_funcs;
20 - fio
PostgreSQL File I/O Functions
Overview
PIGSTY 3rd Party Extension: pg_fio : PostgreSQL File I/O Functions
- Latest Version: 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 not install to arbitrary schema
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PIGSTY
- RPM Name:
pg_fio_$v
- RPM Ver :
1.0
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-pg-fio
- DEB Ver :
1.0
- DEB Deps: N/A
Availability
Installation
Install fio via the pig CLI tool:
pig ext install pg_fio; # Extension Name
pig ext install fio; # normalized package name
Install pg_fio via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_fio"]}' # -l <cls>
Install pg_fio RPM from YUM repo directly:
dnf install pg_fio_17;
dnf install pg_fio_16;
dnf install pg_fio_15;
dnf install pg_fio_14;
dnf install pg_fio_13;
Install pg_fio DEB from APT repo directly:
apt install postgresql-17-pg-fio;
apt install postgresql-16-pg-fio;
apt install postgresql-15-pg-fio;
apt install postgresql-14-pg-fio;
apt install postgresql-13-pg-fio;
Create fio extension on PostgreSQL cluster:
21 - pg_savior
Postgres extension to save OOPS mistakes
Overview
PIGSTY 3rd Party Extension: pg_savior : Postgres extension to save OOPS mistakes
- Latest Version: 0.0.1
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Can not install to arbitrary schema
- Trusted: Unknown
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PIGSTY
- RPM Name:
pg_savior_$v*
- RPM Ver :
0.0.1
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-pg-savior
- DEB Ver :
0.0.1
- DEB Deps: N/A
Availability
Installation
Install pg_savior via the pig CLI tool:
pig ext install pg_savior
Install pg_savior via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_savior"]}' # -l <cls>
Install pg_savior RPM from YUM repo directly:
dnf install pg_savior_17*;
dnf install pg_savior_16*;
dnf install pg_savior_15*;
dnf install pg_savior_14*;
dnf install pg_savior_13*;
Install pg_savior DEB from APT repo directly:
apt install postgresql-17-pg-savior;
apt install postgresql-16-pg-savior;
apt install postgresql-15-pg-savior;
apt install postgresql-14-pg-savior;
apt install postgresql-13-pg-savior;
Create pg_savior extension on PostgreSQL cluster:
CREATE EXTENSION pg_savior;
22 - safeupdate
Require criteria for UPDATE and DELETE
Overview
PGDG 1st Party Extension: safeupdate : Require criteria for UPDATE and DELETE
- Latest Version: 1.5
- Postgres Support:
17,16,15,14,13
- Need Load: Explicit Loading Required
- Need DDL: Dd not need
CREATE EXTENSION DDL
- Relocatable: Unknown
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PGDG
- RPM Name:
safeupdate_$v*
- RPM Ver :
1.5
- RPM Deps: N/A
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-pg-safeupdate
- DEB Ver :
1.5
- DEB Deps: N/A
Availability
Installation
Install safeupdate via the pig CLI tool:
pig ext install safeupdate
Install safeupdate via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["safeupdate"]}' # -l <cls>
Install safeupdate RPM from YUM repo directly:
dnf install safeupdate_17*;
dnf install safeupdate_16*;
dnf install safeupdate_15*;
dnf install safeupdate_14*;
dnf install safeupdate_13*;
Install safeupdate DEB from APT repo directly:
apt install postgresql-17-pg-safeupdate;
apt install postgresql-16-pg-safeupdate;
apt install postgresql-15-pg-safeupdate;
apt install postgresql-14-pg-safeupdate;
Extension safeupdate has to be loaded via shared_preload_libraries
shared_preload_libraries = 'safeupdate'; # add to pg cluster config
Extension %s does not need CREATE EXTENSION command
23 - pg_drop_events
logs transaction ids of drop table, drop column, drop materialized view statements
Overview
PGDG 3rd Party Extension: pg_drop_events : logs transaction ids of drop table, drop column, drop materialized view statements
- Latest Version: 0.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: Untrusted, Require Superuser to Create
- Schemas:
public
- Requires:
plpgsql
RPM / DEB
- RPM Repo: PGDG
- RPM Name:
pg_drop_events_$v
- RPM Ver :
0.1.0
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-pg-drop-events
- DEB Ver :
0.1.0
- DEB Deps: N/A
Availability
Installation
Install pg_drop_events via the pig CLI tool:
pig ext install pg_drop_events
Install pg_drop_events via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_drop_events"]}' # -l <cls>
Install pg_drop_events RPM from YUM repo directly:
dnf install pg_drop_events_17;
dnf install pg_drop_events_16;
dnf install pg_drop_events_15;
dnf install pg_drop_events_14;
dnf install pg_drop_events_13;
Install pg_drop_events DEB from APT repo directly:
apt install postgresql-17-pg-drop-events;
apt install postgresql-16-pg-drop-events;
apt install postgresql-15-pg-drop-events;
apt install postgresql-14-pg-drop-events;
apt install postgresql-13-pg-drop-events;
Create pg_drop_events extension on PostgreSQL cluster:
CREATE EXTENSION pg_drop_events CASCADE;
24 - table_log
record table modification logs and PITR for table/row
Overview
MIXED 3rd Party Extension: table_log : record table modification logs and PITR for table/row
- Latest Version: 0.6.4
- 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: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PIGSTY
- RPM Name:
table_log_$v
- RPM Ver :
0.6.4
- RPM Deps: N/A
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-tablelog
- DEB Ver :
0.6.4
- DEB Deps: N/A
Availability
Installation
Install table_log via the pig CLI tool:
pig ext install table_log
Install table_log via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["table_log"]}' # -l <cls>
Install table_log RPM from YUM repo directly:
dnf install table_log_17;
dnf install table_log_16;
dnf install table_log_15;
dnf install table_log_14;
dnf install table_log_13;
Install table_log DEB from APT repo directly:
apt install postgresql-17-tablelog;
apt install postgresql-16-tablelog;
apt install postgresql-15-tablelog;
apt install postgresql-14-tablelog;
apt install postgresql-13-tablelog;
Create table_log extension on PostgreSQL cluster:
CREATE EXTENSION table_log;
25 - pgagent
A PostgreSQL job scheduler
Overview
PGDG 1st Party Extension: pgagent : A PostgreSQL job scheduler
- Latest Version: 4.2.3
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Unknown
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PGDG
- RPM Name:
pgagent_$v*
- RPM Ver :
4.2.3
- RPM Deps: N/A
- DEB Repo: PGDG
- DEB Name:
pgagent
- DEB Ver :
4.2.3
- DEB Deps: N/A
Availability
Installation
Install pgagent via the pig CLI tool:
Install pgagent via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pgagent"]}' # -l <cls>
Install pgagent RPM from YUM repo directly:
dnf install pgagent_17*;
dnf install pgagent_16*;
dnf install pgagent_15*;
dnf install pgagent_14*;
dnf install pgagent_13*;
Install pgagent DEB from APT repo directly:
Create pgagent extension on PostgreSQL cluster:
CREATE EXTENSION pgagent;
26 - pg_prewarm
prewarm relation data
Overview
CONTRIB Built-in Extension: pg_prewarm : prewarm relation data
- Latest Version: 1.2
- Postgres Support:
17,16,15,14,13
- Need Load: Explicit Loading Required
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Unknown
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
PostgreSQL Built-in Contrib Extension
Availability
| OS |
Arch |
PG17 |
PG16 |
PG15 |
PG14 |
PG13 |
el8 |
x86_64 |
|
|
|
|
|
el8 |
aarch64 |
|
|
|
|
|
el9 |
x86_64 |
|
|
|
|
|
el9 |
aarch64 |
|
|
|
|
|
d12 |
x86_64 |
|
|
|
|
|
d12 |
aarch64 |
|
|
|
|
|
u22 |
x86_64 |
|
|
|
|
|
u22 |
aarch64 |
|
|
|
|
|
u24 |
x86_64 |
|
|
|
|
|
u24 |
aarch64 |
|
|
|
|
|
Installation
Extension pg_prewarm is PostgreSQL Built-in Contrib Extension which is installed along with the kernel/contrib.
Install pg_prewarm RPM from YUM repo directly:
dnf install postgresql17-contrib;
dnf install postgresql16-contrib;
dnf install postgresql15-contrib;
dnf install postgresql14-contrib;
dnf install postgresql13-contrib;
Install pg_prewarm DEB from APT repo directly:
apt install postgresql-17;
apt install postgresql-16;
apt install postgresql-15;
apt install postgresql-14;
apt install postgresql-13;
Extension pg_prewarm has to be loaded via shared_preload_libraries
shared_preload_libraries = 'pg_prewarm'; # add to pg cluster config
Create pg_prewarm extension on PostgreSQL cluster:
CREATE EXTENSION pg_prewarm;
27 - pgpool_adm
Administrative functions for pgPool
Overview
PGDG 1st Party Extension: pgpool : Administrative functions for pgPool
- Extension ID: 5900
- Extension Name:
pgpool_adm
- Package Name:
pgpool
- Category:
ADMIN
- License: PostgreSQL
- Website: https://pgpool.net/
- Language: C
- Extra Tags: N/A
- Comment: N/A
- Latest Version: 4.6.0
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Unknown
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PGDG
- RPM Name:
pgpool-II-pg$v-extensions
- RPM Ver :
4.6.0
- RPM Deps: N/A
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-pgpool2
- DEB Ver :
4.6.0
- DEB Deps: N/A
Availability
Installation
Install pgpool_adm via the pig CLI tool:
pig ext install pgpool; # Extension Name
pig ext install pgpool_adm; # normalized package name
Install pgpool via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pgpool"]}' # -l <cls>
Install pgpool RPM from YUM repo directly:
dnf install pgpool-II-pg17-extensions;
dnf install pgpool-II-pg16-extensions;
dnf install pgpool-II-pg15-extensions;
dnf install pgpool-II-pg14-extensions;
dnf install pgpool-II-pg13-extensions;
Install pgpool DEB from APT repo directly:
apt install postgresql-17-pgpool2;
apt install postgresql-16-pgpool2;
apt install postgresql-15-pgpool2;
apt install postgresql-14-pgpool2;
apt install postgresql-13-pgpool2;
Create pgpool_adm extension on PostgreSQL cluster:
CREATE EXTENSION pgpool_adm;
28 - pgpool_recovery
recovery functions for pgpool-II for V4.3
Overview
PGDG 1st Party Extension: pgpool : recovery functions for pgpool-II for V4.3
- Extension ID: 5910
- Extension Name:
pgpool_recovery
- Package Name:
pgpool
- Category:
ADMIN
- License: PostgreSQL
- Website: https://pgpool.net/
- Language: C
- Extra Tags: N/A
- Comment: N/A
- Latest Version: 4.6.0
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Unknown
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PGDG
- RPM Name:
pgpool-II-pg$v-extensions
- RPM Ver :
4.6.0
- RPM Deps: N/A
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-pgpool2
- DEB Ver :
4.6.0
- DEB Deps: N/A
Availability
Installation
Install pgpool_recovery via the pig CLI tool:
pig ext install pgpool; # Extension Name
pig ext install pgpool_recovery; # normalized package name
Install pgpool via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pgpool"]}' # -l <cls>
Install pgpool RPM from YUM repo directly:
dnf install pgpool-II-pg17-extensions;
dnf install pgpool-II-pg16-extensions;
dnf install pgpool-II-pg15-extensions;
dnf install pgpool-II-pg14-extensions;
dnf install pgpool-II-pg13-extensions;
Install pgpool DEB from APT repo directly:
apt install postgresql-17-pgpool2;
apt install postgresql-16-pgpool2;
apt install postgresql-15-pgpool2;
apt install postgresql-14-pgpool2;
apt install postgresql-13-pgpool2;
Create pgpool_recovery extension on PostgreSQL cluster:
CREATE EXTENSION pgpool_recovery;
29 - pgpool_regclass
replacement for regclass
Overview
PGDG 1st Party Extension: pgpool : replacement for regclass
- Extension ID: 5920
- Extension Name:
pgpool_regclass
- Package Name:
pgpool
- Category:
ADMIN
- License: PostgreSQL
- Website: https://pgpool.net/
- Language: C
- Extra Tags: N/A
- Comment: N/A
- Latest Version: 4.6.0
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Unknown
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PGDG
- RPM Name:
pgpool-II-pg$v-extensions
- RPM Ver :
4.6.0
- RPM Deps: N/A
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-pgpool2
- DEB Ver :
4.6.0
- DEB Deps: N/A
Availability
Installation
Install pgpool_regclass via the pig CLI tool:
pig ext install pgpool; # Extension Name
pig ext install pgpool_regclass; # normalized package name
Install pgpool via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pgpool"]}' # -l <cls>
Install pgpool RPM from YUM repo directly:
dnf install pgpool-II-pg17-extensions;
dnf install pgpool-II-pg16-extensions;
dnf install pgpool-II-pg15-extensions;
dnf install pgpool-II-pg14-extensions;
dnf install pgpool-II-pg13-extensions;
Install pgpool DEB from APT repo directly:
apt install postgresql-17-pgpool2;
apt install postgresql-16-pgpool2;
apt install postgresql-15-pgpool2;
apt install postgresql-14-pgpool2;
apt install postgresql-13-pgpool2;
Create pgpool_regclass extension on PostgreSQL cluster:
CREATE EXTENSION pgpool_regclass;
30 - lo
Large Object maintenance
Overview
CONTRIB Built-in Extension: lo : Large Object maintenance
- Latest Version: 1.1
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Unknown
- Trusted: Trusted, Can be created by user with
CREATE Privilege
- Schemas: N/A
- Requires: N/A
RPM / DEB
PostgreSQL Built-in Contrib Extension
Availability
| OS |
Arch |
PG17 |
PG16 |
PG15 |
PG14 |
PG13 |
el8 |
x86_64 |
|
|
|
|
|
el8 |
aarch64 |
|
|
|
|
|
el9 |
x86_64 |
|
|
|
|
|
el9 |
aarch64 |
|
|
|
|
|
d12 |
x86_64 |
|
|
|
|
|
d12 |
aarch64 |
|
|
|
|
|
u22 |
x86_64 |
|
|
|
|
|
u22 |
aarch64 |
|
|
|
|
|
u24 |
x86_64 |
|
|
|
|
|
u24 |
aarch64 |
|
|
|
|
|
Installation
Extension lo is PostgreSQL Built-in Contrib Extension which is installed along with the kernel/contrib.
Install lo RPM from YUM repo directly:
dnf install postgresql17-contrib;
dnf install postgresql16-contrib;
dnf install postgresql15-contrib;
dnf install postgresql14-contrib;
dnf install postgresql13-contrib;
Install lo DEB from APT repo directly:
apt install postgresql-17;
apt install postgresql-16;
apt install postgresql-15;
apt install postgresql-14;
apt install postgresql-13;
Create lo extension on PostgreSQL cluster:
31 - basic_archive
an example of an archive module
Overview
CONTRIB Built-in Extension: basic_archive : an example of an archive module
- Latest Version: -
- Postgres Support:
17,16,15
- Need Load: Shared library do not need explicit loading
- Need DDL: Dd not need
CREATE EXTENSION DDL
- Relocatable: Unknown
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
PostgreSQL Built-in Contrib Extension
Availability
| OS |
Arch |
PG17 |
PG16 |
PG15 |
PG14 |
PG13 |
el8 |
x86_64 |
|
|
|
|
|
el8 |
aarch64 |
|
|
|
|
|
el9 |
x86_64 |
|
|
|
|
|
el9 |
aarch64 |
|
|
|
|
|
d12 |
x86_64 |
|
|
|
|
|
d12 |
aarch64 |
|
|
|
|
|
u22 |
x86_64 |
|
|
|
|
|
u22 |
aarch64 |
|
|
|
|
|
u24 |
x86_64 |
|
|
|
|
|
u24 |
aarch64 |
|
|
|
|
|
Installation
Extension basic_archive is PostgreSQL Built-in Contrib Extension which is installed along with the kernel/contrib.
Install basic_archive RPM from YUM repo directly:
dnf install postgresql17-contrib;
dnf install postgresql16-contrib;
dnf install postgresql15-contrib;
Install basic_archive DEB from APT repo directly:
apt install postgresql-17;
apt install postgresql-16;
apt install postgresql-15;
Extension %s does not need CREATE EXTENSION command
32 - basebackup_to_shell
adds a custom basebackup target called shell
Overview
CONTRIB Built-in Extension: basebackup_to_shell : adds a custom basebackup target called shell
- Latest Version: -
- Postgres Support:
17,16,15
- Need Load: Shared library do not need explicit loading
- Need DDL: Dd not need
CREATE EXTENSION DDL
- Relocatable: Unknown
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
PostgreSQL Built-in Contrib Extension
Availability
| OS |
Arch |
PG17 |
PG16 |
PG15 |
PG14 |
PG13 |
el8 |
x86_64 |
|
|
|
|
|
el8 |
aarch64 |
|
|
|
|
|
el9 |
x86_64 |
|
|
|
|
|
el9 |
aarch64 |
|
|
|
|
|
d12 |
x86_64 |
|
|
|
|
|
d12 |
aarch64 |
|
|
|
|
|
u22 |
x86_64 |
|
|
|
|
|
u22 |
aarch64 |
|
|
|
|
|
u24 |
x86_64 |
|
|
|
|
|
u24 |
aarch64 |
|
|
|
|
|
Installation
Extension basebackup_to_shell is PostgreSQL Built-in Contrib Extension which is installed along with the kernel/contrib.
Install basebackup_to_shell RPM from YUM repo directly:
dnf install postgresql17-contrib;
dnf install postgresql16-contrib;
dnf install postgresql15-contrib;
Install basebackup_to_shell DEB from APT repo directly:
apt install postgresql-17;
apt install postgresql-16;
apt install postgresql-15;
Extension %s does not need CREATE EXTENSION command
33 - old_snapshot
utilities in support of old_snapshot_threshold
Overview
CONTRIB Built-in Extension: old_snapshot : utilities in support of old_snapshot_threshold
- Latest Version: 1.0
- Postgres Support:
16,15,14
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Unknown
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
PostgreSQL Built-in Contrib Extension
Availability
| OS |
Arch |
PG17 |
PG16 |
PG15 |
PG14 |
PG13 |
el8 |
x86_64 |
|
|
|
|
|
el8 |
aarch64 |
|
|
|
|
|
el9 |
x86_64 |
|
|
|
|
|
el9 |
aarch64 |
|
|
|
|
|
d12 |
x86_64 |
|
|
|
|
|
d12 |
aarch64 |
|
|
|
|
|
u22 |
x86_64 |
|
|
|
|
|
u22 |
aarch64 |
|
|
|
|
|
u24 |
x86_64 |
|
|
|
|
|
u24 |
aarch64 |
|
|
|
|
|
Installation
Extension old_snapshot is PostgreSQL Built-in Contrib Extension which is installed along with the kernel/contrib.
Install old_snapshot RPM from YUM repo directly:
dnf install postgresql16-contrib;
dnf install postgresql15-contrib;
dnf install postgresql14-contrib;
Install old_snapshot DEB from APT repo directly:
apt install postgresql-16;
apt install postgresql-15;
apt install postgresql-14;
Create old_snapshot extension on PostgreSQL cluster:
CREATE EXTENSION old_snapshot;
34 - adminpack
administrative functions for PostgreSQL
Overview
CONTRIB Built-in Extension: adminpack : administrative functions for PostgreSQL
- Latest Version: 2.1
- Postgres Support:
16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Unknown
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
PostgreSQL Built-in Contrib Extension
Availability
| OS |
Arch |
PG17 |
PG16 |
PG15 |
PG14 |
PG13 |
el8 |
x86_64 |
|
|
|
|
|
el8 |
aarch64 |
|
|
|
|
|
el9 |
x86_64 |
|
|
|
|
|
el9 |
aarch64 |
|
|
|
|
|
d12 |
x86_64 |
|
|
|
|
|
d12 |
aarch64 |
|
|
|
|
|
u22 |
x86_64 |
|
|
|
|
|
u22 |
aarch64 |
|
|
|
|
|
u24 |
x86_64 |
|
|
|
|
|
u24 |
aarch64 |
|
|
|
|
|
Installation
Extension adminpack is PostgreSQL Built-in Contrib Extension which is installed along with the kernel/contrib.
Install adminpack RPM from YUM repo directly:
dnf install postgresql16-contrib;
dnf install postgresql15-contrib;
dnf install postgresql14-contrib;
dnf install postgresql13-contrib;
Install adminpack DEB from APT repo directly:
apt install postgresql-16;
apt install postgresql-15;
apt install postgresql-14;
apt install postgresql-13;
Create adminpack extension on PostgreSQL cluster:
CREATE EXTENSION adminpack;
35 - amcheck
functions for verifying relation integrity
Overview
CONTRIB Built-in Extension: amcheck : functions for verifying relation integrity
- Latest Version: 1.4
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Unknown
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
PostgreSQL Built-in Contrib Extension
Availability
| OS |
Arch |
PG17 |
PG16 |
PG15 |
PG14 |
PG13 |
el8 |
x86_64 |
|
|
|
|
|
el8 |
aarch64 |
|
|
|
|
|
el9 |
x86_64 |
|
|
|
|
|
el9 |
aarch64 |
|
|
|
|
|
d12 |
x86_64 |
|
|
|
|
|
d12 |
aarch64 |
|
|
|
|
|
u22 |
x86_64 |
|
|
|
|
|
u22 |
aarch64 |
|
|
|
|
|
u24 |
x86_64 |
|
|
|
|
|
u24 |
aarch64 |
|
|
|
|
|
Installation
Extension amcheck is PostgreSQL Built-in Contrib Extension which is installed along with the kernel/contrib.
Install amcheck RPM from YUM repo directly:
dnf install postgresql17-contrib;
dnf install postgresql16-contrib;
dnf install postgresql15-contrib;
dnf install postgresql14-contrib;
dnf install postgresql13-contrib;
Install amcheck DEB from APT repo directly:
apt install postgresql-17;
apt install postgresql-16;
apt install postgresql-15;
apt install postgresql-14;
apt install postgresql-13;
Create amcheck extension on PostgreSQL cluster:
CREATE EXTENSION amcheck;
36 - pg_surgery
extension to perform surgery on a damaged relation
Overview
CONTRIB Built-in Extension: pg_surgery : extension to perform surgery on a damaged relation
- Latest Version: 1.0
- Postgres Support:
17,16,15,14
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Unknown
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
PostgreSQL Built-in Contrib Extension
Availability
| OS |
Arch |
PG17 |
PG16 |
PG15 |
PG14 |
PG13 |
el8 |
x86_64 |
|
|
|
|
|
el8 |
aarch64 |
|
|
|
|
|
el9 |
x86_64 |
|
|
|
|
|
el9 |
aarch64 |
|
|
|
|
|
d12 |
x86_64 |
|
|
|
|
|
d12 |
aarch64 |
|
|
|
|
|
u22 |
x86_64 |
|
|
|
|
|
u22 |
aarch64 |
|
|
|
|
|
u24 |
x86_64 |
|
|
|
|
|
u24 |
aarch64 |
|
|
|
|
|
Installation
Extension pg_surgery is PostgreSQL Built-in Contrib Extension which is installed along with the kernel/contrib.
Install pg_surgery RPM from YUM repo directly:
dnf install postgresql17-contrib;
dnf install postgresql16-contrib;
dnf install postgresql15-contrib;
dnf install postgresql14-contrib;
Install pg_surgery DEB from APT repo directly:
apt install postgresql-17;
apt install postgresql-16;
apt install postgresql-15;
apt install postgresql-14;
Create pg_surgery extension on PostgreSQL cluster:
CREATE EXTENSION pg_surgery;