After installing iODBC, proceed to install the PostgreSQL ODBC drivers.

Download the psqlODBC source tarball file from http://www.postgresql.org/ftp/odbc/versions/src/. Use the latest version available for download, which will be at the bottom of the downloads page. The file will look similar to psqlodbc-09.03.0400.tar.gz. Extract this tarball to a temporary location, open a terminal, and cd into that directory. The installation process is:

shell> cd the/src/directory
shell> ./configure --with-iodbc --enable-pthreads
shell> make
shell> sudo make install          

Verify the installation by confirming that the file psqlodbcw.so is in the /usr/local/lib directory.

Next, you must register your new ODBC Driver.

Open the iODBC Data Source Administrator application by either executing iodbcadm-gtk in the command-line, or by launching it from the Overview page of the MySQL Workbench Migration Wizard by clicking the Open ODBC Administrator button.

Go to the ODBC Drivers tab in the iODBC Data Source Administrator. It should look similar to:

Figure 10.46 The iODBC Data Source Administrator

The iODBC Data Source Administrator

Click Add a driver then fill out the form with the following values:

  • Description of the driver: psqlODBC

  • Driver file name: /usr/local/lib/psqlodbcw.so

  • Setup file name: No value is needed here

And lastly, clicking OK will complete the psqlODBC driver registration.

Download this Manual
PDF (US Ltr) - 14.7Mb
PDF (A4) - 14.7Mb
EPUB - 12.8Mb
HTML Download (TGZ) - 12.7Mb
HTML Download (Zip) - 12.8Mb
User Comments
Sign Up Login You must be logged in to post a comment.