Re: BUG #15656: Not able to login database - Mailing list pgsql-bugs

From Guy Rouillier
Subject Re: BUG #15656: Not able to login database
Date
Msg-id emb6a975d3-ddf9-4edf-8288-2ee8248e0a25@asus
Whole thread Raw
In response to BUG #15656: Not able to login database  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
On 2/26/2019 8:30:37 AM, "PG Bug reporting form" <noreply@postgresql.org> wrote:

The following bug has been logged on the website:
 
Bug reference: 15656
Logged by: ramakrishnan r
Email address: prakash.ramakrishnan.ap@nielsen.com
PostgreSQL version: 10.4
Operating system: rhel 7.5
Description:
 
Hi Team,
 
we are facing in PostgreSQL symbol lookup error and not able to login please
do the needful.
 
==> export LD_LIBRARY_PATH=$/opt/app/PostgreSQL/10/lib:$LD_LIBRARY_PATH
postgres@sydcosausd001.enterprisenet.org:/home/postgres
==> export LD_LIBRARY_PATH
postgres@sydcosausd001.enterprisenet.org:/home/postgres
==> psql -p 5432
/opt/app/PostgreSQL/10/bin/psql.bin: symbol lookup error:
/opt/app/PostgreSQL/10/bin/psql.bin: undefined symbol:
PQsetErrorContextVisibility
postgres@sydcosausd001.enterprisenet.org:/home/postgres
 
I just did a fresh install of PG 10.6 on Linux Mint 19.1 Tessa, using the version in the repos:

postgres=# select version();
                                                            version                                                            
-------------------------------------------------------------------------------------------------------------------------------
 PostgreSQL 10.6 (Ubuntu 10.6-0ubuntu0.18.04.1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 7.3.0-16ubuntu3) 7.3.0, 64-bit
(1 row)

I didn't have to do anything with LD_LIBRARY_PATH because I did a default installation.  Function PQsetErrorContextVisibility is found here:

/usr/lib/x86_64-linux-gnu/libpq.so.5

If I do "ldd /usr/lib/postgresql/10/bin/psql" the second entry I see is this:

libpq.so.5 => /usr/lib/x86_64-linux-gnu/libpq.so.5 (0x00007f93b7f20000)

So, find where libpq.so.* is installed on your system, and make sure that is on your LD_LIBRARY_PATH. Use ldd to ensure that psql is fully linked to required libraries.

--
Guy Rouillier



pgsql-bugs by date:

Previous
From: Justin
Date:
Subject: Re: BUG #15658: Window Function in a left join using AS or alias forthe cloumn name
Next
From: PG Bug reporting form
Date:
Subject: BUG #15659: missing comment "change requires restart" in postgresql.conf for parameter "data_sync_retry"