PIGSTY

ADMIN

Utilities for Bloat Control, DirtyRead, BufferInspect, DDL Generate, ChecksumVerify, Permission, Priority, Catalog

ADMIN category contains 36 PostgreSQL extensions.

IDExtensionPackageVersionDescription
5010pg_repackpg_repack1.5.2Reorganize tables in PostgreSQL databases with minimal locks
5020pg_squeezepg_squeeze1.8.0A tool to remove unused space from a relation.
5030pg_dirtyreadpg_dirtyread2.7Read dead but unvacuumed rows from table
5040pgfincorepgfincore1.3.1examine and manage the os buffer cache
5050pg_cooldownpg_cooldown0.1remove buffered pages for specific relations
5060ddlxpg_ddlx0.29DDL eXtractor functions
5070prioritizepg_prioritize1.0.4get and set the priority of PostgreSQL backends
5080pg_checksumspg_checksums1.2Activate/deactivate/verify checksums in offline Postgres clusters
5090pg_readonlypg_readonly1.0.3cluster database read only
5100pgddpgdd0.6.0Introspect pg data dictionary via standard SQL
5110pg_permissionspg_permissions1.3view object permissions and compare them with the desired state
5120pgautofailoverpgautofailover2.2pg_auto_failover
5130pg_catcheckpg_catcheck1.6.0Diagnosing system catalog corruption
5140pre_preparepreprepare0.9Pre Prepare your Statement server side
5150pg_uplesspg_upless0.0.3Detect Useless UPDATE
5170pgcozypgcozy1.0Pre-warming shared buffers according to previous pg_buffercache snapshots for PostgreSQL.
5180pg_orphanedpg_orphaned1.0Deal with orphaned files
5190pg_crashpg_crash1.0Send random signals to random processes
5200pg_cheat_funcspg_cheat_funcs1.0Provides cheat (but useful) functions
5230fiopg_fio1.0PostgreSQL File I/O Functions
5810pg_saviorpg_savior0.0.1Postgres extension to save OOPS mistakes
5820safeupdatesafeupdate1.5Require criteria for UPDATE and DELETE
5830pg_drop_eventspg_drop_events0.1.0logs transaction ids of drop table, drop column, drop materialized view statements
5840table_logtable_log0.6.4record table modification logs and PITR for table/row
5880pgagentpgagent4.2.3A PostgreSQL job scheduler
5890pg_prewarmpg_prewarm1.2prewarm relation data
5900pgpool_admpgpool4.6.0Administrative functions for pgPool
5910pgpool_recoverypgpool4.6.0recovery functions for pgpool-II for V4.3
5920pgpool_regclasspgpool4.6.0replacement for regclass
5930lolo1.1Large Object maintenance
5940basic_archivebasic_archive-an example of an archive module
5950basebackup_to_shellbasebackup_to_shell-adds a custom basebackup target called shell
5960old_snapshotold_snapshot1.0utilities in support of old_snapshot_threshold
5970adminpackadminpack2.1administrative functions for PostgreSQL
5980amcheckamcheck1.4functions for verifying relation integrity
5990pg_surgerypg_surgery1.0extension to perform surgery on a damaged relation

pg_repack - 1.5.2

Reorganize tables in PostgreSQL databases with minimal locks

ExtensionWebsiteAttributes
Packagepg_repack
RPMpg_repack_$v*
DDL
DEBpostgresql-$v-repack
LIB
Language
C
BIN
License
BSD 3-Clause
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pg_squeeze - 1.8.0

A tool to remove unused space from a relation.

ExtensionWebsiteAttributes
Packagepg_squeeze
LOAD
RPMpg_squeeze_$v*
DDL
DEBpostgresql-$v-squeeze
LIB
Language
C
License
BSD 2-Clause
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pg_dirtyread - 2.7

Read dead but unvacuumed rows from table

ExtensionWebsiteAttributes
Packagepg_dirtyread
RPMpg_dirtyread_$v*
DDL
DEBpostgresql-$v-dirtyread
LIB
Language
C
License
BSD 3-Clause
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pgfincore - 1.3.1

examine and manage the os buffer cache

