Changing the Library Directory for PostgreSQL
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:
bash-3.2$ cd /opt/PostgreSQL/8.4/bin
Use the following steps to change the path to the Library directory:
- From the CommCell Browser, navigate to <Client> | PostgreSQL.
- Right-click the <Instance>, and then click Properties.
- 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.
For Windows, the path would be similar to C:\Program Files\PostgreSQL\9.1\lib
For UNIX, the path would be similar to /opt/PostgreSQL/9.1/lib
- Click OK.
Last modified: 6/5/2019 6:17:17 AM