This is the multi-page printable view of this section.
Click here to print.
Return to the regular view of this page.
Category: FDW
FDW: Wrappers & Multicorn for FDW Development, Access other DBMS: MySQL, Mongo, SQLite, MSSQL, Oracle, HDFS, DB2,…
FDW category has 21 available extensions:
1 - wrappers
Foreign data wrappers developed by Supabase
Overview
PIGSTY 3rd Party Extension: wrappers : Foreign data wrappers developed by Supabase
- Latest Version: 0.4.4
- Postgres Support:
17,16,15,14
- 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:
wrappers_$v
- RPM Ver :
0.4.4
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-wrappers
- DEB Ver :
0.4.4
- DEB Deps: N/A
Packages
Installation
Install wrappers via the pig CLI tool:
Install wrappers via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["wrappers"]}' # -l <cls>
Install wrappers RPM from YUM repo directly:
dnf install wrappers_17;
dnf install wrappers_16;
dnf install wrappers_15;
dnf install wrappers_14;
Install wrappers DEB from APT repo directly:
apt install postgresql-17-wrappers;
apt install postgresql-16-wrappers;
apt install postgresql-15-wrappers;
apt install postgresql-14-wrappers;
Enable wrappers extension on PostgreSQL cluster：
CREATE EXTENSION wrappers;
2 - multicorn
Fetch foreign data in Python in your PostgreSQL server.
Overview
PGDG 1st Party Extension: multicorn : Fetch foreign data in Python in your PostgreSQL server.
- Latest Version: 3.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: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PGDG
- RPM Name:
multicorn2_$v*
- RPM Ver :
3.0
- RPM Deps: N/A
- DEB Repo: None
- DEB Name:
N/A
- DEB Ver : N/A
- DEB Deps: N/A
Packages
Installation
Install multicorn via the pig CLI tool:
pig ext install multicorn
Install multicorn via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["multicorn"]}' # -l <cls>
Install multicorn RPM from YUM repo directly:
dnf install multicorn2_17*;
dnf install multicorn2_16*;
dnf install multicorn2_15*;
dnf install multicorn2_14*;
dnf install multicorn2_13*;
Enable multicorn extension on PostgreSQL cluster：
CREATE EXTENSION multicorn;
3 - odbc_fdw
Foreign data wrapper for accessing remote databases using ODBC
Overview
PGDG 1st Party Extension: odbc_fdw : Foreign data wrapper for accessing remote databases using ODBC
- Latest Version: 0.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 not install to arbitrary schema
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PGDG
- RPM Name:
odbc_fdw_$v*
- RPM Ver :
0.5.1
- RPM Deps:
unixODBC
- DEB Repo: None
- DEB Name:
N/A
- DEB Ver : N/A
- DEB Deps: N/A
Packages
Installation
Install odbc_fdw via the pig CLI tool:
Install odbc_fdw via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["odbc_fdw"]}' # -l <cls>
Install odbc_fdw RPM from YUM repo directly:
dnf install odbc_fdw_17*;
dnf install odbc_fdw_16*;
dnf install odbc_fdw_15*;
dnf install odbc_fdw_14*;
dnf install odbc_fdw_13*;
Enable odbc_fdw extension on PostgreSQL cluster：
CREATE EXTENSION odbc_fdw;
4 - jdbc_fdw
foreign-data wrapper for remote servers available over JDBC
Overview
PGDG 1st Party Extension: jdbc_fdw : foreign-data wrapper for remote servers available over JDBC
- Latest Version: 1.2
- Postgres Support:
16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Can not install to arbitrary schema
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PGDG
- RPM Name:
jdbc_fdw_$v*
- RPM Ver :
1.2
- RPM Deps:
java-11-openjdk-headless
- DEB Repo: None
- DEB Name:
N/A
- DEB Ver : N/A
- DEB Deps: N/A
Packages
Installation
Install jdbc_fdw via the pig CLI tool:
Install jdbc_fdw via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["jdbc_fdw"]}' # -l <cls>
Install jdbc_fdw RPM from YUM repo directly:
dnf install jdbc_fdw_16*;
dnf install jdbc_fdw_15*;
dnf install jdbc_fdw_14*;
dnf install jdbc_fdw_13*;
Enable jdbc_fdw extension on PostgreSQL cluster：
CREATE EXTENSION jdbc_fdw;
5 - mysql_fdw
Foreign data wrapper for querying a MySQL server
Overview
PGDG 1st Party Extension: mysql_fdw : Foreign data wrapper for querying a MySQL server
- Latest Version: 1.2
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Can not install to arbitrary schema
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PGDG
- RPM Name:
mysql_fdw_$v*
- RPM Ver :
1.2
- RPM Deps: N/A
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-mysql-fdw
- DEB Ver :
1.2
- DEB Deps: N/A
Packages
Installation
Install mysql_fdw via the pig CLI tool:
pig ext install mysql_fdw
Install mysql_fdw via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["mysql_fdw"]}' # -l <cls>
Install mysql_fdw RPM from YUM repo directly:
dnf install mysql_fdw_17*;
dnf install mysql_fdw_16*;
dnf install mysql_fdw_15*;
dnf install mysql_fdw_14*;
dnf install mysql_fdw_13*;
Install mysql_fdw DEB from APT repo directly:
apt install postgresql-17-mysql-fdw;
apt install postgresql-16-mysql-fdw;
apt install postgresql-15-mysql-fdw;
apt install postgresql-14-mysql-fdw;
apt install postgresql-13-mysql-fdw;
Enable mysql_fdw extension on PostgreSQL cluster：
CREATE EXTENSION mysql_fdw;
6 - oracle_fdw
foreign data wrapper for Oracle access
Overview
PGDG 1st Party Extension: oracle_fdw : foreign data wrapper for Oracle access
- Latest Version: 1.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: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PGDG
- RPM Name:
oracle_fdw_$v*
- RPM Ver :
1.2
- RPM Deps: N/A
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-oracle-fdw
- DEB Ver :
1.2
- DEB Deps: N/A
Packages
Installation
Install oracle_fdw via the pig CLI tool:
pig ext install oracle_fdw
Install oracle_fdw via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["oracle_fdw"]}' # -l <cls>
Install oracle_fdw RPM from YUM repo directly:
dnf install oracle_fdw_17*;
dnf install oracle_fdw_16*;
dnf install oracle_fdw_15*;
dnf install oracle_fdw_14*;
dnf install oracle_fdw_13*;
Install oracle_fdw DEB from APT repo directly:
apt install postgresql-17-oracle-fdw;
apt install postgresql-16-oracle-fdw;
apt install postgresql-15-oracle-fdw;
apt install postgresql-14-oracle-fdw;
apt install postgresql-13-oracle-fdw;
Enable oracle_fdw extension on PostgreSQL cluster：
CREATE EXTENSION oracle_fdw;
7 - tds_fdw
Foreign data wrapper for querying a TDS database (Sybase or Microsoft SQL Server)
Overview
PGDG 1st Party Extension: tds_fdw : Foreign data wrapper for querying a TDS database (Sybase or Microsoft SQL Server)
- Latest Version: 2.0.4
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Can not install to arbitrary schema
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PGDG
- RPM Name:
tds_fdw_$v*
- RPM Ver :
2.0.4
- RPM Deps: N/A
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-tds-fdw
- DEB Ver :
2.0.4
- DEB Deps: N/A
Packages
Installation
Install tds_fdw via the pig CLI tool:
Install tds_fdw via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["tds_fdw"]}' # -l <cls>
Install tds_fdw RPM from YUM repo directly:
dnf install tds_fdw_17*;
dnf install tds_fdw_16*;
dnf install tds_fdw_15*;
dnf install tds_fdw_14*;
dnf install tds_fdw_13*;
Install tds_fdw DEB from APT repo directly:
apt install postgresql-17-tds-fdw;
apt install postgresql-16-tds-fdw;
apt install postgresql-15-tds-fdw;
apt install postgresql-14-tds-fdw;
apt install postgresql-13-tds-fdw;
Enable tds_fdw extension on PostgreSQL cluster：
CREATE EXTENSION tds_fdw;
8 - db2_fdw
foreign data wrapper for DB2 access
Overview
PGDG 1st Party Extension: db2_fdw : foreign data wrapper for DB2 access
- Latest Version: 6.0.1
- Postgres Support:
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: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PGDG
- RPM Name:
db2_fdw_$v*
- RPM Ver :
6.0.1
- RPM Deps: N/A
- DEB Repo: None
- DEB Name:
N/A
- DEB Ver : N/A
- DEB Deps: N/A
Packages
Installation
Install db2_fdw via the pig CLI tool:
Install db2_fdw via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["db2_fdw"]}' # -l <cls>
Install db2_fdw RPM from YUM repo directly:
dnf install db2_fdw_16*;
dnf install db2_fdw_15*;
dnf install db2_fdw_14*;
dnf install db2_fdw_13*;
Enable db2_fdw extension on PostgreSQL cluster：
CREATE EXTENSION db2_fdw;
9 - sqlite_fdw
SQLite Foreign Data Wrapper
Overview
PGDG 1st Party Extension: sqlite_fdw : SQLite Foreign Data Wrapper
- Latest Version: 1.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 not install to arbitrary schema
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PGDG
- RPM Name:
sqlite_fdw_$v*
- RPM Ver :
1.1
- RPM Deps: N/A
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-sqlite-fdw
- DEB Ver :
2.4.0
- DEB Deps: N/A
Packages
Installation
Install sqlite_fdw via the pig CLI tool:
pig ext install sqlite_fdw
Install sqlite_fdw via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["sqlite_fdw"]}' # -l <cls>
Install sqlite_fdw RPM from YUM repo directly:
dnf install sqlite_fdw_17*;
dnf install sqlite_fdw_16*;
dnf install sqlite_fdw_15*;
dnf install sqlite_fdw_14*;
dnf install sqlite_fdw_13*;
Install sqlite_fdw DEB from APT repo directly:
apt install postgresql-16-sqlite-fdw;
apt install postgresql-15-sqlite-fdw;
apt install postgresql-14-sqlite-fdw;
apt install postgresql-13-sqlite-fdw;
Enable sqlite_fdw extension on PostgreSQL cluster：
CREATE EXTENSION sqlite_fdw;
10 - pgbouncer_fdw
Extension for querying PgBouncer stats from normal SQL views & running pgbouncer commands from normal SQL functions
Overview
PGDG 1st Party Extension: pgbouncer_fdw : Extension for querying PgBouncer stats from normal SQL views & running pgbouncer commands from normal SQL functions
- Latest Version: 1.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: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PGDG
- RPM Name:
pgbouncer_fdw_$v
- RPM Ver :
1.2.0
- RPM Deps: N/A
- DEB Repo: None
- DEB Name:
N/A
- DEB Ver : N/A
- DEB Deps: N/A
Packages
Installation
Install pgbouncer_fdw via the pig CLI tool:
pig ext install pgbouncer_fdw
Install pgbouncer_fdw via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pgbouncer_fdw"]}' # -l <cls>
Install pgbouncer_fdw RPM from YUM repo directly:
dnf install pgbouncer_fdw_17;
dnf install pgbouncer_fdw_16;
dnf install pgbouncer_fdw_15;
dnf install pgbouncer_fdw_14;
dnf install pgbouncer_fdw_13;
Enable pgbouncer_fdw extension on PostgreSQL cluster：
CREATE EXTENSION pgbouncer_fdw;
11 - mongo_fdw
foreign data wrapper for MongoDB access
Overview
PGDG 1st Party Extension: mongo_fdw : foreign data wrapper for MongoDB access
- Latest Version: 1.1
- Postgres Support:
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: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PGDG
- RPM Name:
mongo_fdw_$v*
- RPM Ver :
1.1
- RPM Deps: N/A
- DEB Repo: None
- DEB Name:
N/A
- DEB Ver : N/A
- DEB Deps: N/A
Packages
Installation
Install mongo_fdw via the pig CLI tool:
pig ext install mongo_fdw
Install mongo_fdw via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["mongo_fdw"]}' # -l <cls>
Install mongo_fdw RPM from YUM repo directly:
dnf install mongo_fdw_16*;
dnf install mongo_fdw_15*;
dnf install mongo_fdw_14*;
dnf install mongo_fdw_13*;
Enable mongo_fdw extension on PostgreSQL cluster：
CREATE EXTENSION mongo_fdw;
12 - redis_fdw
Foreign data wrapper for querying a Redis server
Overview
PIGSTY 3rd Party Extension: redis_fdw : Foreign data wrapper for querying a Redis server
- Latest Version: 1.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: Unknown
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PIGSTY
- RPM Name:
redis_fdw_$v*
- RPM Ver :
1.0
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-redis-fdw
- DEB Ver :
1.0
- DEB Deps: N/A
Packages
Installation
Install redis_fdw via the pig CLI tool:
pig ext install redis_fdw
Install redis_fdw via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["redis_fdw"]}' # -l <cls>
Install redis_fdw RPM from YUM repo directly:
dnf install redis_fdw_17*;
dnf install redis_fdw_16*;
dnf install redis_fdw_15*;
dnf install redis_fdw_14*;
dnf install redis_fdw_13*;
Install redis_fdw DEB from APT repo directly:
apt install postgresql-17-redis-fdw;
apt install postgresql-16-redis-fdw;
apt install postgresql-15-redis-fdw;
apt install postgresql-14-redis-fdw;
apt install postgresql-13-redis-fdw;
Enable redis_fdw extension on PostgreSQL cluster：
CREATE EXTENSION redis_fdw;
13 - redis
Send redis pub/sub messages to Redis from PostgreSQL Directly
Overview
PIGSTY 3rd Party Extension: pg_redis_pubsub : Send redis pub/sub messages to Redis from PostgreSQL Directly
- Latest Version: 0.0.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 not install to arbitrary schema
- Trusted: Unknown
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PIGSTY
- RPM Name:
pg_redis_pubsub_$v*
- RPM Ver :
0.0.1
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-pg-redis-pubsub
- DEB Ver :
0.0.1
- DEB Deps: N/A
Packages
Installation
Install redis via the pig CLI tool:
pig ext install pg_redis_pubsub; # Extension Namepig ext install redis; # normalized package name
Install pg_redis_pubsub via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_redis_pubsub"]}' # -l <cls>
Install pg_redis_pubsub RPM from YUM repo directly:
dnf install pg_redis_pubsub_17*;
dnf install pg_redis_pubsub_16*;
dnf install pg_redis_pubsub_15*;
dnf install pg_redis_pubsub_14*;
dnf install pg_redis_pubsub_13*;
Install pg_redis_pubsub DEB from APT repo directly:
apt install postgresql-17-pg-redis-pubsub;
apt install postgresql-16-pg-redis-pubsub;
apt install postgresql-15-pg-redis-pubsub;
apt install postgresql-14-pg-redis-pubsub;
apt install postgresql-13-pg-redis-pubsub;
Enable redis extension on PostgreSQL cluster：
14 - kafka_fdw
kafka Foreign Data Wrapper for CSV formatted messages
Overview
PIGSTY 3rd Party Extension: kafka_fdw : kafka Foreign Data Wrapper for CSV formatted messages
- Latest Version: 0.0.3
- Postgres Support:
16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Can not install to arbitrary schema
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PIGSTY
- RPM Name:
kafka_fdw_$v
- RPM Ver :
0.0.3
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-kafka-fdw
- DEB Ver :
0.0.3
- DEB Deps: N/A
Packages
Installation
Install kafka_fdw via the pig CLI tool:
pig ext install kafka_fdw
Install kafka_fdw via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["kafka_fdw"]}' # -l <cls>
Install kafka_fdw RPM from YUM repo directly:
dnf install kafka_fdw_16;
dnf install kafka_fdw_15;
dnf install kafka_fdw_14;
dnf install kafka_fdw_13;
Install kafka_fdw DEB from APT repo directly:
apt install postgresql-16-kafka-fdw;
apt install postgresql-15-kafka-fdw;
apt install postgresql-14-kafka-fdw;
apt install postgresql-13-kafka-fdw;
Enable kafka_fdw extension on PostgreSQL cluster：
CREATE EXTENSION kafka_fdw;
15 - hdfs_fdw
foreign-data wrapper for remote hdfs servers
Overview
PGDG 1st Party Extension: hdfs_fdw : foreign-data wrapper for remote hdfs servers
- Latest Version: 2.0.5
- 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: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PGDG
- RPM Name:
hdfs_fdw_$v*
- RPM Ver :
2.0.5
- RPM Deps: N/A
- DEB Repo: None
- DEB Name:
N/A
- DEB Ver : N/A
- DEB Deps: N/A
Packages
Installation
Install hdfs_fdw via the pig CLI tool:
Install hdfs_fdw via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["hdfs_fdw"]}' # -l <cls>
Install hdfs_fdw RPM from YUM repo directly:
dnf install hdfs_fdw_17*;
dnf install hdfs_fdw_16*;
dnf install hdfs_fdw_15*;
dnf install hdfs_fdw_14*;
dnf install hdfs_fdw_13*;
Enable hdfs_fdw extension on PostgreSQL cluster：
CREATE EXTENSION hdfs_fdw;
16 - firebird_fdw
Foreign data wrapper for Firebird
Overview
PIGSTY 3rd Party Extension: firebird_fdw : Foreign data wrapper for Firebird
- Latest Version: 1.4.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 not install to arbitrary schema
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PIGSTY
- RPM Name:
firebird_fdw_$v
- RPM Ver :
1.4.0
- RPM Deps:
libfq
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-firebird-fdw
- DEB Ver :
1.4.0
- DEB Deps:
libfq
Packages
Installation
Install firebird_fdw via the pig CLI tool:
pig ext install firebird_fdw
Install firebird_fdw via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["firebird_fdw"]}' # -l <cls>
Install firebird_fdw RPM from YUM repo directly:
dnf install firebird_fdw_17;
dnf install firebird_fdw_16;
dnf install firebird_fdw_15;
dnf install firebird_fdw_14;
dnf install firebird_fdw_13;
Install firebird_fdw DEB from APT repo directly:
apt install postgresql-17-firebird-fdw;
apt install postgresql-16-firebird-fdw;
apt install postgresql-15-firebird-fdw;
apt install postgresql-14-firebird-fdw;
apt install postgresql-13-firebird-fdw;
Enable firebird_fdw extension on PostgreSQL cluster：
CREATE EXTENSION firebird_fdw;
17 - aws_s3
aws_s3 postgres extension to import/export data from/to s3
Overview
PIGSTY 3rd Party Extension: aws_s3 : aws_s3 postgres extension to import/export data from/to s3
- Latest Version: 0.0.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 not install to arbitrary schema
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PIGSTY
- RPM Name:
aws_s3_$v
- RPM Ver :
0.0.1
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-aws-s3
- DEB Ver :
0.0.1
- DEB Deps: N/A
Packages
Installation
Install aws_s3 via the pig CLI tool:
Install aws_s3 via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["aws_s3"]}' # -l <cls>
Install aws_s3 RPM from YUM repo directly:
dnf install aws_s3_17;
dnf install aws_s3_16;
dnf install aws_s3_15;
dnf install aws_s3_14;
dnf install aws_s3_13;
Install aws_s3 DEB from APT repo directly:
apt install postgresql-17-aws-s3;
apt install postgresql-16-aws-s3;
apt install postgresql-15-aws-s3;
apt install postgresql-14-aws-s3;
apt install postgresql-13-aws-s3;
Enable aws_s3 extension on PostgreSQL cluster：
18 - log_fdw
foreign-data wrapper for Postgres log file access
Overview
PIGSTY 3rd Party Extension: log_fdw : foreign-data wrapper for Postgres log file access
- Latest Version: 1.4
- Postgres Support:
17,16,15,14
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Unknown
- Trusted: Unknown
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PIGSTY
- RPM Name:
log_fdw_$v*
- RPM Ver :
1.4
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-log-fdw
- DEB Ver :
1.4
- DEB Deps: N/A
Packages
Installation
Install log_fdw via the pig CLI tool:
Install log_fdw via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["log_fdw"]}' # -l <cls>
Install log_fdw RPM from YUM repo directly:
dnf install log_fdw_17*;
dnf install log_fdw_16*;
dnf install log_fdw_15*;
dnf install log_fdw_14*;
Install log_fdw DEB from APT repo directly:
apt install postgresql-17-log-fdw;
apt install postgresql-16-log-fdw;
apt install postgresql-15-log-fdw;
apt install postgresql-14-log-fdw;
Enable log_fdw extension on PostgreSQL cluster：
CREATE EXTENSION log_fdw;
19 - dblink
connect to other PostgreSQL databases from within a database
Overview
CONTRIB Built-in Extension: dblink : connect to other PostgreSQL databases from within a database
- Latest Version: 1.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: 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 dblink is PostgreSQL Built-in Contrib Extension which is installed along with the kernel/contrib.
Install dblink 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 dblink 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;
Enable dblink extension on PostgreSQL cluster：
20 - file_fdw
foreign-data wrapper for flat file access
Overview
CONTRIB Built-in Extension: file_fdw : foreign-data wrapper for flat file access
- Latest Version: 1.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: 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 file_fdw is PostgreSQL Built-in Contrib Extension which is installed along with the kernel/contrib.
Install file_fdw 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 file_fdw 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;
Enable file_fdw extension on PostgreSQL cluster：
CREATE EXTENSION file_fdw;
21 - postgres_fdw
foreign-data wrapper for remote PostgreSQL servers
Overview
CONTRIB Built-in Extension: postgres_fdw : foreign-data wrapper for remote PostgreSQL servers
- Latest Version: 1.1
- 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: 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 postgres_fdw is PostgreSQL Built-in Contrib Extension which is installed along with the kernel/contrib.
Install postgres_fdw 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 postgres_fdw 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;
Enable postgres_fdw extension on PostgreSQL cluster：
CREATE EXTENSION postgres_fdw;