1、安装EPEL在CentOS中，您需要安装EPEL存储库来安装FreeTDS。sudo yum install epel-release
2、安装FreeTDSTDS外部数据包装器需要一个实现DB-Library接口的库，例如FreeTDS。sudo yum install freetds freetds-devel
3、安装PostgreS兑恶铼融QL如果你需要安装PostgreSQL，请按照yum的安装说明。例如，在CentOS 7上安装PostgreSQL 9.5：wget https多唉捋胝://download.postgresql.org/pub/repos/yum/9.5/redhat/rhel-7-x86_64/pgdg-centos95-9.5-2.noarch.rpmsudo rpm -ivh pgdg-centos95-9.5-2.noarch.rpmsudo yum install postgresql95 postgresql95-server postgresql95-libs postgresql95-devel
4、安装tds_fdwa.从发行包构建如果您想使用其中一个发行包，可以通过以下方式下载并安装它们：export TDS_FDW_VERSION = “ 1.0.7 ”wget https://g足毂忍珩ithub.com/GeoffMontee/tds_fdw/archive/v $ {TDS_FDW_VERSION} .tar.gz -O tds_fdw- $ {TDS_FDW_VERSION} .tar.gztar -xvzf tds_fdw- $ {TDS_FDW_VERSION} .tar.gzcd tds_fdw- $ {TDS_FDW_VERSION}PATH = / usr / pgsql-9.5 / bin：$ PATH make USE_PGXS = 1sudo PATH = / usr / pgsql-9.5 / bin：$ PATH make USE_PGXS = 1 installb.从存储库构建如果您希望使用当前的开发版本，您可以通过以下方式克隆和构建git仓库：git clone https://github.com/GeoffMontee/tds_fdw.gitcd tds_fdwPATH = / usr / pgsql-9.5 / bin：$ PATH make USE_PGXS = 1sudo PATH = / usr / pgsql-9.5 / bin：$ PATH make USE_PGXS = 1 install
5、启动服务器如果这是全新安装，则应初始化数据目录并启动服务器：sudo /etc/init.d/postgresql-9.5 initdbsudo /etc/init.d/postgresql-9.5 start安装扩展/usr/pgsql-9.5/bin/psql -U postgrespostgres = ＃ CREATE EXTENSION tds_fdw;