Issue
I am getting issue as -
psql: symbol lookup error: psql: undefined symbol: PQsetErrorContextVisibility
I also followed the link - href="https://stackoverflow.com/q/52303275/14048308">psql: symbol lookup error: psql: undefined symbol: PQsetErrorContextVisibility
But was not able to solve that issue.
Command which I tried -
export LD_LIBRARY_PATH=/usr/pgsql_12/lib
And also looked for -
rpm -qa|grep postgresql
postgresql-libs-9.2.24-4.el7_8.x86_64
postgresql12-libs-12.3-5PGDG.rhel7.x86_64
postgresql11-libs-11.9-1PGDG.rhel7.x86_64
spacewalk-postgresql-clean-2.7.4-1.0.1.el7.noarch
postgresql12-contrib-12.3-5PGDG.rhel7.x86_64
postgresql12-12.3-5PGDG.rhel7.x86_64
postgresql12-devel-12.3-5PGDG.rhel7.x86_64
postgresql12-server-12.3-5PGDG.rhel7.x86_64
Can someone please help me with this? Thanks in advance!
Solution
This function was introduced in libpq in 9.5, so your psql from v12 must by mistake try to load the libpq from version 9.2, which causes this linker error.
You can try to change your shared library search path so that doesn't happen, but usually the better solution is to remove the 9.2 installation. The operating system packages and the PGDG packages don't work together well.
Answered By - Laurenz Albe Answer Checked By - Candace Johnson (WPSolving Volunteer)