postgres fdw extensions 容器镜像
主要是制作一个包含了比较全的pg fdw extension 的容器镜像，方便使用
Dockerfile
因为默认官方的docker 镜像就是基于deb 包生成的，所以可以直接使用
- 参考12 版本的相关包
pgagent - job scheduling engine for PostgreSQL
postgresql-q3c - PostgreSQL extension used for indexing the sky
postgresql-12 - object-relational SQL database, version 12 server
postgresql-12-asn1oid - ASN.1 OID data type for PostgreSQL
postgresql-12-asn1oid-dbgsym - debug symbols for postgresql-12-asn1oid
postgresql-12-bgw-replstatus - report whether PostgreSQL node is master or standby
postgresql-12-bgw-replstatus-dbgsym - debug symbols for postgresql-12-bgw-replstatus
postgresql-12-cron - Run periodic jobs in PostgreSQL
postgresql-12-cron-dbgsym - debug symbols for postgresql-12-cron
postgresql-12-cstore-fdw - PostgreSQL foreign data wrapper for columnar storage
postgresql-12-cstore-fdw-dbgsym - debug symbols for postgresql-12-cstore-fdw
postgresql-12-dbgsym - debug symbols for postgresql-12
postgresql-12-debversion - Debian version number type for PostgreSQL
postgresql-12-debversion-dbgsym - debug symbols for postgresql-12-debversion
postgresql-12-dirtyread - Read dead but unvacuumed tuples from a PostgreSQL relation
postgresql-12-dirtyread-dbgsym - debug symbols for postgresql-12-dirtyread
postgresql-12-extra-window-functions - Extra Window Functions for PostgreSQL
postgresql-12-extra-window-functions-dbgsym - debug symbols for postgresql-12-extra-window-functions
postgresql-12-first-last-agg - PostgreSQL extension providing first and last aggregate functions
postgresql-12-first-last-agg-dbgsym - debug symbols for postgresql-12-first-last-agg
postgresql-12-hll - HyperLogLog extension for PostgreSQL
postgresql-12-hll-dbgsym - debug symbols for postgresql-12-hll
postgresql-12-hypopg - PostgreSQL extension adding support for hypothetical indexes.
postgresql-12-hypopg-dbgsym - debug symbols for postgresql-12-hypopg
postgresql-12-icu-ext - PostgreSQL extension exposing functionality from the ICU library
postgresql-12-icu-ext-dbgsym - debug symbols for postgresql-12-icu-ext
postgresql-12-ip4r - IPv4 and IPv6 types for PostgreSQL 12
postgresql-12-ip4r-dbgsym - debug symbols for postgresql-12-ip4r
postgresql-12-jsquery - PostgreSQL JSON query language with GIN indexing support
postgresql-12-jsquery-dbgsym - debug symbols for postgresql-12-jsquery
postgresql-12-mimeo - specialized, per-table replication between PostgreSQL instances
postgresql-12-mysql-fdw - Postgres 12 Foreign Data Wrapper for MySQL
postgresql-12-mysql-fdw-dbgsym - debug symbols for postgresql-12-mysql-fdw
postgresql-12-numeral - numeral datatypes for PostgreSQL
postgresql-12-numeral-dbgsym - debug symbols for postgresql-12-numeral
postgresql-12-ogr-fdw - PostgreSQL foreign data wrapper for OGR
postgresql-12-ogr-fdw-dbgsym - debug symbols for postgresql-12-ogr-fdw
postgresql-12-omnidb - PostgreSQL PL/pgSQL debugger extension for OmniDB
postgresql-12-omnidb-dbgsym - debug symbols for postgresql-12-omnidb
postgresql-12-orafce - Oracle support functions for PostgreSQL 12
postgresql-12-orafce-dbgsym - debug symbols for postgresql-12-orafce
postgresql-12-partman - PostgreSQL Partition Manager
postgresql-12-partman-dbgsym - debug symbols for postgresql-12-partman
postgresql-12-periods - PERIODs and SYSTEM VERSIONING for PostgreSQL
postgresql-12-periods-dbgsym - debug symbols for postgresql-12-periods
postgresql-12-pg-catcheck - Postgres system catalog checker
postgresql-12-pg-catcheck-dbgsym - debug symbols for postgresql-12-pg-catcheck
postgresql-12-pg-checksums - Activate/deactivate/verify PostgreSQL data checksums
postgresql-12-pg-checksums-dbgsym - debug symbols for postgresql-12-pg-checksums
postgresql-12-pg-fact-loader - Build fact tables asynchronously with Postgres
postgresql-12-pg-fact-loader-dbgsym - debug symbols for postgresql-12-pg-fact-loader
postgresql-12-pg-qualstats - PostgreSQL extension to gather statistics about predicates.
postgresql-12-pg-qualstats-dbgsym - debug symbols for postgresql-12-pg-qualstats
postgresql-12-pg-stat-kcache - PostgreSQL extension to gather per-query kernel statistics.
postgresql-12-pg-stat-kcache-dbgsym - debug symbols for postgresql-12-pg-stat-kcache
postgresql-12-pg-track-settings - PostgreSQL extension tracking of configuration settings
postgresql-12-pg-wait-sampling - Extension providing statistics about PostgreSQL wait events
postgresql-12-pg-wait-sampling-dbgsym - debug symbols for postgresql-12-pg-wait-sampling
postgresql-12-pgaudit - PostgreSQL Audit Extension
postgresql-12-pgaudit-dbgsym - debug symbols for postgresql-12-pgaudit
postgresql-12-pgextwlist - PostgreSQL Extension Whitelisting
postgresql-12-pgextwlist-dbgsym - debug symbols for postgresql-12-pgextwlist
postgresql-12-pgfincore - set of PostgreSQL functions to manage blocks in memory
postgresql-12-pgfincore-dbgsym - debug symbols for postgresql-12-pgfincore
postgresql-12-pgl-ddl-deploy - Transparent DDL replication for PostgreSQL
postgresql-12-pgl-ddl-deploy-dbgsym - debug symbols for postgresql-12-pgl-ddl-deploy
postgresql-12-pglogical - Logical Replication Extension for PostgreSQL
postgresql-12-pglogical-dbgsym - debug symbols for postgresql-12-pglogical
postgresql-12-pglogical-ticker - Have time-based replication delay for pglogical
postgresql-12-pglogical-ticker-dbgsym - debug symbols for postgresql-12-pglogical-ticker
postgresql-12-pgmemcache - PostgreSQL interface to memcached
postgresql-12-pgmemcache-dbgsym - debug symbols for postgresql-12-pgmemcache
postgresql-12-pgmp - arbitrary precision integers and rationals for PostgreSQL 12
postgresql-12-pgmp-dbgsym - debug symbols for postgresql-12-pgmp
postgresql-12-pgpcre - Perl Compatible Regular Expressions (PCRE) extension for PostgreSQL
postgresql-12-pgpcre-dbgsym - debug symbols for postgresql-12-pgpcre
postgresql-12-pgpool2 - connection pool server and replication proxy for PostgreSQL - modules
postgresql-12-pgpool2-dbgsym - debug symbols for postgresql-12-pgpool2
postgresql-12-pgq-node - Cascaded queueing on top of PgQ
postgresql-12-pgq3 - Generic queue for PostgreSQL
postgresql-12-pgq3-dbgsym - debug symbols for postgresql-12-pgq3
postgresql-12-pgrouting - Routing functionality support for PostgreSQL/PostGIS
postgresql-12-pgrouting-dbgsym - debug symbols for postgresql-12-pgrouting
postgresql-12-pgrouting-doc - Routing functionality support for PostgreSQL/PostGIS (Documentation)
postgresql-12-pgrouting-scripts - Routing functionality support for PostgreSQL/PostGIS - SQL scripts
postgresql-12-pgsphere - Spherical data types for PostgreSQL
postgresql-12-pgsphere-dbgsym - debug symbols for postgresql-12-pgsphere
postgresql-12-pgtap - Unit testing framework extension for PostgreSQL 12
postgresql-12-pldebugger - PostgreSQL pl/pgsql Debugger API
postgresql-12-pldebugger-dbgsym - debug symbols for postgresql-12-pldebugger
postgresql-12-pljava - Java procedural language for PostgreSQL 12
postgresql-12-pljava-dbgsym - debug symbols for postgresql-12-pljava
postgresql-12-pllua - Lua procedural language for PostgreSQL 12
postgresql-12-pllua-dbgsym - debug symbols for postgresql-12-pllua
postgresql-12-plpgsql-check - plpgsql_check extension for PostgreSQL
postgresql-12-plpgsql-check-dbgsym - debug symbols for postgresql-12-plpgsql-check
postgresql-12-plproxy - database partitioning system for PostgreSQL 12
postgresql-12-plproxy-dbgsym - debug symbols for postgresql-12-plproxy
postgresql-12-plr - Procedural language interface between PostgreSQL and R
postgresql-12-plr-dbgsym - debug symbols for postgresql-12-plr
postgresql-12-plsh - PL/sh procedural language for PostgreSQL 12
postgresql-12-plsh-dbgsym - debug symbols for postgresql-12-plsh
postgresql-12-pointcloud - PostgreSQL extension for storing point cloud (LIDAR) data
postgresql-12-pointcloud-dbgsym - debug symbols for postgresql-12-pointcloud
postgresql-12-postgis-2.5 - Geographic objects support for PostgreSQL 12
postgresql-12-postgis-2.5-dbgsym - debug symbols for postgresql-12-postgis-2.5
postgresql-12-postgis-2.5-scripts - Geographic objects support for PostgreSQL 12 -- SQL scripts
postgresql-12-postgis-3 - Geographic objects support for PostgreSQL 12
postgresql-12-postgis-3-dbgsym - debug symbols for postgresql-12-postgis-3
postgresql-12-postgis-3-scripts - Geographic objects support for PostgreSQL 12 -- SQL scripts
postgresql-12-powa - PostgreSQL Workload Analyzer -- PostgreSQL 12 extension
postgresql-12-powa-dbgsym - debug symbols for postgresql-12-powa
postgresql-12-prefix - Prefix Range module for PostgreSQL
postgresql-12-prefix-dbgsym - debug symbols for postgresql-12-prefix
postgresql-12-preprepare - pre prepare your PostgreSQL statements server side
postgresql-12-preprepare-dbgsym - debug symbols for postgresql-12-preprepare
postgresql-12-prioritize - Get and set the nice priorities of PostgreSQL backends
postgresql-12-prioritize-dbgsym - debug symbols for postgresql-12-prioritize
postgresql-12-python3-multicorn - multicorn extension for Postgres 12 to write FDWs with python3
postgresql-12-python3-multicorn-dbgsym - debug symbols for postgresql-12-python3-multicorn
postgresql-12-q3c - PostgreSQL 12 extension used for indexing the sky
postgresql-12-q3c-dbgsym - debug symbols for postgresql-12-q3c
postgresql-12-rational - Precise fractional arithmetic for PostgreSQL
postgresql-12-rational-dbgsym - debug symbols for postgresql-12-rational
postgresql-12-repack - reorganize tables in PostgreSQL databases with minimal locks
postgresql-12-repack-dbgsym - debug symbols for postgresql-12-repack
postgresql-12-repmgr - replication manager for PostgreSQL 12
postgresql-12-repmgr-dbgsym - debug symbols for postgresql-12-repmgr
postgresql-12-rum - PostgreSQL RUM access method
postgresql-12-rum-dbgsym - debug symbols for postgresql-12-rum
postgresql-12-similarity - PostgreSQL similarity functions extension
postgresql-12-similarity-dbgsym - debug symbols for postgresql-12-similarity
postgresql-12-slony1-2 - replication system for PostgreSQL: PostgreSQL 12 server plug-in
postgresql-12-slony1-2-dbgsym - debug symbols for postgresql-12-slony1-2
postgresql-12-snakeoil - PostgreSQL anti-virus scanner based on ClamAV
postgresql-12-snakeoil-dbgsym - debug symbols for postgresql-12-snakeoil
postgresql-12-tdigest - t-digest algorithm for on-line accumulation of rank-based statistics
postgresql-12-tdigest-dbgsym - debug symbols for postgresql-12-tdigest
postgresql-12-tds-fdw - PostgreSQL foreign data wrapper for TDS databases
postgresql-12-tds-fdw-dbgsym - debug symbols for postgresql-12-tds-fdw
postgresql-12-toastinfo - Show storage structure of varlena datatypes in PostgreSQL
postgresql-12-toastinfo-dbgsym - debug symbols for postgresql-12-toastinfo
postgresql-12-unit - SI Units for PostgreSQL
postgresql-12-unit-dbgsym - debug symbols for postgresql-12-unit
postgresql-12-wal2json - PostgreSQL logical decoding JSON output plugin
postgresql-12-wal2json-dbgsym - debug symbols for postgresql-12-wal2json
postgresql-client-12 - front-end programs for PostgreSQL 12
- 安装方法
apt-get install -y postgresql-12-tds-fdw
- 参考docker 镜像
FROM postgres:12.3 as build
LABEL AUTHOR="dalongrong"
ENV TZ=Asia/Shanghai \
LANG=zh_CN.UTF-8
RUN set -x \
&& ln -snf /usr/share/zoneinfo/$TZ /etc/localtime && echo $TZ > /etc/timezone \
&& localedef -i zh_CN -c -f UTF-8 -A /usr/share/locale/locale.alias $LANG \
&& echo 'LANG="$LANG"' > /etc/default/locale \
&& apt-get update \
&& apt-get install -y postgresql-12-cstore-fdw postgresql-12-mysql-fdw postgresql-12-tds-fdw postgresql-12-wal2json postgresql-12-pllua postgresql-12-jsquery
说明
以上的安装方法是基于包的模式，不需要源码编译，比较简单
