PostgreSQL ODBC Driver

Before you can connect to a PostgreSQL repository, you must first set up a PostgreSQL ODBC driver. To do this, you must have Microsoft MDAC components, a PostgreSQL DBMS system and a PostgreSQL ODBC driver (version minimum) installed.


Do not use version 8.4.1 of the PostgreSQL ODBC Driver; it presents difficulties in transferring a project to a PostgreSQL repository.

To set up your PostgreSQL ODBC driver, follow the steps below:

  1. Select the WindowsTM Control Panel | Administrative Tools | Data Sources (ODBC) option. The ODBC Data Sources Administrator window displays.
  2. Click on the Add button. The Create New Data Source dialog displays, enabling you to add a new DSN.
  3. Select PostgreSQL UNICODE from the list.
  4. Click on the Finish button.
  5. Enter the following configuration details:
  • A name for the connection
  • The actual name of the database.
  • Description (optional)
  • The host address of the PostgreSQL server.
  • User name and password.


  1. Click on the Datasource button and set the options on Page 1 and Page 2 as shown on the examples below:


On Page 2, For PostgreSQL version 8+ select the Disallow Premature checkbox and, in the Protocol panel, select the 7.4+ radio button.

  1. Click on the OK button to complete the configuration.

Your PostgreSQL ODBC driver is now available to use in creating a PostgreSQL repository and connecting to it in Enterprise Architect.