2 PostgreSQL数据库推荐的UnixODBC设置

    安装

    • Red Hat Enterprise Linux/CentOS:
    • Debian/Ubuntu:

    请参阅 为相应的平台下载必要的数据库驱动程序。

    配置

    通过编辑 odbcinst.ini 和 odbc.ini 文件来完成ODBC的配置。这些配置文件可以在 /etc 文件夹中找到。odbcinst.ini 文件可能不存在，这时我们需要手动来创建它。

    odbcinst.ini

    2.        Description = PostgreSQL database 1
    3.        Driver  = postgresql
    4.        #CommLog = /tmp/sql.log
    5.        Username = zbx_test
    6.        Password = zabbix
    7.        # Name of Server. IP or DNS
    8.        Servername = 127.0.0.1
    9.        # Database name
    10.        Database = zabbix
    11.        Port = 5432
    12.        # Database is read only
    14.        ReadOnly = No
    15.        # PostgreSQL backend protocol
    16.        # Note that when using SSL connections this setting is ignored.
    17.        # 7.4+: Use the 7.4(V3) protocol. This is only compatible with 7.4 and higher backends.
    18.        Protocol = 7.4+
    19.        # Includes the OID in SQLColumns
    20.        ShowOidColumn = No
    21.        # Fakes a unique index on OID
    22.        FakeOidIndex  = No
    23.        # Row Versioning
    24.        # Allows applications to detect whether data has been modified by other users
    26.        RowVersioning = No
    27.        # Show SystemTables
    28.        # The driver will treat system tables as regular tables in SQLTables. This is good for Access so you can see system tables.
    29.        ShowSystemTables = No
    30.        # If true, the driver automatically uses declare cursor/fetch to handle SELECT statements and keeps 100 rows in a cache.
    31.        Fetch = Yes
    32.        # Bools as Char
    33.        # Bools are mapped to SQL_CHAR, otherwise to SQL_BIT.
    34.        BoolsAsChar = Yes
    35.        # SSL mode
    36.        SSLmode = Yes
    37.        # Send tobackend on connection