ExtensionWebsiteAttributes
Packagepgfincore
RPMpgfincore_$v*
DDL
DEBpostgresql-$v-pgfincore
LIB
Language
C
License
BSD 3-Clause
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pg_cooldown - 0.1

remove buffered pages for specific relations

ExtensionWebsiteAttributes
Packagepg_cooldown
RPMpg_cooldown_$v*
DDL
DEBpostgresql-$v-pg-cooldown
LIB
Language
C
License
Apache-2.0
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

ddlx - 0.29

DDL eXtractor functions

ExtensionWebsiteAttributes
Packagepg_ddlx
RPMddlx_$v
DDL
DEBpostgresql-$v-ddlx
LIB
Language
SQL
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

prioritize - 1.0.4

get and set the priority of PostgreSQL backends

ExtensionWebsiteAttributes
Packagepg_prioritize
RPMpg_prioritize_$v*
DDL
DEBpostgresql-$v-prioritize
LIB
Language
C
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pg_checksums - 1.2

Activate/deactivate/verify checksums in offline Postgres clusters

ExtensionWebsiteAttributes
Packagepg_checksums
RPMpg_checksums_$v*
DEBpostgresql-$v-pg-checksums
LIB
Language
C
License
BSD 2-Clause
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pg_readonly - 1.0.3

cluster database read only

ExtensionWebsiteAttributes
Packagepg_readonly
RPMpg_readonly_$v*
DDL
DEBpostgresql-$v-pg-readonly
LIB
Language
C
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pgdd - 0.6.0

Introspect pg data dictionary via standard SQL

ExtensionWebsiteAttributes
Packagepgdd
RPMpgdd_$v
DDL
DEBpostgresql-$v-pgdd
LIB
Language
Rust
License
MIT
TRUST
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pg_permissions - 1.3

view object permissions and compare them with the desired state

ExtensionWebsiteAttributes
Packagepg_permissions
RPMpg_permissions_$v
DDL
DEBpostgresql-$v-pg-permissions
LIB
Language
SQL
License
BSD 2-Clause
TRUST
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pgautofailover - 2.2

pg_auto_failover

ExtensionWebsiteAttributes
Packagepgautofailover
LOAD
RPMpg_auto_failover_$v*
DDL
DEBpostgresql-$v-auto-failover
LIB
Language
C
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pg_catcheck - 1.6.0

Diagnosing system catalog corruption

ExtensionWebsiteAttributes
Packagepg_catcheck
RPMpg_catcheck_$v*
DDL
DEBpostgresql-$v-pg-catcheck
LIB
Language
C
License
BSD 3-Clause
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pre_prepare - 0.9

Pre Prepare your Statement server side

ExtensionWebsiteAttributes
Packagepreprepare
RPMpreprepare_$v*
DDL
DEBpostgresql-$v-preprepare
LIB
Language
C
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pg_upless - 0.0.3

Detect Useless UPDATE

ExtensionWebsiteAttributes
Packagepg_upless
RPMpg_upless_$v
DDL
DEBpostgresql-$v-pg-upless
Language
SQL
License
PostgreSQL
TRUST
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pgcozy - 1.0

Pre-warming shared buffers according to previous pg_buffercache snapshots for PostgreSQL.

ExtensionWebsiteAttributes
Packagepgcozy
RPMpgcozy_$v
DDL
DEBpostgresql-$v-pgcozy
Language
SQL
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pg_orphaned - 1.0

Deal with orphaned files

ExtensionWebsiteAttributes
Packagepg_orphaned
RPMpg_orphaned_$v*
DDL
DEBpostgresql-$v-pg-orphaned
LIB
Language
C
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pg_crash - 1.0

Send random signals to random processes

ExtensionWebsiteAttributes
Packagepg_crash
LOAD
RPMpg_crash_$v*
DEBpostgresql-$v-pg-crash
LIB
Language
C
License
BSD 3-Clause
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pg_cheat_funcs - 1.0

Provides cheat (but useful) functions

ExtensionWebsiteAttributes
Packagepg_cheat_funcs
RPMpg_cheat_funcs_$v*
DDL
DEBpostgresql-$v-pg-cheat-funcs
LIB
Language
C
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

