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.

repmgr · Replication manager for PostgreSQL · 5.5.0 · Replication and streams · GPL-3.0 · C · Packagedwal2json · Changing data capture in JSON format · 2.6 · Replication and streams · BSD-3-Clause · C · Packagedpglogical · PostgreSQL Logical Replication · 2.4.8 · Replication and streams · PostgreSQL · C · Packagedpglogical_origin · Dummy extension for compatibility when upgrading from Postgres 9.4 · 2.4.7 · Replication and streams · PostgreSQL · C · Packagedpgactive · Active-Active Replication Extension for PostgreSQL · 2.1.7 · Replication and streams · Apache-2.0 · C · Packagedspock · Multi-master logical replication extension for PostgreSQL · 5.0.10 · Replication and streams · PostgreSQL · C · Packagedpg_bulkload · pg_bulkload is a high speed data loading utility for PostgreSQL · 3.1.23 · Replication and streams · BSD-3-Clause · C · Packageddecoder_raw · Output plugin for logical replication in Raw SQL format · 1.0 · Replication and streams · PostgreSQL · C · Packagedpg_paxos · Paxos distributed consensus functions and table replication for PostgreSQL · 0.2 · Replication and streams · PostgreSQL · C · Not packageddecoderbufs · Logical decoding plugin that delivers WAL stream changes using a Protocol Buffer format · 3.6.0 · Replication and streams · MIT · C · Packagedamqp · Publish messages to AMQP brokers from PostgreSQL · 0.4.2 · Replication and streams · BSD-3-Clause · C · Not packagedkafka · Produce messages to Apache Kafka from PostgreSQL · 0.0.1 · Replication and streams · MIT · C · Not packagedsynchdb · Mixed C/Java PostgreSQL extension for direct CDC replication from MySQL, SQL Server, Oracle, and OpenLog Replicator sources. · 1.0 · Replication and streams · Apache-2.0 · C · Not packagedpg_failover_slots · PG Failover Slots extension · 1.2.1 · Replication and streams · PostgreSQL · C · Packagedpgl_ddl_deploy · automated ddl deployment using pglogical · 2.2.1 · Replication and streams · MIT · C · Packagedpipeline_kafka · Integrate PipelineDB with Kafka for background-worker consumption, production, offsets, and lag monitoring · 1.0.0 · Replication and streams · GPL-3.0 · C · Not packagedpg_tm_aux · Transfer manager auxiliary functions · 1.1.1 · Replication and streams · Unknown · C · Not packagedlolor · Logical-replication-friendly replacement for PostgreSQL large objects · 1.2.2 · Replication and streams · PostgreSQL · C · Packagedpgclone · Clone PostgreSQL databases, schemas, tables, and functions across environments · 4.4.2 · Replication and streams · PostgreSQL · C · Packagedchdb_hook · Headless hook for COPY and CREATE TABLE over chDB-supported URLs · 0.1.1 · Replication and streams · Apache-2.0 · C · Not packagedpg_zlog · Logical table replication using Ceph and ZLog · 0.1 · Replication and streams · Unknown · C · Not packagedwal2mongo · PostgreSQL logical decoding output plugin for MongoDB · 1.0.7 · Replication and streams · Apache-2.0 · C · Packagedpg_migrate · Migrates a PostgreSQL table avoiding long locks · 0.1.1 · Replication and streams · BSD-3-Clause · C · Not packagedpgcmp · Support extension for pg_comparator, providing checksum and cast functions for PostgreSQL data comparison. · 3.1 · Replication and streams · BSD-3-Clause · C · Not packagedlogical_ddl · Replicate supported DDL changes over PostgreSQL logical replication · 0.1.0 · Replication and streams · MIT · C · Packagedpg_fact_loader · build fact tables with Postgres · 2.0.1 · Replication and streams · MIT · C · Packagedpg_fasttransfer · Postgresql Extension for FastTransfer · 1.0 · Replication and streams · MIT · C · Not packagedreplisome · Logical-decoding output plugin and Python consumer framework for streaming PostgreSQL row changes as JSON. · 0.1 · Replication and streams · BSD-3-Clause · C · Not packagedpg_pageprep · Prepares heap pages on PostgreSQL or Postgres Pro Standard for migration to the 64-bit-XID page format used by Postgres Pro Enterprise. · 0.1 · Replication and streams · PostgreSQL · C · Not packagedbwcontrol · Bottledwater control extension · 1.0 · Replication and streams · PostgreSQL · C · Not packagedpg_kafka_events · Publishes PostgreSQL logical-decoding change events to Apache Kafka through a background worker. · 1.0 · Replication and streams · Apache-2.0 · C · Not packagednanomsgtopdb · Receive nanomsg messages into a PipelineDB stream. · 1.0 · Replication and streams · Unknown · C · Not packagedpgcat · Enhanced logical replication extension for per-table subscriptions, table mapping, and replica-identity tracking. · 1.0 · Replication and streams · Apache-2.0 · C · Not packagedpg_redispub · Publish channel messages from PostgreSQL to a local Redis server · 1.0 · Replication and streams · MIT · C · Not packagedpglogical_ticker · Have an accurate view on pglogical replication delay · 1.4.1 · Replication and streams · PostgreSQL · C · Packagedpg_follower · Educational logical-replication extension that captures and applies database changes · 1.0 · Replication and streams · Unknown · C · Not packagedpg_repeater · Replicates utility statements and serialized query plans to a remote PostgreSQL node over postgres_fdw. · 0.1 · Replication and streams · PostgreSQL · C · Not packagedpg_wal_ext · Read WAL files and possibly generate the SQL · 1.0 · Replication and streams · MIT · C · Not packagedsynchronize_logical_slots · Synchronizes logical replication slots from an EDB Advanced Server 12 primary to synchronous standby servers. · 1.0 · Replication and streams · Unknown · C · Not packagedddl_repl · Replicate DDL and DCL commands across PostgreSQL instances by means of a utility hook · 1.0 · Replication and streams · Unknown · C · Not packagedgsheets · Read and write Google Sheets from PostgreSQL. · 0.1.0 · Replication and streams · MIT · C · Not packagedpglogical_output_nzhooks · Example pglogical output-plugin row-filter hook that keeps only changes for a hard-coded relation name · 1.0 · Replication and streams · Unknown · C · Not packagedtcn_json · C trigger function that sends primary-key change notifications through LISTEN/NOTIFY. · 1.1 · Replication and streams · Unknown · C · Not packagedazure_storage · Azure Database for PostgreSQL extension for importing from and exporting to Azure Storage blobs from SQL. · 1.9 · Replication and streams · Unknown · C · Not packagedcopy_data · some small postgresql extensions for beginners · 1.0 · Replication and streams · Unknown · C · Not packagedpg_logical_ddl · Experimental DDL replication implementation for PostgreSQL · 1.0 · Replication and streams · Unknown · C · Not packagedpg_transport · Amazon RDS extension for transportable PostgreSQL database workflows. · 1 · Replication and streams · Unknown · C · Not packagedpgoutput · Logical Replication output plugin · - · Replication and streams · PostgreSQL · C · Packagedputpostlogic · Unreleased logical decoding output-plugin prototype that emits JSON changes through PostgreSQL, Kafka, or Nanomsg. · 0.1.0 · Replication and streams · Unknown · C · Not packagedrds_hwdrs_ddl · Huawei Cloud RDS incremental DDL synchronization helper extension · 1 · Replication and streams · Unknown · C · Not packagedrds_online_ddl · Alibaba Cloud RDS online column type migration extension · 1.0 · Replication and streams · Unknown · C · Not packagedrds_online_migrate · Alibaba Cloud RDS online table partitioning extension · 1.0 · Replication and streams · Unknown · C · Not packagedtencentdb_failover_slot · TencentDB proprietary kernel extension that synchronizes logical replication-slot state to standby nodes so subscriptions can continue across primary/standby failover. · 1.0 · Replication and streams · Unknown · C · Not packagedtest_decoding · SQL-based test/example module for WAL logical decoding · - · Replication and streams · PostgreSQL · C · Packaged

