Getting started with Devart ODBC Driver for PostgreSQL

To connect ODBC-compatible applications to PostgreSQL, you need an ODBC driver and access to PostgreSQL.

Devart ODBC Driver for PostgreSQL enables efficient connectivity between PostgreSQL and your favorite BI, reporting, analytics, ETL, and database tools. ODBC-compliant applications can connect and access data without any additional client software.

This guide shows you how to install and activate the Driver, configure an ODBC data source (DSN), connect to PostgreSQL using a DSN or connection string, and troubleshoot common connection issues.

Quick start: Connect to PostgreSQL with ODBC

To connect to PostgreSQL using the Devart ODBC Driver:

  1. Download and install the Driver for Windows, macOS, or Linux.
  2. Activate the Driver using your activation key, or continue with the 30-day trial. On Windows and macOS, take this step in the installer; on Linux, run the activator afterwards.
  3. Create an ODBC data source (DSN) and select Devart ODBC Driver for PostgreSQL.
  4. Configure the connection by specifying the server name, port, user ID, password, and database to access.
  5. Use the DSN in your ODBC-compatible application to connect to PostgreSQL and work with its data.

The following sections provide detailed installation and configuration instructions for each of the supported operating systems.

Prerequisites

Before you begin, make sure your environment meets the following requirements:

  • Operating system: 32-bit or 64-bit Windows, including Windows Terminal Server; macOS (x64 or ARM64, including Apple silicon); Linux (32-bit or 64-bit).
  • ODBC driver manager: Included with Windows. On macOS, install iODBC. On Linux, install unixODBC.
  • Connection details: Access to a PostgreSQL server, a database, and valid credentials (username and password).
  • DSN configuration tool (optional): On macOS and Linux, you can use Devart ODBC Administrator to create and manage data sources through a graphical interface. The tool is distributed separately from the Driver and is available on the Devart website. Alternatively, configure data sources manually in the odbc.ini file.
  • Activation key: A purchased version of the Driver requires an activation key. For evaluation purposes, you can use the trial version, which is valid for 30 days from the date of installation.
  • Administrator rights: Required to install the Driver on all supported operating systems.

For a complete list of supported PostgreSQL versions, cloud platforms, operating systems, and third-party tools, see the ODBC Driver for PostgreSQL compatibility page.

Install the ODBC Driver

Installing the Devart ODBC Driver for PostgreSQL is straightforward. All you need to do is download the package for your operating system and follow the installation instructions.

Install the Driver on Windows

Note
The installer for Devart ODBC Driver for PostgreSQL is available in two formats: .exe and .msi.
  • Use the .exe installer for manual installation on individual computers.
  • Use the .msi installer for enterprise deployments and automated installation.
You can deploy the .msi package to domain computers through Group Policy and activate the Driver without user interaction. For more information, see Remote installation using Group Policy.

1. Download the ODBC Driver for PostgreSQL from the Devart website, open it, and click Next.

Install ODBC Driver for PostgreSQL on Windows

2. Read the License Agreement, select I accept the agreement, and click Next.

Read and accept the license agreement

3. On the Select Destination Location page, keep the default folder or click Browse to choose another one, and click Next.

Select the folder for the Driver installation

4. On the Select Components page, select the components to install, then click Next.

Note
Install the Driver version that matches your application bitness, not your operating system bitness. For example, a 32-bit application, such as 32-bit Microsoft Office, requires a Driver for Win32 even on 64-bit Windows.

Choose the ODBC Driver for PostgreSQL version

5. On the Select Start Menu Folder page, specify the folder for the Driver shortcuts. To skip creating a Start Menu folder, select Don't create a Start Menu folder. Click Next, then click Install.

Select the Start menu folder

6. On the License Information page, select Input activation key and enter your key. You can find it in the registration email or your Customer Portal. To open the Customer Portal, click Get Activation Key.

If the activation key is saved on your computer, click Load Activation Key and select the corresponding file.

To evaluate the Driver without a purchased key, select Trial evaluation.

Activate ODBC Driver for PostgreSQL

7. Click Next, then click Finish to complete the installation.

Install the Driver on macOS

1. Download the ODBC Driver for PostgreSQL PKG file from the Devart website and double-click the package to run it.

Note

