select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

PostgreSQL Extension Catalogue

Explore 2387 PostgreSQL extensions from PGEXT, maintained by Pigsty.

pg_repack · Reorganize tables in PostgreSQL databases with minimal locks · 1.5.3 · Administration · PostgreSQL · C · Packagedpgautofailover · pg_auto_failover · 2.2 · Administration · PostgreSQL · C · Packagedpglinter · PostgreSQL Linting and Analysis Extension · 2.0.0 · Administration · PostgreSQL · Rust · Packagedddlx · DDL eXtractor functions · 0.31 · Administration · PostgreSQL · SQL · Packagedsr_plan · Planner-hook extension that records, displays, and reuses saved execution plans, including parameterized-plan templates. · 1.2 · Administration · PostgreSQL · C · Not packagedptrack · Tracks changed PostgreSQL blocks for incremental backup using a shared-memory map and core storage hooks. · 2.4 · Administration · PostgreSQL · C · Not packagedpre_prepare · Pre Prepare your Statement server side · 0.9 · Administration · PostgreSQL · C · Packagedpg_cheat_funcs · Provides cheat (but useful) functions · 1.0 · Administration · PostgreSQL · C · Packagedpg_keeper · Background-worker based clustering module for monitoring streaming replication, changing synchronous replication mode and promoting a standby on failure. · 2.0 · Administration · PostgreSQL · C · Not packagedpg_healer · Proof-of-concept extension for automatically repairing PostgreSQL data corruption · 1.0 · Administration · PostgreSQL · C · Not packagedpgespresso · Optional Extension for Barman, Backup and Recovery Manager for PostgreSQL · 1.2 · Administration · PostgreSQL · C · Not packagedpg_orphaned · Deal with orphaned files · 1.0 · Administration · PostgreSQL · C · Packagedpg_query_rewrite · Rewrite SQL statements with a PostgreSQL ProcessUtility hook · 0.0.5 · Administration · PostgreSQL · C · Packagedpg_start_sql · runs SQL statement at instance start · 1.0 · Administration · PostgreSQL · C · Not packagedprioritize · get and set the priority of PostgreSQL backends · 1.0.4 · Administration · PostgreSQL · C · Packagedonline_advisor · Suggest missing indexes and extended statistics online · 1.0 · Administration · PostgreSQL · C · Packagedpg_readonly · cluster database read only · 1.0.6 · Administration · PostgreSQL · C · Packagedpg_quota · Enforce soft per-role disk-space quotas with background workers · 1.0 · Administration · PostgreSQL · C · Not packagedpginstall · PostgreSQL extension installer that hooks CREATE EXTENSION to fetch and install extension archives. · 1.0 · Administration · PostgreSQL · C · Not packagedpg_subtrans_infos · Inspect PostgreSQL subtransaction status, parent XIDs, nesting level, and commit timestamps. · 1.0 · Administration · PostgreSQL · C · Not packagedpg_remote_exec · Executes shell commands from SQL and optionally returns their standard output. · 1.0 · Administration · PostgreSQL · C · Not packagedpg_timeout · PostgreSQL background-worker extension for terminating idle database sessions. · 1.0 · Administration · PostgreSQL · C · Not packagedpg_bman · PostgreSQL hot-backup tooling with remote full/incremental backup and archive-log helpers. · 1.0 · Administration · PostgreSQL · C · Not packagedpg_cgroup · Provides SQL-callable functions to create, configure, and attach processes to Linux cgroups. · 1.0 · Administration · PostgreSQL · C · Not packagedpg_drop_events · logs transaction ids of drop table, drop column, drop materialized view statements · 0.1.0 · Administration · PostgreSQL · SQL · Packagedpg_safer_settings · Functions and mechanisms for handling PostgreSQL settings more safely. · 1.0.0 · Administration · PostgreSQL · SQL · Not packagedpg_bofh · Rejects queries without WHERE clauses using a planner hook loaded via shared_preload_libraries. · 0.0.1 · Administration · PostgreSQL · C · Not packagedpg_fk_indexer · Automatically creates indexes for newly defined foreign-key columns. · 1.0 · Administration · PostgreSQL · C · Not packagedpgelog · Extended logging via pseudo-autonomous transactions · 1.0.2 · Administration · PostgreSQL · SQL · Packagedlogging · Administrative C function to enable or disable logging mode on relations. · 0.1 · Administration · PostgreSQL · C · Not packagedpg_control_priority · Controls scheduling priorities (nice values) of PostgreSQL server processes. · 1.0 · Administration · PostgreSQL · C · Not packagedscrub · Background worker that scans heaps, B-tree indexes, TOAST data, page structure, and checksums for corruption. · 1.0 · Administration · PostgreSQL · C · Not packagedtrunkfingerprint · Computes comparable fingerprints of PostgreSQL database structure and optionally data. · 1.3.0 · Administration · PostgreSQL · SQL · Not packagedefm_extension · SQL interface for EDB Failover Manager cluster management · 1.1 · Administration · PostgreSQL · C · Not packagedpg_lock_pool · Wait on a PostgreSQL advisory lock pool · 0.0.1 · Administration · PostgreSQL · SQL · Not packagedpg_set_level · trigger action for SET statement · 0.0.1 · Administration · PostgreSQL · C · Not packagedpg_toastinspect · Low-level inspection of TOAST chunk identifiers, sizes, and stored values. · 1.0 · Administration · PostgreSQL · C · Not packagedpg_upless · Detect Useless UPDATE · 0.0.3 · Administration · PostgreSQL · SQL · Packagedpgcozy · Pre-warming shared buffers according to previous pg_buffercache snapshots for PostgreSQL. · 1.0 · Administration · PostgreSQL · SQL · Packagedpgxc_dns · PostgreSQL-XC coordinator DNS views and weighting functions for BIND SDB load balancing and failover. · 1.0 · Administration · PostgreSQL · C · Not packagedtable_log · record table modification logs and PITR for table/row · 0.6.4 · Administration · PostgreSQL · C · Packagedtrack_renames · Event-trigger function that forwards PostgreSQL object rename details to a configurable callback. · 0.1 · Administration · PostgreSQL · C · Not packagedvacuum_utils · SQL functions for inspecting VACUUM and ANALYZE thresholds and activity and for invoking table maintenance. · 0.1.0 · Administration · PostgreSQL · SQL · Not packagedextension_drop · Run custom commands when an extension is dropped. · 0.1.1 · Administration · PostgreSQL · SQL · Not packagedforbid_truncate · Preload hook extension that rejects TRUNCATE commands. · 1.0 · Administration · PostgreSQL · C · Not packagedmvtbl · Easily move tables around tablespaces · 0.0.2 · Administration · PostgreSQL · SQL · Not packagedpg_decode_infomask · PostgreSQL 9.6 C functions that decode heap tuple infomask and infomask2 hint bits into queryable fields. · 0.1 · Administration · PostgreSQL · C · Not packagedpg_dropcache · Invalidate PostgreSQL shared_buffers cache for a database or relation · 1.0.0 · Administration · PostgreSQL · C · Not packagedpg_global_catalog · PostgreSQL global catalog · 0.0.1 · Administration · PostgreSQL · C · Not packagedpg_living_assertions · Executable SQL checks with verdict dates and assertion history · 0.4.1 · Administration · PostgreSQL · SQL · Packagedpg_misc_functions · Administrative test functions for backend errors, PANIC, crashes, and failover exercises. · 1.0 · Administration · PostgreSQL · C · Not packagedpg_promise_guard · Catalog-only checks for schema guarantees that are no longer enforced · 0.2.0 · Administration · PostgreSQL · SQL · Not packagedpg_toastutils · TOAST inspection utils for postgres · 1.0 · Administration · PostgreSQL · C · Not packagedpgds · dynamic statistics · 0.0.1 · Administration · PostgreSQL · C · Not packagedplsh_mtb · A PostgreSQL multi-tenant backup controller implemented with PL/SH and an installed Korn shell command. · 1.0 · Administration · PostgreSQL · Shell · Not packagedadminpack · administrative functions for PostgreSQL · 2.1 · Administration · PostgreSQL · C · Packagedamcheck · functions for verifying relation integrity · 1.4 · Administration · PostgreSQL · C · Packagedbasebackup_to_shell · adds a custom basebackup target called shell · - · Administration · PostgreSQL · C · Packagedbasic_archive · an example of an archive module · - · Administration · PostgreSQL · C · Packagedcheck_updates · Trigger functions to allow/deny certain type of table updates · 1.0.1 · Administration · PostgreSQL · SQL · Not packagedlo · Large Object maintenance · 1.1 · Administration · PostgreSQL · C · Packagedold_snapshot · utilities in support of old_snapshot_threshold · 1.0 · Administration · PostgreSQL · C · Packagedpg_prewarm · prewarm relation data · 1.2 · Administration · PostgreSQL · C · Packagedpg_stash_advice · Store plan advice by query ID and automatically apply it during PostgreSQL query planning · 1.0 · Administration · PostgreSQL · C · Not packagedpg_surgery · extension to perform surgery on a damaged relation · 1.0 · Administration · PostgreSQL · C · Packagedpg_walrus · Automatic max_wal_size tuning based on checkpoint activity · 0.1.0 · Administration · PostgreSQL · Rust · Not packagedpgagent · A PostgreSQL job scheduler · 4.2.3 · Administration · PostgreSQL · C · Packagedpgbully · Bully-algorithm leader election among PostgreSQL nodes · 1.0 · Administration · PostgreSQL · C · Not packagedpgdisablelogerror · Disable selected SQLSTATE error codes from PostgreSQL server logging. · 1.0 · Administration · PostgreSQL · C · Packagedpgpool_adm · Administrative functions for pgPool · 4.7.2 · Administration · PostgreSQL · C · Packagedpgpool_recovery · recovery functions for pgpool-II for V4.3 · 4.7.2 · Administration · PostgreSQL · C · Packagedpgpool_regclass · replacement for regclass · 4.7.2 · Administration · PostgreSQL · C · Packagedresetsequence · functions to reset sequences to values contained in tables · 1.0.0 · Administration · PostgreSQL · C · Not packagedtblsize_nolock · Functions to calculate relation size without grabbing AccessShareLock on a target relation. · 1.0.0 · Administration · PostgreSQL · C · Not packaged

