From: | "Guy Rouillier" <guy(dot)rouillier(at)gmail(dot)com> |
---|---|
To: | prakash(dot)ramakrishnan(dot)ap(at)nielsen(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org |
Cc: | prakash(dot)ramakrishnan(dot)ap(at)nielsen(dot)com |
Subject: | Re: BUG #15656: Not able to login database |
Date: | 2019-02-27 05:25:08 |
Message-ID: | emb6a975d3-ddf9-4edf-8288-2ee8248e0a25@asus |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On 2/26/2019 8:30:37 AM, "PG Bug reporting form"
<noreply(at)postgresql(dot)org> wrote:
>The following bug has been logged on the website:
>
>Bug reference: 15656
>Logged by: ramakrishnan r
>Email address: prakash(dot)ramakrishnan(dot)ap(at)nielsen(dot)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(at)sydcosausd001(dot)enterprisenet(dot)org:/home/postgres
>==> export LD_LIBRARY_PATH
>postgres(at)sydcosausd001(dot)enterprisenet(dot)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(at)sydcosausd001(dot)enterprisenet(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | PG Bug reporting form | 2019-02-27 07:24:39 | BUG #15659: missing comment "change requires restart" in postgresql.conf for parameter "data_sync_retry" |
Previous Message | Justin | 2019-02-27 02:15:35 | Re: BUG #15658: Window Function in a left join using AS or alias for the cloumn name |