macOS may block the installation package because Apple cannot verify it. If this happens, verify the package manually:

  1. Dismiss the warning.
  2. Open System Settings > Privacy & Security. On macOS 12 and earlier, open System Preferences > Security & Privacy > General.
  3. Find the message about the blocked package and click Open Anyway.
  4. Confirm that you want to open the package, and enter your administrator password if prompted.

Security warning during the installation of the ODBC Driver for PostgreSQL

2. Run the installer and click Continue.

Installation of the ODBC Driver for PostgreSQL on macOS

3. Read the license agreement, then click Agree.

4. On the Registration page, select Input activation key and enter your key, or click Load Activation Key and select the file that contains it. To evaluate the Driver without a purchased key, select Trial evaluation. Click Continue.

Input your purchased or trial activation key

5. On the Installation Type page, click Install. To choose which components to install, click Customize first. When the installation finishes, click Close.

Installation successful

You can activate the Driver later from the Terminal: navigate to /Library/ODBC/Devart/PostgreSQL and run the activator with your key.

cd /Library/ODBC/Devart/PostgreSQL
sudo ./postgresqlodbcactivator -a <your_activation_key>

Install the Driver on Linux

On Linux, the Driver requires the unixODBC driver manager, which must be installed separately. Follow the track that matches the package format of your distribution.

DEB-based distributions, such as Ubuntu and Debian

The commands below apply to Ubuntu 26.04 LTS, 24.04 LTS, and 22.04 LTS.

1. Install the unixODBC driver manager.

sudo apt-get update
sudo apt-get install -y unixodbc odbcinst

2. Download the DEB package for your architecture from the Devart website.

3. Open a terminal, navigate to the folder that contains the package, and install the package and its required dependencies.

cd ~/Downloads
sudo apt-get install -y ./devartodbcpostgresql_amd64.deb

4. Activate the Driver. Navigate to the folder where it is installed and run the activator with your key.

cd /usr/share/devart/odbcpostgresql
sudo ./postgresqlodbcactivator -a <your_activation_key>
Note

You can find your activation key in the registration email or your Customer Portal account. To activate the Driver using a file that contains the activation key, specify the full path to the file instead of the activation key.

5. Verify that the Driver is registered.

odbcinst -q -d

The output should include [Devart ODBC Driver for PostgreSQL].

Then verify that the DSN created during installation is registered.

odbcinst -q -s

The output should include the automatically created DSN.

RPM-based distributions, such as CentOS, RHEL, and Fedora

The commands below apply to CentOS Stream 9 and 10.

1. Install the unixODBC driver manager.

sudo dnf install unixODBC

2. Download the RPM package.

Note

The Driver requires the gtk2 package. On newer distributions, such as CentOS Stream 10, install it manually from the EPEL repository before installing the Driver.

sudo dnf install -y epel-release
sudo dnf install -y gtk2

3. Open a terminal, navigate to the folder that contains the package, and install the package and its required dependencies.

cd ~/Downloads
sudo dnf install ./devart-odbc-postgresql.x86_64.rpm

4. Activate the Driver. Navigate to the installation folder and run the activator with your key:

cd /usr/local/devart/odbcpostgresql
sudo ./postgresqlodbcactivator -a <your_activation_key>
Note
You can find your activation key in the registration email or your Customer Portal account. To activate the Driver using a file that contains the activation key, specify the full path to the file instead of the activation key.

5. Verify that the Driver is registered.

odbcinst -q -d

The output should include [Devart ODBC Driver for PostgreSQL].

Then verify that the DSN created during installation is registered.

odbcinst -q -s

The output should include the automatically created DSN.

Configure an ODBC data source

In this guide, you create a Data Source Name (DSN) for the ODBC connection and verify the connection details. A DSN stores connection settings, such as the server name, port, database name, and credentials that applications use to connect to PostgreSQL. Applications can also connect without a DSN by passing the same parameters in a connection string.

Configure a DSN on Windows

1. In Windows Search, enter ODBC Data Sources and open the ODBC Data Source Administrator that matches the bitness of your application.

2. Go to the User DSN, System DSN, or File DSN tab, and click Add:

  • User DSN — Available only to the user who creates it.
  • System DSN — Available to all users on the computer.
  • File DSN — Stores connection settings in a file that can be shared between computers where the required ODBC driver is installed.
