db2_fdw

db2_fdw

foreign data wrapper for DB2 access

Overview

IDExtensionPackageVersionCategoryLicenseLanguage
8630
db2_fdw
db2_fdw
7.0.0
FDW
PostgreSQL
C
AttributeHas BinaryHas LibraryNeed LoadHas DDLRelocatableTrusted
--s-d--
No
Yes
No
Yes
no
no
Relationships
See Also
odbc_fdw
mysql_fdw
oracle_fdw
tds_fdw
wrappers
multicorn
jdbc_fdw
postgres_fdw

Packages

TypeRepoVersionPG Major AvailabilityPackage PatternDependencies
EL
PGDG
7.0.0
18
17
16
15
14
13
db2_fdw_$v*-
Linux / PGPG18PG17PG16PG15PG14PG13
el8.x86_64
MISS
PGDG 7.0.0
PGDG 7.0.0
PGDG 7.0.0
PGDG 7.0.0
PGDG 7.0.0
el8.aarch64
MISS
MISS
MISS
MISS
MISS
MISS
el9.x86_64
MISS
PGDG 7.0.0
PGDG 7.0.0
PGDG 7.0.0
PGDG 7.0.0
PGDG 7.0.0
el9.aarch64
MISS
MISS
MISS
MISS
MISS
MISS
el10.x86_64
MISS
PGDG 7.0.0
PGDG 7.0.0
PGDG 7.0.0
PGDG 7.0.0
MISS
el10.aarch64
MISS
MISS
MISS
MISS
MISS
MISS
d12.x86_64
MISS
MISS
MISS
MISS
MISS
MISS
d12.aarch64
MISS
MISS
MISS
MISS
MISS
MISS
d13.x86_64
MISS
MISS
MISS
MISS
MISS
MISS
d13.aarch64
MISS
MISS
MISS
MISS
MISS
MISS
u22.x86_64
MISS
MISS
MISS
MISS
MISS
MISS
u22.aarch64
MISS
MISS
MISS
MISS
MISS
MISS
u24.x86_64
MISS
MISS
MISS
MISS
MISS
MISS
u24.aarch64
MISS
MISS
MISS
MISS
MISS
MISS
PackageVersionOSORGSIZEFile URL
db2_fdw_177.0.0el8.x86_64pgdg59.6 KiBdb2_fdw_17-7.0.0-1PGDG.rhel8.x86_64.rpm
db2_fdw_177.0.0el9.x86_64pgdg56.6 KiBdb2_fdw_17-7.0.0-1PGDG.rhel9.x86_64.rpm
db2_fdw_177.0.0el10.x86_64pgdg57.8 KiBdb2_fdw_17-7.0.0-1PGDG.rhel10.x86_64.rpm
PackageVersionOSORGSIZEFile URL
db2_fdw_167.0.0el8.x86_64pgdg59.6 KiBdb2_fdw_16-7.0.0-1PGDG.rhel8.x86_64.rpm
db2_fdw_166.0.1el8.x86_64pgdg59.4 KiBdb2_fdw_16-6.0.1-1PGDG.rhel8.x86_64.rpm
db2_fdw_167.0.0el9.x86_64pgdg56.6 KiBdb2_fdw_16-7.0.0-1PGDG.rhel9.x86_64.rpm
db2_fdw_166.0.1el9.x86_64pgdg58.0 KiBdb2_fdw_16-6.0.1-1PGDG.rhel9.x86_64.rpm
db2_fdw_167.0.0el10.x86_64pgdg57.9 KiBdb2_fdw_16-7.0.0-1PGDG.rhel10.x86_64.rpm
PackageVersionOSORGSIZEFile URL
db2_fdw_157.0.0el8.x86_64pgdg60.7 KiBdb2_fdw_15-7.0.0-1PGDG.rhel8.x86_64.rpm
db2_fdw_156.0.1el8.x86_64pgdg60.4 KiBdb2_fdw_15-6.0.1-1PGDG.rhel8.x86_64.rpm
db2_fdw_157.0.0el9.x86_64pgdg60.2 KiBdb2_fdw_15-7.0.0-1PGDG.rhel9.x86_64.rpm
db2_fdw_156.0.1el9.x86_64pgdg62.4 KiBdb2_fdw_15-6.0.1-1PGDG.rhel9.x86_64.rpm
db2_fdw_157.0.0el10.x86_64pgdg60.9 KiBdb2_fdw_15-7.0.0-1PGDG.rhel10.x86_64.rpm
PackageVersionOSORGSIZEFile URL
db2_fdw_147.0.0el8.x86_64pgdg60.8 KiBdb2_fdw_14-7.0.0-1PGDG.rhel8.x86_64.rpm
db2_fdw_146.0.1el8.x86_64pgdg60.6 KiBdb2_fdw_14-6.0.1-1PGDG.rhel8.x86_64.rpm
db2_fdw_145.0.0el8.x86_64pgdg357.6 KiBdb2_fdw_14-5.0.0-1.rhel8.x86_64.rpm
db2_fdw_147.0.0el9.x86_64pgdg60.2 KiBdb2_fdw_14-7.0.0-1PGDG.rhel9.x86_64.rpm
db2_fdw_146.0.1el9.x86_64pgdg62.5 KiBdb2_fdw_14-6.0.1-1PGDG.rhel9.x86_64.rpm
db2_fdw_145.0.0el9.x86_64pgdg364.1 KiBdb2_fdw_14-5.0.0-1.rhel9.x86_64.rpm
db2_fdw_147.0.0el10.x86_64pgdg61.0 KiBdb2_fdw_14-7.0.0-1PGDG.rhel10.x86_64.rpm
PackageVersionOSORGSIZEFile URL
db2_fdw_137.0.0el8.x86_64pgdg60.5 KiBdb2_fdw_13-7.0.0-1PGDG.rhel8.x86_64.rpm
db2_fdw_136.0.1el8.x86_64pgdg60.3 KiBdb2_fdw_13-6.0.1-1PGDG.rhel8.x86_64.rpm
db2_fdw_135.0.0el8.x86_64pgdg355.2 KiBdb2_fdw_13-5.0.0-1.rhel8.x86_64.rpm
db2_fdw_137.0.0el9.x86_64pgdg60.4 KiBdb2_fdw_13-7.0.0-1PGDG.rhel9.x86_64.rpm
db2_fdw_136.0.1el9.x86_64pgdg62.5 KiBdb2_fdw_13-6.0.1-1PGDG.rhel9.x86_64.rpm
db2_fdw_135.0.0el9.x86_64pgdg362.2 KiBdb2_fdw_13-5.0.0-1.rhel9.x86_64.rpm
db2_fdw_134.0.0el9.x86_64pgdg362.2 KiBdb2_fdw_13-4.0.0-2.rhel9.x86_64.rpm

Source

pig build get db2_fdw; # get db2_fdw source code
pig build dep db2_fdw; # install build dependencies
pig build pkg db2_fdw; # build extension rpm or deb
pig build ext db2_fdw; # build extension rpms

Install

To add the required PGDG / PIGSTY upstream repository, use:

pig repo add pgsql -u   # add PGDG + Pigsty repo and update cache (leave existing repos)

Install this extension with:

pig ext install db2_fdw; # install by extension name, for the current active PG version
pig ext install db2_fdw; # install via package alias, for the active PG version
pig ext install db2_fdw -v 16;   # install for PG 16
pig ext install db2_fdw -v 15;   # install for PG 15
pig ext install db2_fdw -v 14;   # install for PG 14
pig ext install db2_fdw -v 13;   # install for PG 13

Create this extension with:

CREATE EXTENSION db2_fdw;
Last updated on