PostgreSQL unixODBC Configuration

Create the following files:

----pgsql-driver.tpl----------------------------------

[PostgreSQL]

Description = PostgreSQL driver for Linux & Win32

Driver = /usr/lib64/libodbcpsql.so

Setup = /usr/lib64/libodbcpsqlS.so

----pgsql-dsn.tpl----------------------------------

[saga80d01]

Description = CP resources db

Driver = PostgreSQL

Trace = No

TraceFile = sql.log

Database = saga80d01

Servername = localhost

UserName = postgres

Password = postgres

Port = 5432

Protocol = 6.4

ReadOnly = No

RowVersioning = No

ShowSystemTables = No

ShowOidColumn = No

FakeOidIndex = No

ConnSettings =

ExtraSysTablePrefixes =

1. Make sure unixODBC is installed

2. Install a driver

- odbcinst -i -d -f pgsql-driver.tpl

3. Install a system DSN

- odbcinst -i -s -f pgsql-dsn.tpl -l

4. Test Connection

- isql -v