2 Paràmetres UnixODBC recomanats per a PostgreSQL

Instal·lació

• Red Hat Enterprise Linux:

    dnf install postgresql-odbc

• Debian/Ubuntu:

Reviseu la documentació de PostgreSQL per descarregar els controladors de la base de dades necessaris per a la plataforma corresponent.

Per tindre més informació, reviseu: instal·lació de unixODBC.

Configuració

La configuració ODBC es fa editant els arxius odbcinst.ini i odbc.ini. Aquests arxius de configuració es poden trobar al directori /etc. L'arxiu odbcinst.ini potser no hi és; en aquest cas, cal crear-lo manualment.

Tingueu en compte els exemples següents:

odbcinst.ini

[postgresql] Description = General ODBC for PostgreSQL Driver= /usr/lib64/libodbcpsql.so Setup= /usr/lib64/libodbcpsqlS.so FileUsage= 1 # Since 1.6 if the driver manager was built with thread support you may add another entry to each driver entry. # This entry alters the default thread serialization level. Threading= 2

odbc.ini

[TEST_PSQL] Description = PostgreSQL database 1 Driver= postgresql #CommLog = /tmp/sql.log Username = zbx_test Password = zabbix # Name of Server. IP or DNS Servername = 127.0.0.1 # Database name Database = zabbix # Postmaster listening port Port = 5432 # Database is read only # Whether the datasource will allow updates. ReadOnly = No # PostgreSQL backend protocol # Note that when using SSL connections this setting is ignored. # 7.4+: Use the 7.4(V3) protocol. This is only compatible with 7.4 and higher backends. Protocol = 7.4+ # Includes the OID in SQLColumns ShowOidColumn = No # Fakes a unique index on OID FakeOidIndex= No # Row Versioning # Allows applications to detect whether data has been modified by other users # while you are attempting to update a row. # It also speeds the update process since every single column does not need to be specified in the where clause to update a row. RowVersioning = No # Show SystemTables # The driver will treat system tables as regular tables in SQLTables. This is good for Access so you can see system tables. ShowSystemTables = No # If true, the driver automatically uses declare cursor/fetch to handle SELECT statements and keeps 100 rows in a cache. Fetch = Yes # Bools as Char # Bools are mapped to SQL_CHAR, otherwise to SQL_BIT. BoolsAsChar = Yes # SSL mode SSLmode = Require # Send to backend on connection ConnSettings =