iNTERFACEWARE Products Manual > Installing and Using Iguana > Getting Started > Deploying Iguana on Unix, Linux and Mac OS X > Database Deployment Issues > Using Iguana With PostgreSQL via ODBC |
![]() ![]() |
Looking for Iguana v.5 or v.6? Learn More or see the Help Center.
Iguana supports PostgreSQL on Unix/Linux platforms through ODBC. Iguana utilizes the shared library of an ODBC manager, which in turn utilizes the shared library of PostgreSQL's ODBC driver. If your installation of PostgreSQL does not include an ODBC driver, you may download psqlodbc, which is the official PostgreSQL ODBC driver. Furthermore, if you do not already have an ODBC driver manager, you may download unixODBC, which is a popular ODBC driver manager distributed under GPL and LGPL. Although unixODBC includes a PostgreSQL ODBC driver, at the time of writing of this manual (Dec. 2004), some features utilized by Iguana weren't supported by the included driver. Therefore, it is recommended that the latest version of psqlodbc be installed. Additionally, please ensure that the odbc.ini file utilized by the ODBC driver manager is configured to link to psqlodbc and not to some other PostgreSQL ODBC driver. Two environment variables need to be configured for proper ODBC support on Unix/Linux. The LD_LIBRARY_PATH (or the equivalent dynamic linker variable for your platform) will need to include the absolute path to the ODBC driver manager's shared library. Also, unixODBC requires an ODBCSYSINI environment variable to point to the directory that contains the odbc.ini file. |