The PIG CLI
Postgres Install Genius, the missing extension package manager for PostgreSQL ecosystem
Module: PGEXT
Why Pig?
Why would we need yet another package manager? especially for Postgres extensions?
Module:
Extension List
The complete 404 PostgreSQL Extension List available in Pigsty
Module:
Get Started
Get Started with pig, the PostgreSQL extension manager.
Module:
Prepare rust & pgrx
It is necessary to install rust and pgrx before building Rust extensions.
Module:
Using Extension
How to install, load, create, update, remove PostgreSQL extensions in Pigsty?
Module:
Build & Packaging
Prepare PostgreSQL rpm/deb pacakge building environment, and some packaging hints
Module:
Roadmap
Extension Rodapmap, on our radar, backlogs, defects, changes, and retired list.
Module:
Build PLv8
Build the Javascript procedural language extension PLv8 for PostgreSQL.
Module:
Build PostgresML
There are some extra settings to build PostgresML on EL8 and EL9.
Module:
Category: TIME
TIME: TimescaleDB, Versioning & Temporal Table, Crontab, Async & Background Job Scheduler, …
Module:
Categories:
Get Started
How to use PostgreSQL extension in an out-of-the-box manner with Pigsty!
Module:
RPM List
393 Available PostgreSQL Extension RPM in RHEL & Compatible Distributions
Module:
Category: GIS
GIS: GeoSpatial Data Types, Operators, and Indexes, Hexagonal Indexing, OGR Data FDW, GeoIP & MobilityDB, etc…
Module:
Categories:
Category: RAG
RAG: Vector Database with IVFFLAT, HNSW, DiskANN Indexes, AI & ML in SQL interface, Similarity Funcs, etc…
Module:
Categories:
Build ParadeDB
There are some important ParadeDB extensions that need to be built and packaged.
Module:
DEB List
387 Available PostgreSQL Extensions Deb in Debian / Ubuntu Distributions
Module:
Download Extension
How to download new extension packages to Pigsty’s local software repository?
Module:
Todo List
Which extensions are coming next? and which are not planned?
Module:
Category: FTS
FTS: ElasticSearch Alternative with BM25, 2-gram/3-gram Fuzzy Search, Zhparser & Hunspell Segregation Dicts, etc…
Module:
Categories:
Extension Repo
How to use the pigsty extension repo?
Module:
Category: OLAP
OLAP: DuckDB Integration with FDW & PG Lakehouse, Access Parquet from File/S3, Sharding with Citus/Partman/PlProxy, …
Module:
Categories:
Category: FEAT
FEAT: OpenCypher with AGE, GraphQL, JsonSchema, Hints & Hypo Index, HLL, Rum, IVM, ChemRDKit, and Message Queues,…
Module:
Categories:
Bad Case
Not all extensions are perfect, some have defects, some are not yet supported, here are the noted bad cases.
Module:
Category: LANG
LANG: Develop, Test, Package, and Deliver Stored Procedures written in various PL/Lanaguages: Java, Js, Lua, R, Sh, PRQL, …
Module:
Categories:
Pigsty Command Line
The overview of pig cli tool
Module:
Contrib List
PostgreSQL built-in extension list
Module:
Install Extension
How to install a extension from local repo, or directly from the Internet upstream repo.
Module:
Category: TYPE
TYPE: Dedicate New Data Types Like: prefix, sember, uint, SIUnit, RoaringBitmap, Rational, Sphere, Hash, RRule, and more…
Module:
Categories:
Category: UTIL
UTIL: Utilities such as send http request, perform gzip/zstd compress, send mails, Regex, ICU, encoding, docs, Encryption,…
Module:
Categories:
Load Extension
Some extensions that use hook mechanism must be preloaded and restarted to take effect.
Module:
Category: FUNC
FUNC: Function such as id generator, aggregations, sketches, vector functions, mathematical functions and digest functions…
Module:
Categories:
Build DuckDB FDW
How to build DuckDB FDW extension and its dependencies libduckdb.so
Module:
Build Parquet S3 FDW
Build Parquet S3 FDW extension alone with its deps: libarrow, libparquet, 以及 libaws-cpp
Module:
Category: ADMIN
ADMIN: Utilities for Bloat Control, DirtyRead, BufferInspect, DDL Generate, ChecksumVerify, Permission, Priority, Catalog,…
Module:
Categories:
Repository Administration
How to manage repositories with pig repo subcommand?
Module:
Create Extension
How to use CREATE EXTENSION to actually enable a PostgreSQL extensions.
Module:
Category: STAT
STAT: Observability Catalogs, Monitoring Metrics & Views, Statistics, Query Plans, WaitSampling, SlowLogs, and etc…
Module:
Categories:
Update Extension
How to update an existing extension?
Module:
Category: SEC
SEC: Auditing Logs, Enforce Passwords, Keep Secrets, TDE, SM Algorithm, Login Hooks, Log Erros, Extension White List, …
Module:
Categories:
Pigsty Administration
How to manage pigsty with pig sty subcommand?
Module:
Remove Extension
How to safely remove a PostgreSQL extension from a database cluster?
Module:
Building Infrastructure
How to setup building infrastructure with pig build subcommand?
Module:
Category: FDW
FDW: Wrappers & Multicorn for FDW Development, Access other DBMS: MySQL, Mongo, SQLite, MSSQL, Oracle, HDFS, DB2,…
Module:
Categories:
Category: SIM
SIM: Protocol Simulation & heterogeneous DBMS Compatibility: Oracle, MSSQL, DB2, MySQL, Memcached, and Babelfish!
Module:
Categories:
Changelog
Pigsty extension repository changelog
Module:
Metadata Desc
Available Metadata for PostgreSQL Extensions, and explain each attribute.
Module:
Pre-defined Stacks
How to use the predefined extension stacks in Pigsty?
Module:
Category: ETL
ETL: Logical Replication, Decoding, CDC in protobuf/JSON/Mongo format, Copy & Load & Compare Postgres Databases,…
Module:
Categories:
Compatibility
Linux Distribution compatibility matrix
Module:
timescaledb
Enables scalable inserts and complex queries for time-series data
Module:
Categories:
timescaledb_toolkit
Library of analytical hyperfunctions, time-series pipelining, and other SQL utilities
Module:
Categories:
timeseries
Convenience API for Tembo time series stack
Module:
Categories:
periods
Provide Standard SQL functionality for PERIODs and SYSTEM VERSIONING
Module:
Categories:
temporal_tables
temporal tables
Module:
Categories:
emaj
Enables fine-grained write logging and time travel on subsets of the database.
Module:
Categories:
table_version
PostgreSQL table versioning extension
Module:
Categories:
pg_cron
Job scheduler for PostgreSQL
Module:
Categories:
pg_task
execute any sql command at any specific time at background
Module:
Categories:
pg_later
pg_later: Run queries now and get results later
Module:
Categories:
pg_background
Run SQL queries in the background
Module:
Categories:
postgis
PostGIS geometry and geography spatial types and functions
Module:
Categories:
postgis_topology
PostGIS topology spatial types and functions
Module:
Categories:
postgis_raster
PostGIS raster types and functions
Module:
Categories:
postgis_sfcgal
PostGIS SFCGAL functions
Module:
Categories:
postgis_tiger_geocoder
PostGIS tiger geocoder and reverse geocoder
Module:
Categories:
address_standardizer
Used to parse an address into constituent elements. Generally used to support geocoding address normalization step.
Module:
Categories:
address_standardizer_data_us
Address Standardizer US dataset example
Module:
Categories:
pgrouting
pgRouting Extension
Module:
Categories:
pointcloud
data type for lidar point clouds
Module:
Categories:
pointcloud_postgis
integration for pointcloud LIDAR data and PostGIS geometry data
Module:
Categories:
h3
H3 bindings for PostgreSQL
Module:
Categories:
h3_postgis
H3 PostGIS integration
Module:
Categories:
q3c
q3c sky indexing plugin
Module:
Categories:
ogr_fdw
foreign-data wrapper for GIS data access
Module:
Categories:
geoip
IP-based geolocation query
Module:
Categories:
pg_polyline
Fast Google Encoded Polyline encoding & decoding for postgres
Module:
Categories:
pg_geohash
Handle geohash based functionality for spatial coordinates
Module:
Categories:
mobilitydb
MobilityDB geospatial trajectory data management & analysis platform
Module:
Categories:
earthdistance
calculate great-circle distances on the surface of the Earth
Module:
Categories:
vector
vector data type and ivfflat and hnsw access methods
Module:
Categories:
vchord
Vector database plugin for Postgres, written in Rust
Module:
Categories:
vectorscale
pgvectorscale: Advanced indexing for vector data
Module:
Categories:
vectorize
The simplest way to do vector search on Postgres
Module:
Categories:
pg_similarity
support similarity queries
Module:
Categories:
smlar
Effective similarity search
Module:
Categories:
pg_summarize
Text Summarization using LLMs. Built using pgrx
Module:
Categories:
pg_tiktoken
pg_tictoken: tiktoken tokenizer for use with OpenAI models in postgres
Module:
Categories:
pg4ml
Machine learning framework for PostgreSQL
Module:
Categories:
pgml
PostgresML: Run AL/ML workloads with SQL interface
Module:
Categories:
pg_search
pg_search: Full text search for PostgreSQL using BM25
Module:
Categories:
pgroonga
Use Groonga as index, fast full text search platform for all languages!
Module:
Categories:
pgroonga_database
PGroonga database management module
Module:
Categories:
pg_bigm
create 2-gram (bigram) index for faster full text search.
Module:
Categories:
zhparser
a parser for full-text search of Chinese
Module:
Categories:
pg_bestmatch
Generate BM25 sparse vector inside PostgreSQL
Module:
Categories:
vchord_bm25
A postgresql extension for bm25 ranking algorithm
Module:
Categories:
hunspell_cs_cz
Czech Hunspell Dictionary
Module:
Categories:
hunspell_de_de
German Hunspell Dictionary
Module:
Categories:
hunspell_en_us
en_US Hunspell Dictionary
Module:
Categories:
hunspell_fr
French Hunspell Dictionary
Module:
Categories:
hunspell_ne_np
Nepali Hunspell Dictionary
Module:
Categories:
hunspell_nl_nl
Dutch Hunspell Dictionary
Module:
Categories:
hunspell_nn_no
Norwegian (norsk) Hunspell Dictionary
Module:
Categories:
hunspell_pt_pt
Portuguese Hunspell Dictionary
Module:
Categories:
hunspell_ru_ru
Russian Hunspell Dictionary
Module:
Categories:
hunspell_ru_ru_aot
Russian Hunspell Dictionary (from AOT.ru group)
Module:
Categories:
fuzzystrmatch
determine similarities and distance between strings
Module:
Categories:
pg_trgm
text similarity measurement and index searching based on trigrams
Module:
Categories:
citus
Distributed PostgreSQL as an extension
Module:
Categories:
citus_columnar
Citus columnar storage engine
Module:
Categories:
columnar
Hydra Columnar extension
Module:
Categories:
pg_analytics
Postgres for analytics, powered by DuckDB
Module:
Categories:
pg_duckdb
DuckDB Embedded in Postgres
Module:
Categories:
pg_mooncake
Columnstore Table in Postgres
Module:
Categories:
duckdb_fdw
DuckDB Foreign Data Wrapper
Module:
Categories:
pg_parquet
copy data between Postgres and Parquet
Module:
Categories:
pg_fkpart
Table partitioning by foreign key utility
Module:
Categories:
pg_partman
Extension to manage partitioned tables by time or ID
Module:
Categories:
plproxy
Database partitioning implemented as procedural language
Module:
Categories:
pg_strom
PG-Strom - big-data processing acceleration using GPU and NVME
Module:
Categories:
tablefunc
functions that manipulate whole tables, including crosstab
Module:
Categories:
age
AGE graph database extension
Module:
Categories:
hll
type for storing hyperloglog data
Module:
Categories:
rum
RUM index access method
Module:
Categories:
pg_graphql
pg_graphql: GraphQL support
Module:
Categories:
pg_jsonschema
PostgreSQL extension providing JSON Schema validation
Module:
Categories:
jsquery
data type for jsonb inspection
Module:
Categories:
pg_hint_plan
Give PostgreSQL ability to manually force some decisions in execution plans.
Module:
Categories:
hypopg
Hypothetical indexes for PostgreSQL
Module:
Categories:
index_advisor
Query index advisor
Module:
Categories:
plan_filter
filter statements by their execution plans.
Module:
Categories:
imgsmlr
Image similarity with haar
Module:
Categories:
pg_ivm
incremental view maintenance on PostgreSQL
Module:
Categories:
pg_incremental
Incremental Processing by Crunchy Data
Module:
Categories:
pgmq
A lightweight message queue. Like AWS SQS and RSMQ but on Postgres.
Module:
Categories:
pgq
Generic queue for PostgreSQL
Module:
Categories:
pg_cardano
A suite of Cardano-related tools
Module:
Categories:
rdkit
Cheminformatics functionality for PostgreSQL.
Module:
Categories:
omni
Advanced adapter for Postgres extensions
Module:
Categories:
omni_auth
Basic session management
Module:
Categories:
omni_aws
Amazon Web Services APIs (S3)
Module:
Categories:
omni_containers
Docker container management
Module:
Categories:
omni_credentials
Application credential management
Module:
Categories:
omni_http
Basic HTTP types
Module:
Categories:
omni_httpc
HTTP client
Module:
Categories:
omni_httpd
HTTP server
Module:
Categories:
omni_id
Identity types
Module:
Categories:
omni_json
JSON toolkit
Module:
Categories:
omni_kube
Kubernetes (k8s) integration
Module:
Categories:
omni_ledger
Financial ledger
Module:
Categories:
omni_manifest
Package installation manifests
Module:
Categories:
omni_mimetypes
MIME types
Module:
Categories:
omni_os
Operating system integration
Module:
Categories:
omni_polyfill
Postgres API polyfills
Module:
Categories:
omni_python
First-class Python support
Module:
Categories:
omni_regex
PCRE-compatible regular expressions
Module:
Categories:
omni_rest
REST API toolkit (with PostgREST support)
Module:
Categories:
omni_schema
Advanced schema management tooling
Module:
Categories:
omni_seq
Distributed integer sequences
Module:
Categories:
omni_service
Service management
Module:
Categories:
omni_session
Session management
Module:
Categories:
omni_sql
Programmatic SQL manipulation
Module:
Categories:
omni_test
Testing framework
Module:
Categories:
omni_txn
Transaction management
Module:
Categories:
omni_types
Advanced types
Module:
Categories:
omni_var
Scoped variables
Module:
Categories:
omni_vfs
Virtual File System
Module:
Categories:
omni_vfs_types_v1
Virtual File System types (v1)
Module:
Categories:
omni_web
Common web stack primitives
Module:
Categories:
omni_xml
XML toolkit
Module:
Categories:
omni_yaml
YAML toolkit
Module:
Categories:
bloom
bloom access method - signature file based index
Module:
Categories:
pg_tle
Trusted Language Extensions for PostgreSQL
Module:
Categories:
plv8
PL/JavaScript (v8) trusted procedural language
Module:
Categories:
pllua
Lua as a procedural language
Module:
Categories:
hstore_pllua
Hstore transform for Lua
Module:
Categories:
plluau
Lua as an untrusted procedural language
Module:
Categories:
hstore_plluau
Hstore transform for untrusted Lua
Module:
Categories:
plprql
Use PRQL in PostgreSQL - Pipelined Relational Query Language
Module:
Categories:
pldbgapi
server-side support for debugging PL/pgSQL functions
Module:
Categories:
plpgsql_check
extended check for plpgsql functions
Module:
Categories:
plprofiler
server-side support for profiling PL/pgSQL functions
Module:
Categories:
plsh
PL/sh procedural language
Module:
Categories:
pljava
PL/Java procedural language (https://tada.github.io/pljava/)
Module:
Categories:
plr
load R interpreter and execute R script from within a database
Module:
Categories:
pgtap
Unit testing for PostgreSQL
Module:
Categories:
faker
Wrapper for the Faker Python library
Module:
Categories:
dbt2
OSDL-DBT-2 test kit
Module:
Categories:
pltcl
PL/Tcl procedural language
Module:
Categories:
pltclu
PL/TclU untrusted procedural language
Module:
Categories:
plperl
PL/Perl procedural language
Module:
Categories:
bool_plperl
transform between bool and plperl
Module:
Categories:
hstore_plperl
transform between hstore and plperl
Module:
Categories:
jsonb_plperl
transform between jsonb and plperl
Module:
Categories:
plperlu
PL/PerlU untrusted procedural language
Module:
Categories:
bool_plperlu
transform between bool and plperlu
Module:
Categories:
jsonb_plperlu
transform between jsonb and plperlu
Module:
Categories:
hstore_plperlu
transform between hstore and plperlu
Module:
Categories:
plpgsql
PL/pgSQL procedural language
Module:
Categories:
plpython3u
PL/Python3U untrusted procedural language
Module:
Categories:
jsonb_plpython3u
transform between jsonb and plpython3u
Module:
Categories:
ltree_plpython3u
transform between ltree and plpython3u
Module:
Categories:
hstore_plpython3u
transform between hstore and plpython3u
Module:
Categories:
prefix
Prefix Range module for PostgreSQL
Module:
Categories:
semver
Semantic version data type
Module:
Categories:
unit
SI units extension
Module:
Categories:
pgpdf
PDF type with meta admin & Full-Text Search
Module:
Categories:
pglite_fusion
Embed an SQLite database in your PostgreSQL table
Module:
Categories:
md5hash
type for storing 128-bit binary data inline
Module:
Categories:
asn1oid
asn1oid extension
Module:
Categories:
roaringbitmap
support for Roaring Bitmaps
Module:
Categories:
pgfaceting
fast faceting queries using an inverted index
Module:
Categories:
pg_sphere
spherical objects with useful functions, operators and index support
Module:
Categories:
country
Country data type, ISO 3166-1
Module:
Categories:
pg_xenophile
More than the bare necessities for PostgreSQL i18n and l10n.
Module:
Categories:
currency
Custom PostgreSQL currency type in 1Byte
Module:
Categories:
collection
Memory optimized data type to be used inside of plpglsql func
Module:
Categories:
pgmp
Multiple Precision Arithmetic extension
Module:
Categories:
numeral
numeral datatypes extension
Module:
Categories:
pg_rational
bigint fractions
Module:
Categories:
uint
unsigned integer types
Module:
Categories:
uint128
Native uint128 type
Module:
Categories:
hashtypes
sha1, md5 and other data types for PostgreSQL
Module:
Categories:
ip4r
IPv4/v6 and IPv4/v6 range index type for PostgreSQL
Module:
Categories:
pg_duration
data type for representing durations
Module:
Categories:
uri
URI Data type for PostgreSQL
Module:
Categories:
emailaddr
Email address type for PostgreSQL
Module:
Categories:
acl
ACL Data type
Module:
Categories:
debversion
Debian version number data type
Module:
Categories:
pg_rrule
RRULE field type for PostgreSQL
Module:
Categories:
timestamp9
timestamp nanosecond resolution
Module:
Categories:
chkpass
data type for auto-encrypted passwords
Module:
Categories:
isn
data types for international product numbering standards
Module:
Categories:
seg
data type for representing line segments or floating-point intervals
Module:
Categories:
cube
data type for multidimensional cubes
Module:
Categories:
ltree
data type for hierarchical tree-like structures
Module:
Categories:
hstore
data type for storing sets of (key, value) pairs
Module:
Categories:
citext
data type for case-insensitive character strings
Module:
Categories:
xml2
XPath querying and XSLT
Module:
Categories:
gzip
gzip and gunzip functions.
Module:
Categories:
bzip
Bzip compression and decompression
Module:
Categories:
zstd
Zstandard compression algorithm implementation in PostgreSQL
Module:
Categories:
http
HTTP client for PostgreSQL, allows web page retrieval inside the database.
Module:
Categories:
pg_net
Async HTTP Requests
Module:
Categories:
pg_curl
Run curl actions for data transfer in URL syntax
Module:
Categories:
pgjq
Use jq in Postgres
Module:
Categories:
pgjwt
JSON Web Token API for Postgresql
Module:
Categories:
pg_smtp_client
PostgreSQL extension to send email using SMTP
Module:
Categories:
pg_html5_email_address
PostgreSQL email validation that is consistent with the HTML5 spec
Module:
Categories:
url_encode
url_encode, url_decode functions
Module:
Categories:
pgsql_tweaks
Some functions and views for daily usage
Module:
Categories:
pg_extra_time
Some date time functions and operators that,
Module:
Categories:
pgpcre
Perl Compatible Regular Expression functions
Module:
Categories:
icu_ext
Access ICU functions
Module:
Categories:
pgqr
QR Code generator from PostgreSQL
Module:
Categories:
pg_protobuf
Protobuf support for PostgreSQL
Module:
Categories:
envvar
Fetch the value of an environment variable
Module:
Categories:
floatfile
Simple file storage for arrays of floats
Module:
Categories:
pg_readme
Generate a README.md document for a database extension or schema
Module:
Categories:
ddl_historization
Historize the ddl changes inside PostgreSQL database
Module:
Categories:
data_historization
PLPGSQL Script to historize data in partitionned table
Module:
Categories:
schedoc
Cross documentation between Django and DBT projects
Module:
Categories:
hashlib
Stable hash functions for Postgres
Module:
Categories:
xxhash
xxhash functions for PostgreSQL
Module:
Categories:
shacrypt
Implements SHA256-CRYPT and SHA512-CRYPT password encryption schemes
Module:
Categories:
cryptint
Encryption functions for int and bigint values
Module:
Categories:
pguecc
uECC bindings for Postgres
Module:
Categories:
pg_idkit
multi-tool for generating new/niche universally unique identifiers (ex. UUIDv6, ULID, KSUID)
Module:
Categories:
pg_uuidv7
pg_uuidv7: create UUIDv7 values in postgres
Module:
Categories:
permuteseq
Pseudo-randomly permute sequences with a format-preserving encryption on elements
Module:
Categories:
pg_hashids
Short unique id generator for PostgreSQL, using hashids
Module:
Categories:
sequential_uuids
generator of sequential UUIDs
Module:
Categories:
topn
type for top-n JSONB
Module:
Categories:
quantile
Quantile aggregation function
Module:
Categories:
lower_quantile
Lower quantile aggregate function
Module:
Categories:
count_distinct
An alternative to COUNT(DISTINCT …) aggregate, usable with HashAggregate
Module:
Categories:
omnisketch
data structure for on-line agg of data into approximate sketch
Module:
Categories:
ddsketch
Provides ddsketch aggregate function
Module:
Categories:
vasco
discover hidden correlations in your data with MIC
Module:
Categories:
xicor
XI Correlation Coefficient in Postgres
Module:
Categories:
tdigest
Provides tdigest aggregate function.
Module:
Categories:
first_last_agg
first() and last() aggregate functions
Module:
Categories:
extra_window_functions
Extra Window Functions for PostgreSQL
Module:
Categories:
floatvec
Math for vectors (arrays) of numbers
Module:
Categories:
aggs_for_vecs
Aggregate functions for array inputs
Module:
Categories:
aggs_for_arrays
Various functions for computing statistics on arrays of numbers
Module:
Categories:
arraymath
Array math and operators that work element by element on the contents of arrays
Module:
Categories:
pg_math
GSL statistical functions for postgresql
Module:
Categories:
random
random data generator
Module:
Categories:
base36
Integer Base36 types
Module:
Categories:
base62
Base62 extension for PostgreSQL
Module:
Categories:
pg_base58
Base58 Encoder/Decoder Extension for PostgreSQL
Module:
Categories:
financial
Financial aggregate functions
Module:
Categories:
refint
functions for implementing referential integrity (obsolete)
Module:
Categories:
autoinc
functions for autoincrementing fields
Module:
Categories:
insert_username
functions for tracking who changed a table
Module:
Categories:
moddatetime
functions for tracking last modification time
Module:
Categories:
tsm_system_time
TABLESAMPLE method which accepts time in milliseconds as a limit
Module:
Categories:
dict_xsyn
text search dictionary template for extended synonym processing
Module:
Categories:
tsm_system_rows
TABLESAMPLE method which accepts number of rows as a limit
Module:
Categories:
tcn
Triggered change notifications
Module:
Categories:
uuid-ossp
generate universally unique identifiers (UUIDs)
Module:
Categories:
uuid-ossp
generate universally unique identifiers (UUIDs)
Module:
Categories:
btree_gist
support for indexing common datatypes in GiST
Module:
Categories:
btree_gin
support for indexing common datatypes in GIN
Module:
Categories:
intarray
functions, operators, and index support for 1-D arrays of integers
Module:
Categories:
intagg
integer aggregator and enumerator (obsolete)
Module:
Categories:
dict_int
text search dictionary template for integers
Module:
Categories:
unaccent
text search dictionary that removes accents
Module:
Categories:
pg_repack
Reorganize tables in PostgreSQL databases with minimal locks
Module:
Categories:
pg_squeeze
A tool to remove unused space from a relation.
Module:
Categories:
pg_dirtyread
Read dead but unvacuumed rows from table
Module:
Categories:
pgfincore
examine and manage the os buffer cache
Module:
Categories:
pg_cooldown
remove buffered pages for specific relations
Module:
Categories:
ddlx
DDL eXtractor functions
Module:
Categories:
prioritize
get and set the priority of PostgreSQL backends
Module:
Categories:
pg_checksums
Activate/deactivate/verify checksums in offline Postgres clusters
Module:
Categories:
pg_readonly
cluster database read only
Module:
Categories:
pg_upless
Detect Useless UPDATE
Module:
Categories:
pg_permissions
view object permissions and compare them with the desired state
Module:
Categories:
pgautofailover
pg_auto_failover
Module:
Categories:
pg_catcheck
Diagnosing system catalog corruption
Module:
Categories:
pre_prepare
Pre Prepare your Statement server side
Module:
Categories:
pgcozy
Pre-warming shared buffers according to previous pg_buffercache snapshots for PostgreSQL.
Module:
Categories:
pg_orphaned
Deal with orphaned files
Module:
Categories:
pg_crash
Send random signals to random processes
Module:
Categories:
pg_cheat_funcs
Provides cheat (but useful) functions
Module:
Categories:
fio
PostgreSQL File I/O Functions
Module:
Categories:
pg_savior
Postgres extension to save OOPS mistakes
Module:
Categories:
safeupdate
Require criteria for UPDATE and DELETE
Module:
Categories:
pg_drop_events
logs transaction ids of drop table, drop column, drop materialized view statements
Module:
Categories:
table_log
record table modification logs and PITR for table/row
Module:
Categories:
pgagent
A PostgreSQL job scheduler
Module:
Categories:
pg_prewarm
prewarm relation data
Module:
Categories:
pgpool_adm
Administrative functions for pgPool
Module:
Categories:
pgpool_recovery
recovery functions for pgpool-II for V4.3
Module:
Categories:
lo
Large Object maintenance
Module:
Categories:
pgpool_regclass
replacement for regclass
Module:
Categories:
basic_archive
an example of an archive module
Module:
Categories:
basebackup_to_shell
adds a custom basebackup target called shell
Module:
Categories:
old_snapshot
utilities in support of old_snapshot_threshold
Module:
Categories:
adminpack
administrative functions for PostgreSQL
Module:
Categories:
amcheck
functions for verifying relation integrity
Module:
Categories:
pg_surgery
extension to perform surgery on a damaged relation
Module:
Categories:
pg_profile
PostgreSQL load profile repository and report builder
Module:
Categories:
pg_tracing
Distributed Tracing for PostgreSQL
Module:
Categories:
pg_show_plans
show query plans of all currently running SQL statements
Module:
Categories:
pg_stat_kcache
Kernel statistics gathering
Module:
Categories:
pg_stat_monitor
The pg_stat_monitor is a PostgreSQL Query Performance Monitoring tool, based on PostgreSQL contrib module pg_stat_statements. pg_stat_monitor provides aggregated statistics, client information, plan details including plan, and histogram information.
Module:
Categories:
pg_qualstats
An extension collecting statistics about quals
Module:
Categories:
pg_store_plans
track plan statistics of all SQL statements executed
Module:
Categories:
pg_track_settings
Track settings changes
Module:
Categories:
pg_wait_sampling
sampling based statistics of wait events
Module:
Categories:
system_stats
EnterpriseDB system statistics for PostgreSQL
Module:
Categories:
meta
Normalized, friendlier system catalog for PostgreSQL
Module:
Categories:
pgnodemx
Capture node OS metrics via SQL queries
Module:
Categories:
pg_proctab
PostgreSQL extension to access the OS process table
Module:
Categories:
pg_sqlog
Provide SQL interface to logs
Module:
Categories:
bgw_replstatus
Small PostgreSQL background worker to report whether a node is a replication master or standby
Module:
Categories:
pgmeminfo
show memory usage
Module:
Categories:
toastinfo
show details on toasted datums
Module:
Categories:
explain_ui
easily jump into a visual plan UI for any SQL query
Module:
Categories:
pg_relusage
Log all the queries that reference a particular column
Module:
Categories:
pagevis
Visualise database pages in ascii code
Module:
Categories:
powa
PostgreSQL Workload Analyser-core
Module:
Categories:
pageinspect
inspect the contents of database pages at a low level
Module:
Categories:
pgrowlocks
show row-level locking information
Module:
Categories:
sslinfo
information about SSL certificates
Module:
Categories:
pg_buffercache
examine the shared buffer cache
Module:
Categories:
pg_walinspect
functions to inspect contents of PostgreSQL Write-Ahead Log
Module:
Categories:
pg_freespacemap
examine the free space map (FSM)
Module:
Categories:
pg_visibility
examine the visibility map (VM) and page-level visibility info
Module:
Categories:
pgstattuple
show tuple-level statistics
Module:
Categories:
auto_explain
Provides a means for logging execution plans of slow statements automatically
Module:
Categories:
pg_stat_statements
track planning and execution statistics of all SQL statements executed
Module:
Categories:
passwordcheck_cracklib
Strengthen PostgreSQL user password checks with cracklib
Module:
Categories:
supautils
Extension that secures a cluster on a cloud environment
Module:
Categories:
pgsodium
Postgres extension for libsodium functions
Module:
Categories:
supabase_vault
Supabase Vault Extension
Module:
Categories:
pg_session_jwt
Manage authentication sessions using JWTs
Module:
Categories:
anon
PostgreSQL Anonymizer (anon) extension
Module:
Categories:
pg_tde
pg_tde access method
Module:
Categories:
pgsmcrypto
PostgreSQL SM Algorithm Extension
Module:
Categories:
pgaudit
provides auditing functionality
Module:
Categories:
pgauditlogtofile
pgAudit addon to redirect audit log to an independent file
Module:
Categories:
pg_auth_mon
monitor connection attempts per user
Module:
Categories:
credcheck
credcheck - postgresql plain text credential checker
Module:
Categories:
pgcryptokey
cryptographic key management
Module:
Categories:
pg_jobmon
Extension for logging and monitoring functions in PostgreSQL
Module:
Categories:
logerrors
Function for collecting statistics about messages in logfile
Module:
Categories:
login_hook
login_hook - hook to execute login_hook.login() at login time
Module:
Categories:
set_user
similar to SET ROLE but with added logging
Module:
Categories:
pg_snakeoil
The PostgreSQL Antivirus
Module:
Categories:
pgextwlist
PostgreSQL Extension Whitelisting
Module:
Categories:
pg_auditor
Audit data changes and provide flashback ability
Module:
Categories:
sslutils
A Postgres extension for managing SSL certificates through SQL
Module:
Categories:
noset
Module for blocking SET variables for non-super users.
Module:
Categories:
sepgsql
label-based mandatory access control (MAC) based on SELinux security policy.
Module:
Categories:
auth_delay
pause briefly before reporting authentication failure
Module:
Categories:
pgcrypto
cryptographic functions
Module:
Categories:
passwordcheck
checks user passwords and reject weak password
Module:
Categories:
wrappers
Foreign data wrappers developed by Supabase
Module:
Categories:
multicorn
Fetch foreign data in Python in your PostgreSQL server.
Module:
Categories:
odbc_fdw
Foreign data wrapper for accessing remote databases using ODBC
Module:
Categories:
jdbc_fdw
foreign-data wrapper for remote servers available over JDBC
Module:
Categories:
mysql_fdw
Foreign data wrapper for querying a MySQL server
Module:
Categories:
oracle_fdw
foreign data wrapper for Oracle access
Module:
Categories:
tds_fdw
Foreign data wrapper for querying a TDS database (Sybase or Microsoft SQL Server)
Module:
Categories:
db2_fdw
foreign data wrapper for DB2 access
Module:
Categories:
sqlite_fdw
SQLite Foreign Data Wrapper
Module:
Categories:
pgbouncer_fdw
Extension for querying PgBouncer stats from normal SQL views & running pgbouncer commands from normal SQL functions
Module:
Categories:
mongo_fdw
foreign data wrapper for MongoDB access
Module:
Categories:
redis_fdw
Foreign data wrapper for querying a Redis server
Module:
Categories:
redis
Send redis pub/sub messages to Redis from PostgreSQL Directly
Module:
Categories:
kafka_fdw
kafka Foreign Data Wrapper for CSV formatted messages
Module:
Categories:
hdfs_fdw
foreign-data wrapper for remote hdfs servers
Module:
Categories:
firebird_fdw
Foreign data wrapper for Firebird
Module:
Categories:
aws_s3
aws_s3 postgres extension to import/export data from/to s3
Module:
Categories:
log_fdw
foreign-data wrapper for Postgres log file access
Module:
Categories:
sparql
Query SPARQL datasource with SQL
Module:
Categories:
dblink
connect to other PostgreSQL databases from within a database
Module:
Categories:
file_fdw
foreign-data wrapper for flat file access
Module:
Categories:
postgres_fdw
foreign-data wrapper for remote PostgreSQL servers
Module:
Categories:
documentdb
API surface for DocumentDB for PostgreSQL
Module:
Categories:
documentdb_core
Core API surface for DocumentDB for PostgreSQL
Module:
Categories:
documentdb_distributed
Multi-Node API surface for DocumentDB
Module:
Categories:
orafce
Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS
Module:
Categories:
pgtt
Extension to add Global Temporary Tables feature to PostgreSQL
Module:
Categories:
session_variable
Registration and manipulation of session variables and constants
Module:
Categories:
pg_statement_rollback
Server side rollback at statement level for PostgreSQL like Oracle or DB2
Module:
Categories:
pg_dbms_metadata
Extension to add Oracle DBMS_METADATA compatibility to PostgreSQL
Module:
Categories:
pg_dbms_lock
Extension to add Oracle DBMS_LOCK full compatibility to PostgreSQL
Module:
Categories:
pg_dbms_job
Extension to add Oracle DBMS_JOB full compatibility to PostgreSQL
Module:
Categories:
babelfishpg_common
SQL Server Transact SQL Datatype Support
Module:
Categories:
babelfishpg_tsql
SQL Server Transact SQL compatibility
Module:
Categories:
babelfishpg_tds
SQL Server TDS protocol extension
Module:
Categories:
babelfishpg_money
SQL Server Money Data Type
Module:
Categories:
pgmemcache
memcached interface
Module:
Categories:
pglogical
PostgreSQL Logical Replication
Module:
Categories:
pglogical_origin
Dummy extension for compatibility when upgrading from Postgres 9.4
Module:
Categories:
pglogical_ticker
Have an accurate view on pglogical replication delay
Module:
Categories:
pgl_ddl_deploy
automated ddl deployment using pglogical
Module:
Categories:
pg_failover_slots
PG Failover Slots extension
Module:
Categories:
db_migrator
Tools to migrate other databases to PostgreSQL
Module:
Categories:
wal2json
Changing data capture in JSON format
Module:
Categories:
wal2mongo
PostgreSQL logical decoding output plugin for MongoDB
Module:
Categories:
decoderbufs
Logical decoding plugin that delivers WAL stream changes using a Protocol Buffer format
Module:
Categories:
decoder_raw
Output plugin for logical replication in Raw SQL format
Module:
Categories:
pgoutput
Logical Replication output plugin
Module:
Categories:
test_decoding
SQL-based test/example module for WAL logical decoding
Module:
Categories:
mimeo
Extension for specialized, per-table replication between PostgreSQL instances
Module:
Categories:
repmgr
Replication manager for PostgreSQL
Module:
Categories:
pg_fact_loader
build fact tables with Postgres
Module:
Categories:
pg_bulkload
pg_bulkload is a high speed data loading utility for PostgreSQL