74 extensions found. Clear filters

NameVersionDescriptionCategoryLicenseLanguagePG VersionStars
pg_misc_functions 1.0 Administrative test functions for backend errors, PANIC, crashes, and failover exercises. ADMIN PostgreSQL C 1
pg_promise_guard 0.2.0 Catalog-only checks for schema guarantees that are no longer enforced ADMIN PostgreSQL SQL 13–19 1
pg_toastutils 1.0 TOAST inspection utils for postgres ADMIN PostgreSQL C 1
pgds 0.0.1 dynamic statistics ADMIN PostgreSQL C 1
plsh_mtb 1.0 A PostgreSQL multi-tenant backup controller implemented with PL/SH and an installed Korn shell command. ADMIN PostgreSQL Shell 1
adminpack 2.1 administrative functions for PostgreSQL ADMIN PostgreSQL C 14–16
amcheck 1.4 functions for verifying relation integrity ADMIN PostgreSQL C 14–18
basebackup_to_shell - adds a custom basebackup target called shell ADMIN PostgreSQL C 15–18
basic_archive - an example of an archive module ADMIN PostgreSQL C 15–18
check_updates 1.0.1 Trigger functions to allow/deny certain type of table updates ADMIN PostgreSQL SQL
lo 1.1 Large Object maintenance ADMIN PostgreSQL C 14–18
old_snapshot 1.0 utilities in support of old_snapshot_threshold ADMIN PostgreSQL C 14–16
pg_prewarm 1.2 prewarm relation data ADMIN PostgreSQL C 14–18
pg_stash_advice 1.0 Store plan advice by query ID and automatically apply it during PostgreSQL query planning ADMIN PostgreSQL C 19
pg_surgery 1.0 extension to perform surgery on a damaged relation ADMIN PostgreSQL C 14–18
pg_walrus 0.1.0 Automatic max_wal_size tuning based on checkpoint activity ADMIN PostgreSQL Rust 15–18
pgagent 4.2.3 A PostgreSQL job scheduler ADMIN PostgreSQL C 14–18
pgbully 1.0 Bully-algorithm leader election among PostgreSQL nodes ADMIN PostgreSQL C 15–18
pgdisablelogerror 1.0 Disable selected SQLSTATE error codes from PostgreSQL server logging. ADMIN PostgreSQL C 14–18
pgpool_adm 4.7.2 Administrative functions for pgPool ADMIN PostgreSQL C 14–18
pgpool_recovery 4.7.2 recovery functions for pgpool-II for V4.3 ADMIN PostgreSQL C 14–18
pgpool_regclass 4.7.2 replacement for regclass ADMIN PostgreSQL C 14–18
resetsequence 1.0.0 functions to reset sequences to values contained in tables ADMIN PostgreSQL C
tblsize_nolock 1.0.0 Functions to calculate relation size without grabbing AccessShareLock on a target relation. ADMIN PostgreSQL C