Category: ADMIN

ADMIN: Utilities for Bloat Control, DirtyRead, BufferInspect, DDL Generate, ChecksumVerify, Permission, Priority, Catalog,…
Module:
Categories:
Tags:

ADMIN category has 35 available extensions:

Name (Detail) Package (Repo) Repo Version Category License LOAD DDL TRUST RELOC Description
pg_repack pg_repack PGDG 1.5.2 ADMIN BSD 3 Reorganize tables in PostgreSQL databases with minimal locks
pg_squeeze pg_squeeze PGDG 1.8 ADMIN BSD 2 A tool to remove unused space from a relation.
pg_dirtyread pg_dirtyread MIXED 2 ADMIN BSD 3 Read dead but unvacuumed rows from table
pgfincore pgfincore PGDG 1.3.1 ADMIN BSD 3 examine and manage the os buffer cache
pg_cooldown pg_cooldown PIGSTY 0.1 ADMIN Apache-2.0 remove buffered pages for specific relations
ddlx pg_ddlx MIXED 0.29 ADMIN PostgreSQL DDL eXtractor functions
prioritize pg_prioritize PGDG 1.0 ADMIN PostgreSQL get and set the priority of PostgreSQL backends
pg_checksums pg_checksums PGDG 1.1 ADMIN BSD 2 Activate/deactivate/verify checksums in offline Postgres clusters
pg_readonly pg_readonly PGDG 1.0.0 ADMIN PostgreSQL cluster database read only
pg_upless pg_upless PIGSTY 0.0.3 ADMIN PostgreSQL Detect Useless UPDATE
pg_permissions pg_permissions MIXED 1.3 ADMIN BSD 2 view object permissions and compare them with the desired state
pgautofailover pgautofailover PGDG 2.1 ADMIN PostgreSQL pg_auto_failover
pg_catcheck pg_catcheck PGDG 1.6.0 ADMIN BSD 3 Diagnosing system catalog corruption
pre_prepare preprepare MIXED 0.4 ADMIN PostgreSQL Pre Prepare your Statement server side
pgcozy pgcozy PIGSTY 1.0 ADMIN PostgreSQL Pre-warming shared buffers according to previous pg_buffercache snapshots for PostgreSQL.
pg_orphaned pg_orphaned PIGSTY 1.0 ADMIN PostgreSQL Deal with orphaned files
pg_crash pg_crash PIGSTY 1.0 ADMIN BSD 3 Send random signals to random processes
pg_cheat_funcs pg_cheat_funcs PIGSTY 1.0 ADMIN PostgreSQL Provides cheat (but useful) functions
fio pg_fio PIGSTY 1.0 ADMIN BSD 3 PostgreSQL File I/O Functions
pg_savior pg_savior PIGSTY 0.0.1 ADMIN Apache-2.0 Postgres extension to save OOPS mistakes
safeupdate safeupdate PGDG 1.4 ADMIN ISC Require criteria for UPDATE and DELETE
pg_drop_events pg_drop_events PGDG 0.1 ADMIN PostgreSQL logs transaction ids of drop table, drop column, drop materialized view statements
table_log table_log MIXED 0.6.1 ADMIN PostgreSQL record table modification logs and PITR for table/row
pgagent pgagent PGDG 4.2 ADMIN PostgreSQL A PostgreSQL job scheduler
pg_prewarm pg_prewarm CONTRIB 1.2 ADMIN PostgreSQL prewarm relation data
pgpool_adm pgpool PGDG 1.5 ADMIN PostgreSQL Administrative functions for pgPool
pgpool_recovery pgpool PGDG 1.4 ADMIN PostgreSQL recovery functions for pgpool-II for V4.3
lo lo CONTRIB 1.1 ADMIN PostgreSQL Large Object maintenance
pgpool_regclass pgpool PGDG 1.0 ADMIN PostgreSQL replacement for regclass
basic_archive basic_archive CONTRIB - ADMIN PostgreSQL an example of an archive module
basebackup_to_shell basebackup_to_shell CONTRIB - ADMIN PostgreSQL adds a custom basebackup target called shell
old_snapshot old_snapshot CONTRIB 1.0 ADMIN PostgreSQL utilities in support of old_snapshot_threshold
adminpack adminpack CONTRIB 2.1 ADMIN PostgreSQL administrative functions for PostgreSQL
amcheck amcheck CONTRIB 1.4 ADMIN PostgreSQL functions for verifying relation integrity
pg_surgery pg_surgery CONTRIB 1.0 ADMIN PostgreSQL extension to perform surgery on a damaged relation
pg_repack

Reorganize tables in PostgreSQL databases with minimal locks

pg_squeeze

A tool to remove unused space from a relation.

pg_dirtyread

Read dead but unvacuumed rows from table

pgfincore

examine and manage the os buffer cache

pg_cooldown

remove buffered pages for specific relations

ddlx

DDL eXtractor functions

prioritize

get and set the priority of PostgreSQL backends

pg_checksums

Activate/deactivate/verify checksums in offline Postgres clusters

pg_readonly

cluster database read only

pg_upless

Detect Useless UPDATE

pg_permissions

view object permissions and compare them with the desired state

pgautofailover

pg_auto_failover

pg_catcheck

Diagnosing system catalog corruption

pre_prepare

Pre Prepare your Statement server side

pgcozy

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

pg_orphaned

Deal with orphaned files

pg_crash

Send random signals to random processes

pg_cheat_funcs

Provides cheat (but useful) functions

fio

PostgreSQL File I/O Functions

pg_savior

Postgres extension to save OOPS mistakes

safeupdate

Require criteria for UPDATE and DELETE

pg_drop_events

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

table_log

record table modification logs and PITR for table/row

pgagent

A PostgreSQL job scheduler

pg_prewarm

prewarm relation data

pgpool_adm

Administrative functions for pgPool

pgpool_recovery

recovery functions for pgpool-II for V4.3

lo

Large Object maintenance

pgpool_regclass

replacement for regclass

basic_archive

an example of an archive module

basebackup_to_shell

adds a custom basebackup target called shell

old_snapshot

utilities in support of old_snapshot_threshold

adminpack

administrative functions for PostgreSQL

amcheck

functions for verifying relation integrity

pg_surgery

extension to perform surgery on a damaged relation


Last modified 2025-02-17: add extension part (cfa504b)