Esta es una traducción de la página de documentación original en español. Ayúdanos a mejorarla.

2 Configuración recomendada de UnixODBC para PostgreSQL

Instalación

  • · ** Red Hat Enterprise Linux/CentOS**:

· # yum install postgresql-odbc

  • · Debian/Ubuntu:

Consulte documentación PostgreSQL para descargar el controlador de base de datos necesario para la plataforma correspondiente.

Para más información, consulte: instalando unixODBC.

Configuración

La configuración de ODBC se realiza editando los archivos odbcinst.ini y odbc.ini. Estos archivos de configuración se pueden encontrar en la carpeta /etc. Puede que falte el archivo odbcinst.ini y en este caso es necesario crearlo manualmente.

Por favor considere los siguientes ejemplos:

odbcinst.ini

[posgresql]
           [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 = Yes
        # Send tobackend on connection
        ConnSettings =