54 extensions found. Clear filters

NameVersionDescriptionCategoryLicenseLanguagePG VersionStars
repmgr 5.5.0 Replication manager for PostgreSQL ETL GPL-3.0 C 14–18 1.7k
wal2json 2.6 Changing data capture in JSON format ETL BSD-3-Clause C 14–18 1.5k
pglogical 2.4.8 PostgreSQL Logical Replication ETL PostgreSQL C 14–18 1.2k
pglogical_origin 2.4.7 Dummy extension for compatibility when upgrading from Postgres 9.4 ETL PostgreSQL C 14–18 1.2k
pgactive 2.1.7 Active-Active Replication Extension for PostgreSQL ETL Apache-2.0 C 14–18 1.1k
spock 5.0.10 Multi-master logical replication extension for PostgreSQL ETL PostgreSQL C 15–18 744
pg_bulkload 3.1.23 pg_bulkload is a high speed data loading utility for PostgreSQL ETL BSD-3-Clause C 14–18 496
decoder_raw 1.0 Output plugin for logical replication in Raw SQL format ETL PostgreSQL C 14–18 349
pg_paxos 0.2 Paxos distributed consensus functions and table replication for PostgreSQL ETL PostgreSQL C 309
decoderbufs 3.6.0 Logical decoding plugin that delivers WAL stream changes using a Protocol Buffer format ETL MIT C 14–18 260
amqp 0.4.2 Publish messages to AMQP brokers from PostgreSQL ETL BSD-3-Clause C 10–18 214
kafka 0.0.1 Produce messages to Apache Kafka from PostgreSQL ETL MIT C 10–18 112
synchdb 1.0 Mixed C/Java PostgreSQL extension for direct CDC replication from MySQL, SQL Server, Oracle, and OpenLog Replicator sources. ETL Apache-2.0 C 16–18 111
pg_failover_slots 1.2.1 PG Failover Slots extension ETL PostgreSQL C 14–18 106
pgl_ddl_deploy 2.2.1 automated ddl deployment using pglogical ETL MIT C 14–18 99
pipeline_kafka 1.0.0 Integrate PipelineDB with Kafka for background-worker consumption, production, offsets, and lag monitoring ETL GPL-3.0 C 62
pg_tm_aux 1.1.1 Transfer manager auxiliary functions ETL C 50
lolor 1.2.2 Logical-replication-friendly replacement for PostgreSQL large objects ETL PostgreSQL C 15–18 48
pgclone 4.4.2 Clone PostgreSQL databases, schemas, tables, and functions across environments ETL PostgreSQL C 14–18 44
chdb_hook 0.1.1 Headless hook for COPY and CREATE TABLE over chDB-supported URLs ETL Apache-2.0 C 15–19 20
pg_zlog 0.1 Logical table replication using Ceph and ZLog ETL C 19
wal2mongo 1.0.7 PostgreSQL logical decoding output plugin for MongoDB ETL Apache-2.0 C 14–18 18
pg_migrate 0.1.1 Migrates a PostgreSQL table avoiding long locks ETL BSD-3-Clause C 16
pgcmp 3.1 Support extension for pg_comparator, providing checksum and cast functions for PostgreSQL data comparison. ETL BSD-3-Clause C 12
logical_ddl 0.1.0 Replicate supported DDL changes over PostgreSQL logical replication ETL MIT C 14–18 11
pg_fact_loader 2.0.1 build fact tables with Postgres ETL MIT C 14–18 11
pg_fasttransfer 1.0 Postgresql Extension for FastTransfer ETL MIT C 15–18 10
replisome 0.1 Logical-decoding output plugin and Python consumer framework for streaming PostgreSQL row changes as JSON. ETL BSD-3-Clause C 9
pg_pageprep 0.1 Prepares heap pages on PostgreSQL or Postgres Pro Standard for migration to the 64-bit-XID page format used by Postgres Pro Enterprise. ETL PostgreSQL C 10–11 8
bwcontrol 1.0 Bottledwater control extension ETL PostgreSQL C 10–18 7
pg_kafka_events 1.0 Publishes PostgreSQL logical-decoding change events to Apache Kafka through a background worker. ETL Apache-2.0 C 7
nanomsgtopdb 1.0 Receive nanomsg messages into a PipelineDB stream. ETL C 6
pgcat 1.0 Enhanced logical replication extension for per-table subscriptions, table mapping, and replica-identity tracking. ETL Apache-2.0 C 11–18 5
pg_redispub 1.0 Publish channel messages from PostgreSQL to a local Redis server ETL MIT C 4
pglogical_ticker 1.4.1 Have an accurate view on pglogical replication delay ETL PostgreSQL C 14–18 3
pg_follower 1.0 Educational logical-replication extension that captures and applies database changes ETL C 2
pg_repeater 0.1 Replicates utility statements and serialized query plans to a remote PostgreSQL node over postgres_fdw. ETL PostgreSQL C 2
pg_wal_ext 1.0 Read WAL files and possibly generate the SQL ETL MIT C 2
synchronize_logical_slots 1.0 Synchronizes logical replication slots from an EDB Advanced Server 12 primary to synchronous standby servers. ETL C 12 2
ddl_repl 1.0 Replicate DDL and DCL commands across PostgreSQL instances by means of a utility hook ETL C 1
gsheets 0.1.0 Read and write Google Sheets from PostgreSQL. ETL MIT C 1
pglogical_output_nzhooks 1.0 Example pglogical output-plugin row-filter hook that keeps only changes for a hard-coded relation name ETL C 1
tcn_json 1.1 C trigger function that sends primary-key change notifications through LISTEN/NOTIFY. ETL C 1
azure_storage 1.9 Azure Database for PostgreSQL extension for importing from and exporting to Azure Storage blobs from SQL. ETL C 12–18
copy_data 1.0 some small postgresql extensions for beginners ETL C
pg_logical_ddl 1.0 Experimental DDL replication implementation for PostgreSQL ETL C
pg_transport 1 Amazon RDS extension for transportable PostgreSQL database workflows. ETL C 10–18
pgoutput - Logical Replication output plugin ETL PostgreSQL C 14–18
putpostlogic 0.1.0 Unreleased logical decoding output-plugin prototype that emits JSON changes through PostgreSQL, Kafka, or Nanomsg. ETL C
rds_hwdrs_ddl 1 Huawei Cloud RDS incremental DDL synchronization helper extension ETL C 13–17