ODBC Driver for PostgreSQL

Linux DSN Configuration - ODBC Driver for PostgreSQL

Linux DSN Configuration

After the linux (DEB or RPM) driver is installed, a DSN with the name DEVART_POSTGRESQL is created. You can use it to test the connection with the POSTGRESQL server. For this, perform the following steps:

  1. Open the odbc.ini file located in the /etc folder. Find the DEVART_POSTGRESQL section and specify the required connection settings:
    User ID=<your PostgreSQL User Name>
    Password=<your PostgreSQL password>
    Host=<your PostgreSQL Server Name>
    Port=<your PostgreSQL Port>
    Database=<your PostgreSQL database name>
    
  2. Run the UnixODBC Test Command utility and test a connection using the following command:
    isql -v DEVART_POSTGRESQL 

See Also

Connection Options

© 2015-2022 Devart. All Rights Reserved. Request Support ODBC Forum Provide Feedback