Support Centre

Find articles, help and advice.

 
Welcome, Guest Login

Support Center

BES - DBcon returns "psql: symbol lookup error: psql: undefined symbol: PQsetErrorContextVisibility"

Last Updated: Apr 26, 2017 03:02PM UTC
Problem

Unable to open a SQL session to the BES database via DBcon.

Error


psql: symbol lookup error: psql: undefined symbol: PQsetErrorContextVisibility
 

Resolution

Perform the following to resolve this issue:

1. Backup the following file: $PPHOME/lib/libpq.so.5
2. Copy the libpq.so.5 from /usr/pgsql-<version>/lib to $PPHOME/lib, replacing the existing file. Ensure that file permission and ownership is correct:

-rwxr-xr-x.  1 ppadmin ppusers  185605 Jun 23  2015 libpq.so.5*

3. DBcon should now launch a SQL session to the BES database.

Contact Us

desk.com@interlinksoftware.com
https://cdn.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete