- 2 Paràmetres UnixODBC recomanats per a PostgreSQL
- 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.
- CommLog = /tmp/sql.log
- Name of Server. IP or DNS
- Database name
- Postmaster listening port
- Database is read only
- Whether the datasource will allow updates.
- 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.
- Includes the OID in SQLColumns
- Fakes a unique index on OID
- 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.
- Show SystemTables
- The driver will treat system tables as regular tables in SQLTables. This is good for Access so you can see system tables.
- If true, the driver automatically uses declare cursor/fetch to handle SELECT statements and keeps 100 rows in a cache.
- Bools as Char
- Bools are mapped to SQL_CHAR, otherwise to SQL_BIT.
- SSL mode
- Send to backend on connection
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 =