Thread: Oracle FDW and Postgres yum repository (CentOS 7)

Hello,

according to the Postgres website.

   https://yum.postgresql.org/news-packagelist.php

oracle_fdw should be available from the Postgres yum repository. 

However, my CentOS 7 test server can't find that package: 

"yum repolist" confirms I have both the Postgres 10 and Postgres 11 repositories installed:

    [root@centos01 ~]# yum repolist
    Loaded plugins: fastestmirror
    Loading mirror speeds from cached hostfile
     * base: centos.schlundtech.de
     * epel: mirror.netweaver.uk
     * extras: centos.mirror.net-d-sign.de
     * updates: centos.mirror.iphh.net
    repo id                                        repo name                                       
    base/7/x86_64                                  CentOS-7 - Base                                 
    epel/x86_64                                    Extra Packages for Enterprise Linux 7 - x86_64  
    extras/7/x86_64                                CentOS-7 - Extras                               
    pgdg10/7/x86_64                                PostgreSQL 10 7 - x86_64                        
    pgdg11/7/x86_64                                PostgreSQL 11 7 - x86_64                        
    pipelinedb_pipelinedb/x86_64                   pipelinedb_pipelinedb                           
    pipelinedb_pipelinedb-source                   pipelinedb_pipelinedb-source                    
    updates/7/x86_64                               CentOS-7 - Updates                              

However, yum doesn't see an oracle_fdw package:

    [root@centos01 ~]# yum list available | grep fdw
    cstore_fdw_10.x86_64                      1.6.2-1.rhel7        pgdg10
    cstore_fdw_10-debuginfo.x86_64            1.6.2-1.rhel7        pgdg10
    cstore_fdw_11.x86_64                      1.6.2-1.rhel7.1      pgdg11
    cstore_fdw_11-debuginfo.x86_64            1.6.2-1.rhel7.1      pgdg11
    hdfs_fdw_10.x86_64                        2.0.4-1.rhel7        pgdg10
    hdfs_fdw_10-debuginfo.x86_64              2.0.4-1.rhel7        pgdg10
    hdfs_fdw_11.x86_64                        2.0.4-1.rhel7        pgdg11
    hdfs_fdw_11-debuginfo.x86_64              2.0.4-1.rhel7        pgdg11
    mailchimp_fdw.x86_64                      0.3.1-2.rhel7.1      pgdg11
    mongo_fdw10.x86_64                        5.2.0-1.rhel7        pgdg10
    mongo_fdw10-debuginfo.x86_64              5.2.0-1.rhel7        pgdg10
    mysql_fdw_10.x86_64                       2.5.0-1.rhel7        pgdg10
    mysql_fdw_10-debuginfo.x86_64             2.5.0-1.rhel7        pgdg10
    mysql_fdw_11.x86_64                       2.5.0-1.rhel7        pgdg11
    mysql_fdw_11-debuginfo.x86_64             2.5.0-1.rhel7        pgdg11
    ogr_fdw10.x86_64                          1.0.7-1.rhel7        pgdg10
    ogr_fdw10-debuginfo.x86_64                1.0.7-1.rhel7        pgdg10
    ogr_fdw11.x86_64                          1.0.7-1.rhel7        pgdg11
    ogr_fdw11-debuginfo.x86_64                1.0.7-1.rhel7        pgdg11
    osm_fdw10.x86_64                          3.0.0-1.f30          pgdg10
    sqlite_fdw10.x86_64                       1.0.0-1.rhel7        pgdg10
    sqlite_fdw10-debuginfo.x86_64             1.0.0-1.rhel7        pgdg10
    tds_fdw10.x86_64                          1.0.8-1.rhel7        pgdg10
    tds_fdw10-debuginfo.x86_64                1.0.8-1.rhel7        pgdg10

Is compiling oracle_fdw the only chance I have? 

Regards
Thomas