一、ODBC安装
1)UnixODBC安装
* yum安装
# yum install -y unixODBC.x86_64
*
* 验证安装
# rpm -qa | grep unixODBC
unixODBC-2.3.1-11.el7.x86_64
2)PostgresqlODBC安装
* yum安装
# yum install -y postgresql-odbc.x86_64
* 验证安装
# rpm -qa | grep postgresql-odbc
postgresql-odbc-09.03.0100-2.el7.x86_64
二、ODBC配置
1)查看odbcinst
# cat /etc/odbcinst.ini
~
[PostgreSQL]
D
Description = ODBC for PostgreSQL
D
Driver = /usr/lib/psqlodbcw.so
S
Setup = /usr/lib/libodbcpsqlS.so
D
Driver64 = /usr/lib64/psqlodbcw.so
S
Setup64 = /usr/lib64/libodbcpsqlS.so
FileUsage = 1
2)配置odbc
# vim /etc/odbc.ini
~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
[pg]
Description = Test to pg