fio - 1.0

PostgreSQL File I/O Functions

ExtensionWebsiteAttributes
Packagepg_fio
RPMpg_fio_$v
DDL
DEBpostgresql-$v-pg-fio
LIB
Language
C
License
BSD 3-Clause
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pg_savior - 0.0.1

Postgres extension to save OOPS mistakes

ExtensionWebsiteAttributes
Packagepg_savior
RPMpg_savior_$v*
DDL
DEBpostgresql-$v-pg-savior
LIB
Language
C
License
Apache-2.0
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

safeupdate - 1.5

Require criteria for UPDATE and DELETE

ExtensionWebsiteAttributes
Packagesafeupdate
LOAD
RPMsafeupdate_$v*
DEBpostgresql-$v-pg-safeupdate
LIB
Language
C
License
ISC
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pg_drop_events - 0.1.0

logs transaction ids of drop table, drop column, drop materialized view statements

ExtensionWebsiteAttributes
Packagepg_drop_events
RPMpg_drop_events_$v
DDL
DEBpostgresql-$v-pg-drop-events
Language
SQL
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

table_log - 0.6.4

record table modification logs and PITR for table/row

ExtensionWebsiteAttributes
Packagetable_log
RPMtable_log_$v
DDL
DEBpostgresql-$v-tablelog
LIB
Language
C
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pgagent - 4.2.3

A PostgreSQL job scheduler

ExtensionWebsiteAttributes
Packagepgagent
RPMpgagent_$v*
DDL
DEBpgagent
LIB
Language
C
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pg_prewarm - 1.2

prewarm relation data

ExtensionWebsiteAttributes
Packagepg_prewarm
LOAD
RPMpostgresql$v-contrib
DDL
DEBpostgresql-$v
LIB
Language
C
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pgpool_adm - 4.6.0

Administrative functions for pgPool

ExtensionWebsiteAttributes
Packagepgpool
RPMpgpool-II-pg$v-extensions
DDL
DEBpostgresql-$v-pgpool2
Language
C
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pgpool_recovery - 4.6.0

recovery functions for pgpool-II for V4.3

ExtensionWebsiteAttributes
Packagepgpool
RPMpgpool-II-pg$v-extensions
DDL
DEBpostgresql-$v-pgpool2
Language
C
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pgpool_regclass - 4.6.0

replacement for regclass

ExtensionWebsiteAttributes
Packagepgpool
RPMpgpool-II-pg$v-extensions
DDL
DEBpostgresql-$v-pgpool2
Language
C
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

lo - 1.1

Large Object maintenance

ExtensionWebsiteAttributes
Packagelo
RPMpostgresql$v-contrib
DDL
DEBpostgresql-$v
LIB
Language
C
License
PostgreSQL
TRUST
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

basic_archive - -

an example of an archive module

ExtensionWebsiteAttributes
Packagebasic_archive
RPMpostgresql$v-contrib
DEBpostgresql-$v
LIB
Language
C
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

basebackup_to_shell - -

adds a custom basebackup target called shell

ExtensionWebsiteAttributes
Packagebasebackup_to_shell
RPMpostgresql$v-contrib
DEBpostgresql-$v
LIB
Language
C
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

old_snapshot - 1.0

utilities in support of old_snapshot_threshold

ExtensionWebsiteAttributes
Packageold_snapshot
RPMpostgresql$v-contrib
DDL
DEBpostgresql-$v
LIB
Language
C
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

adminpack - 2.1

administrative functions for PostgreSQL

ExtensionWebsiteAttributes
Packageadminpack
RPMpostgresql$v-contrib
DDL
DEBpostgresql-$v
LIB
Language
C
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

amcheck - 1.4

functions for verifying relation integrity

ExtensionWebsiteAttributes
Packageamcheck
RPMpostgresql$v-contrib
DDL
DEBpostgresql-$v
LIB
Language
C
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pg_surgery - 1.0

extension to perform surgery on a damaged relation

ExtensionWebsiteAttributes
Packagepg_surgery
RPMpostgresql$v-contrib
DDL
DEBpostgresql-$v
LIB
Language
C
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13