PostgreSQL 8.1.11

Quick installation steps for the APPX to PostgreSQL connection:

• Install PostgreSQL.
• Install UnixODBC.
• Define DSN files, odbc.ini and odbcinst.ini
• Set in either the APPX Login Manager's daemon environment or the appx.env file, the APPX environment variable APPX_ODBC_LIB equal to the file name of the unixodbc shared library file from the UnixODBC install. (For example APPX_ODBC_LIB=/usr/lib/libodbc.so).
• Now define APPX FMS settings.

Detailed installation example for the APPX to PostgreSQL connection:

Here are the steps I used to make connection with APPX 4.3.0 and PostgreSQL 8.1.11 with both installed on the same Red Hat Enterprise 5.1, 32 bit server. The PostgreSQL database and UnixODBC will be provided by Red Hat. UnixODBC will also be provided by Red Hat.

Install PostgreSQL, PostgreSQL-Server, PostgreSQL-libs, PostgreSQL-ODBC and UnixODBC