This is the multi-page printable view of this section.
Click here to print.
Return to the regular view of this page.
Category: ETL
ETL: Logical Replication, Decoding, CDC in protobuf/JSON/Mongo format, Copy & Load & Compare Postgres Databases,…
ETL category has 16 available extensions:
1 - pglogical
PostgreSQL Logical Replication
Overview
PGDG 1st Party Extension: pglogical : PostgreSQL Logical Replication
- Latest Version: 2.4.5
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Can be installed into other schemas
- Trusted: Untrusted, Require Superuser to Create
- Schemas:
pglogical
- Requires: N/A
RPM / DEB
- RPM Repo: PGDG
- RPM Name:
pglogical_$v*
- RPM Ver :
2.4.5
- RPM Deps: N/A
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-pglogical
- DEB Ver :
2.4.5
- DEB Deps: N/A
Packages
Installation
Install pglogical via the pig CLI tool:
pig ext install pglogical
Install pglogical via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pglogical"]}' # -l <cls>
Install pglogical RPM from YUM repo directly:
dnf install pglogical_17*;
dnf install pglogical_16*;
dnf install pglogical_15*;
dnf install pglogical_14*;
dnf install pglogical_13*;
Install pglogical DEB from APT repo directly:
apt install postgresql-17-pglogical;
apt install postgresql-16-pglogical;
apt install postgresql-15-pglogical;
apt install postgresql-14-pglogical;
apt install postgresql-13-pglogical;
Enable pglogical extension on PostgreSQL cluster：
CREATE EXTENSION pglogical;
2 - pglogical_origin
Dummy extension for compatibility when upgrading from Postgres 9.4
Overview
PGDG 1st Party Extension: pglogical : Dummy extension for compatibility when upgrading from Postgres 9.4
- Latest Version: 1.0.0
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Can be installed into other schemas
- Trusted: Untrusted, Require Superuser to Create
- Schemas:
pglogical_origin
- Requires: N/A
RPM / DEB
- RPM Repo: PGDG
- RPM Name:
pglogical_$v*
- RPM Ver :
1.0.0
- RPM Deps: N/A
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-pglogical
- DEB Ver :
1.0.0
- DEB Deps: N/A
Packages
Installation
Install pglogical_origin via the pig CLI tool:
pig ext install pglogical; # Extension Namepig ext install pglogical_origin; # normalized package name
Install pglogical via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pglogical"]}' # -l <cls>
Install pglogical RPM from YUM repo directly:
dnf install pglogical_17*;
dnf install pglogical_16*;
dnf install pglogical_15*;
dnf install pglogical_14*;
dnf install pglogical_13*;
Install pglogical DEB from APT repo directly:
apt install postgresql-17-pglogical;
apt install postgresql-16-pglogical;
apt install postgresql-15-pglogical;
apt install postgresql-14-pglogical;
apt install postgresql-13-pglogical;
Enable pglogical_origin extension on PostgreSQL cluster：
CREATE EXTENSION pglogical_origin;
3 - pglogical_ticker
Have an accurate view on pglogical replication delay
Overview
PGDG 3rd Party Extension: pglogical_ticker : Have an accurate view on pglogical replication delay
- Latest Version: 1.4
- Postgres Support:
17,16,15,14,13
- Need Load: Explicit Loading Required
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Can be installed into other schemas
- Trusted: Untrusted, Require Superuser to Create
- Schemas:
pglogical_ticker
- Requires:
pglogical
RPM / DEB
- RPM Repo: PIGSTY
- RPM Name:
pglogical_ticker_$v*
- RPM Ver :
1.4
- RPM Deps:
pglogical_$v
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-pglogical-ticker
- DEB Ver :
1.4
- DEB Deps:
postgresql-$v-pglogical
Packages
Installation
Install pglogical_ticker via the pig CLI tool:
pig ext install pglogical_ticker
Install pglogical_ticker via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pglogical_ticker"]}' # -l <cls>
Install pglogical_ticker RPM from YUM repo directly:
dnf install pglogical_ticker_17*;
dnf install pglogical_ticker_16*;
dnf install pglogical_ticker_15*;
dnf install pglogical_ticker_14*;
dnf install pglogical_ticker_13*;
Install pglogical_ticker DEB from APT repo directly:
apt install postgresql-17-pglogical-ticker;
apt install postgresql-16-pglogical-ticker;
apt install postgresql-15-pglogical-ticker;
apt install postgresql-14-pglogical-ticker;
apt install postgresql-13-pglogical-ticker;
Extension pglogical_ticker has to be added to shared_preload_libraries
shared_preload_libraries = 'pglogical_ticker'; # add to pg cluster config
Enable pglogical_ticker extension on PostgreSQL cluster：
CREATE EXTENSION pglogical_ticker CASCADE;
4 - pgl_ddl_deploy
automated ddl deployment using pglogical
Overview
PGDG 1st Party Extension: pgl_ddl_deploy : automated ddl deployment using pglogical
- Latest Version: 2.2
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Unknown
- Trusted: Untrusted, Require Superuser to Create
- Schemas:
pgl_ddl_deploy
- Requires:
pglogical
RPM / DEB
- RPM Repo: PGDG
- RPM Name:
pgl_ddl_deploy_$v*
- RPM Ver :
2.2
- RPM Deps:
pglogical_$v
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-pgl-ddl-deploy
- DEB Ver :
2.2
- DEB Deps:
postgresql-$v-pglogical
Packages
Installation
Install pgl_ddl_deploy via the pig CLI tool:
pig ext install pgl_ddl_deploy
Install pgl_ddl_deploy via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pgl_ddl_deploy"]}' # -l <cls>
Install pgl_ddl_deploy RPM from YUM repo directly:
dnf install pgl_ddl_deploy_17*;
dnf install pgl_ddl_deploy_16*;
dnf install pgl_ddl_deploy_15*;
dnf install pgl_ddl_deploy_14*;
dnf install pgl_ddl_deploy_13*;
Install pgl_ddl_deploy DEB from APT repo directly:
apt install postgresql-17-pgl-ddl-deploy;
apt install postgresql-16-pgl-ddl-deploy;
apt install postgresql-15-pgl-ddl-deploy;
apt install postgresql-14-pgl-ddl-deploy;
apt install postgresql-13-pgl-ddl-deploy;
Enable pgl_ddl_deploy extension on PostgreSQL cluster：
CREATE EXTENSION pgl_ddl_deploy CASCADE;
5 - pg_failover_slots
PG Failover Slots extension
Overview
PIGSTY 3rd Party Extension: pg_failover_slots : PG Failover Slots extension
- Latest Version: 1.0.1
- Postgres Support:
17,16,15,14,13
- Need Load: Explicit Loading Required
- Need DDL: Dd not need
CREATE EXTENSION DDL
- Relocatable: Can not install to arbitrary schema
- Trusted: Unknown
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PIGSTY
- RPM Name:
pg_failover_slots_$v*
- RPM Ver :
1.0.1
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-pg-failover-slots
- DEB Ver :
1.0.1
- DEB Deps: N/A
Packages
Installation
Install pg_failover_slots via the pig CLI tool:
pig ext install pg_failover_slots
Install pg_failover_slots via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_failover_slots"]}' # -l <cls>
Install pg_failover_slots RPM from YUM repo directly:
dnf install pg_failover_slots_17*;
dnf install pg_failover_slots_16*;
dnf install pg_failover_slots_15*;
dnf install pg_failover_slots_14*;
dnf install pg_failover_slots_13*;
Install pg_failover_slots DEB from APT repo directly:
apt install postgresql-17-pg-failover-slots;
apt install postgresql-16-pg-failover-slots;
apt install postgresql-15-pg-failover-slots;
apt install postgresql-14-pg-failover-slots;
apt install postgresql-13-pg-failover-slots;
Extension pg_failover_slots has to be added to shared_preload_libraries
shared_preload_libraries = 'pg_failover_slots'; # add to pg cluster config
Extension %s does not need CREATE EXTENSION command
6 - db_migrator
Tools to migrate other databases to PostgreSQL
Overview
PIGSTY 3rd Party Extension: db_migrator : Tools to migrate other databases to PostgreSQL
- Latest Version: 1.0.0
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Can be installed into other schemas
- Trusted: Trusted, Can be created by user with
CREATE Privilege
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PIGSTY
- RPM Name:
db_migrator_$v
- RPM Ver :
1.0.0
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-db-migrator
- DEB Ver :
1.0.0
- DEB Deps: N/A
Packages
Installation
Install db_migrator via the pig CLI tool:
pig ext install db_migrator
Install db_migrator via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["db_migrator"]}' # -l <cls>
Install db_migrator RPM from YUM repo directly:
dnf install db_migrator_17;
dnf install db_migrator_16;
dnf install db_migrator_15;
dnf install db_migrator_14;
dnf install db_migrator_13;
Install db_migrator DEB from APT repo directly:
apt install postgresql-17-db-migrator;
apt install postgresql-16-db-migrator;
apt install postgresql-15-db-migrator;
apt install postgresql-14-db-migrator;
apt install postgresql-13-db-migrator;
Enable db_migrator extension on PostgreSQL cluster：
CREATE EXTENSION db_migrator;
7 - wal2json
Changing data capture in JSON format
Overview
PGDG 1st Party Extension: wal2json : Changing data capture in JSON format
- Latest Version: 2.5.3
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Dd not need
CREATE EXTENSION DDL
- Relocatable: Unknown
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PGDG
- RPM Name:
wal2json_$v*
- RPM Ver :
2.5.3
- RPM Deps: N/A
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-wal2json
- DEB Ver :
2.5.3
- DEB Deps: N/A
Packages
Installation
Install wal2json via the pig CLI tool:
Install wal2json via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["wal2json"]}' # -l <cls>
Install wal2json RPM from YUM repo directly:
dnf install wal2json_17*;
dnf install wal2json_16*;
dnf install wal2json_15*;
dnf install wal2json_14*;
dnf install wal2json_13*;
Install wal2json DEB from APT repo directly:
apt install postgresql-17-wal2json;
apt install postgresql-16-wal2json;
apt install postgresql-15-wal2json;
apt install postgresql-14-wal2json;
apt install postgresql-13-wal2json;
Extension %s does not need CREATE EXTENSION command
8 - wal2mongo
PostgreSQL logical decoding output plugin for MongoDB
Overview
PIGSTY 3rd Party Extension: wal2mongo : PostgreSQL logical decoding output plugin for MongoDB
- Latest Version: 1.0.7
- Postgres Support:
16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Dd not need
CREATE EXTENSION DDL
- Relocatable: Unknown
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PIGSTY
- RPM Name:
wal2mongo_$v*
- RPM Ver :
1.0.7
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-wal2mongo
- DEB Ver :
1.0.7
- DEB Deps: N/A
Packages
Installation
Install wal2mongo via the pig CLI tool:
pig ext install wal2mongo
Install wal2mongo via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["wal2mongo"]}' # -l <cls>
Install wal2mongo RPM from YUM repo directly:
dnf install wal2mongo_16*;
dnf install wal2mongo_15*;
dnf install wal2mongo_14*;
dnf install wal2mongo_13*;
Install wal2mongo DEB from APT repo directly:
apt install postgresql-16-wal2mongo;
apt install postgresql-15-wal2mongo;
apt install postgresql-14-wal2mongo;
apt install postgresql-13-wal2mongo;
Extension %s does not need CREATE EXTENSION command
9 - decoderbufs
Logical decoding plugin that delivers WAL stream changes using a Protocol Buffer format
Overview
PGDG 1st Party Extension: decoderbufs : Logical decoding plugin that delivers WAL stream changes using a Protocol Buffer format
- Latest Version: 0.1.0
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Dd not need
CREATE EXTENSION DDL
- Relocatable: Unknown
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PGDG
- RPM Name:
postgres-decoderbufs_$v*
- RPM Ver :
0.1.0
- RPM Deps: N/A
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-decoderbufs
- DEB Ver :
0.1.0
- DEB Deps: N/A
Packages
Installation
Install decoderbufs via the pig CLI tool:
pig ext install decoderbufs
Install decoderbufs via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["decoderbufs"]}' # -l <cls>
Install decoderbufs RPM from YUM repo directly:
dnf install postgres-decoderbufs_17*;
dnf install postgres-decoderbufs_16*;
dnf install postgres-decoderbufs_15*;
dnf install postgres-decoderbufs_14*;
dnf install postgres-decoderbufs_13*;
Install decoderbufs DEB from APT repo directly:
apt install postgresql-17-decoderbufs;
apt install postgresql-16-decoderbufs;
apt install postgresql-15-decoderbufs;
apt install postgresql-14-decoderbufs;
apt install postgresql-13-decoderbufs;
Extension %s does not need CREATE EXTENSION command
10 - decoder_raw
Output plugin for logical replication in Raw SQL format
Overview
PIGSTY 3rd Party Extension: decoder_raw : Output plugin for logical replication in Raw SQL format
- Latest Version: 1.0
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Dd not need
CREATE EXTENSION DDL
- Relocatable: Can be installed into other schemas
- Trusted: Unknown
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PIGSTY
- RPM Name:
decoder_raw_$v*
- RPM Ver :
1.0
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-decoder-raw
- DEB Ver :
1.0
- DEB Deps: N/A
Packages
Installation
Install decoder_raw via the pig CLI tool:
pig ext install decoder_raw
Install decoder_raw via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["decoder_raw"]}' # -l <cls>
Install decoder_raw RPM from YUM repo directly:
dnf install decoder_raw_17*;
dnf install decoder_raw_16*;
dnf install decoder_raw_15*;
dnf install decoder_raw_14*;
dnf install decoder_raw_13*;
Install decoder_raw DEB from APT repo directly:
apt install postgresql-17-decoder-raw;
apt install postgresql-16-decoder-raw;
apt install postgresql-15-decoder-raw;
apt install postgresql-14-decoder-raw;
apt install postgresql-13-decoder-raw;
Extension %s does not need CREATE EXTENSION command
11 - pgoutput
Logical Replication output plugin
Overview
CONTRIB Built-in Extension: pgoutput : Logical Replication output plugin
- Latest Version: -
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Dd not need
CREATE EXTENSION DDL
- Relocatable: Can be installed into other schemas
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
PostgreSQL Built-in Contrib Extension
Packages
| OS |
Arch |
PG17 |
PG16 |
PG15 |
PG14 |
PG13 |
el8 |
x86_64 |
|
|
|
|
|
el8 |
aarch64 |
|
|
|
|
|
el9 |
x86_64 |
|
|
|
|
|
el9 |
aarch64 |
|
|
|
|
|
d12 |
x86_64 |
|
|
|
|
|
d12 |
aarch64 |
|
|
|
|
|
u22 |
x86_64 |
|
|
|
|
|
u22 |
aarch64 |
|
|
|
|
|
u24 |
x86_64 |
|
|
|
|
|
u24 |
aarch64 |
|
|
|
|
|
Installation
Extension pgoutput is PostgreSQL Built-in Contrib Extension which is installed along with the kernel/contrib.
Install pgoutput RPM from YUM repo directly:
dnf install postgresql17-contrib;
dnf install postgresql16-contrib;
dnf install postgresql15-contrib;
dnf install postgresql14-contrib;
dnf install postgresql13-contrib;
Install pgoutput DEB from APT repo directly:
apt install postgresql-17;
apt install postgresql-16;
apt install postgresql-15;
apt install postgresql-14;
apt install postgresql-13;
Extension %s does not need CREATE EXTENSION command
12 - test_decoding
SQL-based test/example module for WAL logical decoding
Overview
CONTRIB Built-in Extension: test_decoding : SQL-based test/example module for WAL logical decoding
- Latest Version: -
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Dd not need
CREATE EXTENSION DDL
- Relocatable: Unknown
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
PostgreSQL Built-in Contrib Extension
Packages
| OS |
Arch |
PG17 |
PG16 |
PG15 |
PG14 |
PG13 |
el8 |
x86_64 |
|
|
|
|
|
el8 |
aarch64 |
|
|
|
|
|
el9 |
x86_64 |
|
|
|
|
|
el9 |
aarch64 |
|
|
|
|
|
d12 |
x86_64 |
|
|
|
|
|
d12 |
aarch64 |
|
|
|
|
|
u22 |
x86_64 |
|
|
|
|
|
u22 |
aarch64 |
|
|
|
|
|
u24 |
x86_64 |
|
|
|
|
|
u24 |
aarch64 |
|
|
|
|
|
Installation
Extension test_decoding is PostgreSQL Built-in Contrib Extension which is installed along with the kernel/contrib.
Install test_decoding RPM from YUM repo directly:
dnf install postgresql17-contrib;
dnf install postgresql16-contrib;
dnf install postgresql15-contrib;
dnf install postgresql14-contrib;
dnf install postgresql13-contrib;
Install test_decoding DEB from APT repo directly:
apt install postgresql-17;
apt install postgresql-16;
apt install postgresql-15;
apt install postgresql-14;
apt install postgresql-13;
Extension %s does not need CREATE EXTENSION command
13 - mimeo
Extension for specialized, per-table replication between PostgreSQL instances
Overview
MIXED 3rd Party Extension: mimeo : Extension for specialized, per-table replication between PostgreSQL instances
- Latest Version: 1.5.1
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Can be installed into other schemas
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires:
dblink
RPM / DEB
- RPM Repo: PIGSTY
- RPM Name:
mimeo_$v
- RPM Ver :
1.5.1
- RPM Deps: N/A
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-mimeo
- DEB Ver :
1.5.1
- DEB Deps: N/A
Packages
Installation
Install mimeo via the pig CLI tool:
Install mimeo via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["mimeo"]}' # -l <cls>
Install mimeo RPM from YUM repo directly:
dnf install mimeo_17;
dnf install mimeo_16;
dnf install mimeo_15;
dnf install mimeo_14;
dnf install mimeo_13;
Install mimeo DEB from APT repo directly:
apt install postgresql-17-mimeo;
apt install postgresql-16-mimeo;
apt install postgresql-15-mimeo;
apt install postgresql-14-mimeo;
apt install postgresql-13-mimeo;
Enable mimeo extension on PostgreSQL cluster：
CREATE EXTENSION mimeo CASCADE;
14 - repmgr
Replication manager for PostgreSQL
Overview
PGDG 1st Party Extension: repmgr : Replication manager for PostgreSQL
- Latest Version: 5.5
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Can be installed into other schemas
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PGDG
- RPM Name:
repmgr_$v*
- RPM Ver :
5.5
- RPM Deps: N/A
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-repmgr
- DEB Ver :
5.5
- DEB Deps: N/A
Packages
Installation
Install repmgr via the pig CLI tool:
Install repmgr via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["repmgr"]}' # -l <cls>
Install repmgr RPM from YUM repo directly:
dnf install repmgr_16*;
dnf install repmgr_15*;
dnf install repmgr_14*;
dnf install repmgr_13*;
Install repmgr DEB from APT repo directly:
apt install postgresql-17-repmgr;
apt install postgresql-16-repmgr;
apt install postgresql-15-repmgr;
apt install postgresql-14-repmgr;
apt install postgresql-13-repmgr;
Enable repmgr extension on PostgreSQL cluster：
15 - pg_fact_loader
build fact tables with Postgres
Overview
PGDG 1st Party Extension: pg_fact_loader : build fact tables with Postgres
- Latest Version: 2.0
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Unknown
- Trusted: Untrusted, Require Superuser to Create
- Schemas:
fact_loader
- Requires: N/A
RPM / DEB
- RPM Repo: PGDG
- RPM Name:
pg_fact_loader_$v*
- RPM Ver :
2.0
- RPM Deps: N/A
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-pg-fact-loader
- DEB Ver :
2.0
- DEB Deps: N/A
Packages
Installation
Install pg_fact_loader via the pig CLI tool:
pig ext install pg_fact_loader
Install pg_fact_loader via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_fact_loader"]}' # -l <cls>
Install pg_fact_loader RPM from YUM repo directly:
dnf install pg_fact_loader_17*;
dnf install pg_fact_loader_16*;
dnf install pg_fact_loader_15*;
dnf install pg_fact_loader_14*;
dnf install pg_fact_loader_13*;
Install pg_fact_loader DEB from APT repo directly:
apt install postgresql-17-pg-fact-loader;
apt install postgresql-16-pg-fact-loader;
apt install postgresql-15-pg-fact-loader;
apt install postgresql-14-pg-fact-loader;
apt install postgresql-13-pg-fact-loader;
Enable pg_fact_loader extension on PostgreSQL cluster：
CREATE EXTENSION pg_fact_loader;
16 - pg_bulkload
pg_bulkload is a high speed data loading utility for PostgreSQL
Overview
PIGSTY 3rd Party Extension: pg_bulkload : pg_bulkload is a high speed data loading utility for PostgreSQL
- Latest Version: 3.1.22
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Can be installed into other schemas
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PGDG
- RPM Name:
pg_bulkload_$v*
- RPM Ver :
3.1.22
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-pg-bulkload
- DEB Ver :
3.1.22
- DEB Deps: N/A
Packages
Installation
Install pg_bulkload via the pig CLI tool:
pig ext install pg_bulkload
Install pg_bulkload via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_bulkload"]}' # -l <cls>
Install pg_bulkload RPM from YUM repo directly:
dnf install pg_bulkload_17*;
dnf install pg_bulkload_16*;
dnf install pg_bulkload_15*;
dnf install pg_bulkload_14*;
dnf install pg_bulkload_13*;
Install pg_bulkload DEB from APT repo directly:
apt install postgresql-17-pg-bulkload;
apt install postgresql-16-pg-bulkload;
apt install postgresql-15-pg-bulkload;
apt install postgresql-14-pg-bulkload;
apt install postgresql-13-pg-bulkload;
Enable pg_bulkload extension on PostgreSQL cluster：
CREATE EXTENSION pg_bulkload;