Note
Most applications support all DSN types. However, some applications require a specific DSN type.

3. In the Create New Data Source dialog, select Devart ODBC Driver for PostgreSQL, and click Finish.

Create a new data source as the ODBC Driver for PostgreSQL

4. In the Devart ODBC Driver for PostgreSQL Configuration dialog, enter a Data Source Name and an optional Description.

5. To authenticate, specify the connection settings:

  • Server — The PostgreSQL host name or IP address.
  • Port — The port number for the connection. The default port is 5432.
  • User ID — The PostgreSQL username.
  • Password — The PostgreSQL password.
  • Database (optional) — The default database to connect to.
  • Schema (optional) — The default schema to use.

Connect the ODBC Driver to PostgreSQL on Windows

6. Optional: Click Test Connection to verify the connection settings.

Test the ODBC connection to PostgreSQL

7. When the configuration is completed, click OK to save the DSN settings.

To fine-tune metadata, timeout, and compatibility behavior, use the Advanced Settings tab of the same dialog.

Configure a DSN on macOS

DSNs are managed in Devart ODBC Administrator, a graphical tool that is distributed separately from the Driver. Download and install it before you continue.

1. Open Devart ODBC Administrator (root), select the System DSN tab (recommended), and click Add. Enter your password when prompted.

Note
Editing System DSN settings requires administrator privileges. If you open Devart ODBC Administrator without them, select User DSN instead.

2. In the Choose a driver dialog, select Devart ODBC Driver for PostgreSQL and click OK.

Select the ODBC Driver for PostgreSQL in Devart ODBC Administrator on macOS

3. In the Devart ODBC Driver for PostgreSQL Configuration dialog, enter the Data Source Name and an optional Description. Then enter the PostgreSQL host name or IP address, the port, your user ID and password, and, if needed, the database and schema.

4. Optional: Click Test Connection to verify the connection details. Then click OK to save the DSN settings.

DSN configuration for a connection to PostgreSQL on macOS

Alternatively, edit the odbc.ini file directly. The installation creates a sample DSN named DEVART_POSTGRESQL that you can adjust. Use /Library/ODBC/odbc.ini for a system-wide DSN or ~/.odbc.ini for a user-specific one.

[DEVART_POSTGRESQL]
Driver=Devart ODBC Driver for PostgreSQL
Data Source=your_postgresql_server_name
Database=your_database_name
Port=your_postgresql_port
User ID=your_postgresql_user_id
Password=your_postgresql_password

Save and close the file.

Configure a DSN on Linux

As on macOS, Devart ODBC Administrator is distributed separately from the Driver. Download and install it from the Devart website before you continue.

For DEB-based distributions:

cd ~/Downloads
sudo apt-get install -y ./devartodbcadministrator_amd64.deb

For RPM-based distributions:

cd ~/Downloads
sudo dnf install ./devart-odbc-administrator.x86_64.rpm

After installing the ODBC Administrator, proceed to configure a DSN.

1. Open Devart ODBC Administrator (root), select the System DSN tab, and click Add.

2. In the Choose a driver dialog, select Devart ODBC Driver for PostgreSQL and click OK.

Select the ODBC Driver for PostgreSQL in Devart ODBC Administrator on Linux

3. In the Devart ODBC Driver for PostgreSQL Configuration dialog, enter the Data Source Name and an optional Description. Enter the PostgreSQL host name or IP address, specify the port for connecting to PostgreSQL, and provide your PostgreSQL user ID and password. If needed, enter the name of the PostgreSQL database you need to connect to.

Enter the connection parameters

4. Optional: Click Test Connection to verify the connection settings. If the test succeeds, click OK to save the DSN settings.

Alternatively, define the DSN in /etc/odbc.ini. The installation creates a sample DSN named DEVART_POSTGRESQL that you can adjust. Use /etc/odbc.ini for a system-wide DSN or ~/.odbc.ini for a user-specific one.

[DEVART_POSTGRESQL]
Driver=Devart ODBC Driver for PostgreSQL
Data Source=your_postgresql_server_name
Database=your_database_name
Port=your_postgresql_port_number
User ID=your_postgresql_user_id
Password=your_postgresql_password

To verify the data source from a terminal, connect to it with isql, the command-line tool provided by unixODBC. Replace <your_dsn_name> with the name of your DSN.

