ADMIN - Administration

Extension List

There are 40 extensions in 38 packages.

pg_repack

pg_repack - 1.5.3 : Reorganize tables in PostgreSQL databases with minimal locks

pg_rewrite

pg_rewrite - 2.1.0 : Tool allows read write to the table during the rewriting

pg_squeeze

pg_squeeze - 1.9.1 : A tool to remove unused space from a relation.

pg_dirtyread

pg_dirtyread - 2.7 : Read dead but unvacuumed rows from table

pgfincore

pgfincore - 1.3.1 : examine and manage the os buffer cache

pg_cooldown

pg_cooldown - 0.1 : remove buffered pages for specific relations

ddlx

pg_ddlx - 0.30 : DDL eXtractor functions

pglinter

pglinter - 1.1.1 : PostgreSQL Linting and Analysis Extension

prioritize

pg_prioritize - 1.0.4 : get and set the priority of PostgreSQL backends

pg_checksums

pg_checksums - 1.3 : Activate/deactivate/verify checksums in offline Postgres clusters

pg_readonly

pg_readonly - 1.0.4 : cluster database read only

pgdd

pgdd - 0.6.1 : Introspect pg data dictionary via standard SQL

pg_permissions

pg_permissions - 1.4 : view object permissions and compare them with the desired state

pgautofailover

pgautofailover - 2.2 : pg_auto_failover

pg_catcheck

pg_catcheck - 1.6.0 : Diagnosing system catalog corruption

pre_prepare

preprepare - 0.9 : Pre Prepare your Statement server side

pg_upless

pg_upless - 0.0.3 : Detect Useless UPDATE

pgcozy

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

pg_orphaned

pg_orphaned - 1.0 : Deal with orphaned files

pg_crash

pg_crash - 1.0 : Send random signals to random processes

pg_cheat_funcs

pg_cheat_funcs - 1.0 : Provides cheat (but useful) functions

fio

pg_fio - 1.0 : PostgreSQL File I/O Functions

qos

pg_qos - 1.0 : QoS resource governor extension for PostgreSQL sessions and queries

pg_savior

pg_savior - 0.0.1 : Postgres extension to save OOPS mistakes

safeupdate

safeupdate - 1.5 : Require criteria for UPDATE and DELETE

pg_strict

pg_strict - 1.0.2 : Prevent dangerous UPDATE and DELETE without WHERE clause

pg_drop_events

pg_drop_events - 0.1.0 : logs transaction ids of drop table, drop column, drop materialized view statements

table_log

table_log - 0.6.4 : record table modification logs and PITR for table/row

pgagent

pgagent - 4.2.3 : A PostgreSQL job scheduler

pg_prewarm

pg_prewarm - 1.2 : prewarm relation data

pgpool_adm

pgpool - 4.7.1 : Administrative functions for pgPool

pgpool_recovery

pgpool - 4.7.1 : recovery functions for pgpool-II for V4.3

pgpool_regclass

pgpool - 4.7.1 : replacement for regclass

lo

lo - 1.1 : Large Object maintenance

basic_archive

basic_archive - - : an example of an archive module

basebackup_to_shell

basebackup_to_shell - - : adds a custom basebackup target called shell

old_snapshot

old_snapshot - 1.0 : utilities in support of old_snapshot_threshold

adminpack

adminpack - 2.1 : administrative functions for PostgreSQL

amcheck

amcheck - 1.4 : functions for verifying relation integrity

pg_surgery

pg_surgery - 1.0 : extension to perform surgery on a damaged relation