Configuring the PostgreSQL Library Directory

PostgreSQL Library directory refers to the location where the PostgreSQL library files reside. You can modify the home path location for an instance at any point of time. Postgres Lib directory path must contain libpq.so file and other related files. This library is used to connect to the database and execute queries. Execute the following command from the bin directory to locate required library path:

pg_config --libdir

For example:

bash-3.2$ cd /opt/PostgreSQL/9.2/bin

bash-3.2$./pg_config --libdir

bash-3.2$ /opt/PostgreSQL/9.2/lib

Procedure

1. From the CommCell Browser, navigate to <Client> | PostgreSQL.

2. Right-click the <Instance>, and then click Properties.

3. In the Lib Directory box, type the path to the Library directory. Alternatively, click Browse to select the path. The PostgreSQL Library Directory is generally located under the PostgreSQL install directory.

   Example:

   For Windows, the path would be similar to C:\Program Files\PostgreSQL\9.2\lib

   For Unix, the path would be similar to /opt/PostgreSQL/9.2/lib

4. Click OK.