isql -v <your_dsn_name>

Connect to PostgreSQL using a connection string

In addition to using a DSN, you can connect to PostgreSQL by specifying the connection parameters directly in an ODBC connection string. This type of connection is known as a DSN-less connection.

The following table summarizes when to use each connection method.

Connection method How it works Best for
DSN Stores the connection settings in a configured ODBC data source. Applications connect by specifying the DSN name. Desktop applications, BI and reporting tools, and reusable connections configured on a client computer.
DSN-less Specifies the Driver, server, database, credentials, and other settings directly in a connection string. No DSN needs to be created beforehand. Applications, scripts, and automated deployments where connection settings are managed programmatically.

Use the following connection string configuration.

DRIVER={Devart ODBC Driver for PostgreSQL};Server=myServer;Port=myPort;User ID=myUsername;Password=myPassword;Database=myDatabase;Schema=mySchema

Replace the placeholders with your actual connection settings.

You can also specify advanced connection parameters to configure connection timeout, IP version, ODBC behavior, and other Driver settings. For the complete list of supported options, see PostgreSQL ODBC connection string parameters.

Troubleshooting

If you cannot connect to PostgreSQL through the Devart ODBC Driver, refer to the following list of common connection issues and their solutions to troubleshoot and fix the problem.

You get a "Product is not activated or has been deactivated" error

This error occurs when the Driver has not been activated or its activation is no longer valid.

  • Windows: Open the DSN configuration dialog, go to the License tab, click Input Activation Key, and enter your activation key.
  • macOS and Linux: In Devart ODBC Administrator, select the DSN and click Configure. On the License tab of the configuration dialog, click Input Activation Key and enter your activation key. Alternatively, run the postgresqlodbcactivator utility from the Driver installation folder with your activation key.

After activation, test the connection again.

The ODBC data source is not found or the Driver is not available

If your application cannot find the DSN or the Devart ODBC Driver for PostgreSQL, check the application and Driver bitness.

A 32-bit application cannot use a DSN created in the 64-bit ODBC Data Source Administrator, and a 64-bit application cannot use a DSN created in the 32-bit administrator.

Make sure that:

  • The DSN is created in the ODBC administrator that matches your application's bitness.
  • The corresponding 32-bit or 64-bit version of the Driver is installed.
  • The application is configured to use the correct DSN.

The Driver cannot connect to PostgreSQL

If the Driver cannot reach your PostgreSQL server, verify the server address and your network settings:

  • Make sure the server field contains the correct name.
  • Verify that you are using the correct port. Make sure the PostgreSQL server is running.
  • Check that your firewall allows outbound connections to PostgreSQL.

Also, make sure that your PostgreSQL server accepts remote connections. By default, PostgreSQL listens only on localhost: the listen_addresses parameter in postgresql.conf must include the server's network address or *. If you change this parameter, you need to restart the server.

For cloud platforms (e.g., Amazon RDS or Azure Database for PostgreSQL), check the firewall rules or security groups.

Login or database connection fails

If PostgreSQL is reachable but authentication fails, check the connection credentials:

  • Verify the user ID and password used to connect to PostgreSQL.
  • Check the name of the database you are connecting to.
  • Verify the encryption settings: the certificate name is correct and the certificate is trusted.
  • Ensure that the PostgreSQL user has the required database access privileges.

PostgreSQL connection times out

If the connection to PostgreSQL takes too long to establish, increase Connection Timeout on the Advanced Settings tab. Also, check the network connection.

Additional resources

After you install and configure Devart ODBC Driver for PostgreSQL, use the following resources to continue setting up and working with your connections:

  • Connection string parameters — Browse the complete list of connection options for configuring server, SSL/SSH/HTTP tunneling, timeouts, IP Version, ODBC behavior, and other Driver settings.
  • Supported ODBC functions — Explore the currently supported ODBC functions.
  • Using in third-party tools — Find step-by-step guides for connecting BI, reporting, analytics, and other ODBC-compatible tools to PostgreSQL.
  • Documentation — Get full information on installing, configuring, and using the Devart ODBC Driver for PostgreSQL.

ODBC Drivers

Reliable and easy-to-use ODBC connectors for popular data sources. Compatible with multiple third-party tools.