Re: Tab-completion error...? - Mailing list pgsql-general

From Theodore M Rolle, Jr.
Subject Re: Tab-completion error...?
Date
Msg-id CAPDmd-A0FP74Hqo8cUs=oye_KM4dKYnWk9gZDGjkddoTyxSCVw@mail.gmail.com
Whole thread Raw
In response to Re: Tab-completion error...?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Fixed.
Turned out to be LD_LIBRARY_PATH had a /USR/local/lib. Changed it to /usr/local/lib and everything's hunky-dory.

On Tue, Jan 4, 2022 at 6:15 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
"Theodore M Rolle, Jr." <stercor@gmail.com> writes:
> ldd /usr/local/pgsql/bin/psql
> linux-vdso.so.1 (0x0000ffffa2bef000)
> libpq.so.5 => /USR/local/lib/libpq.so.5 (0x0000ffffa2aaf000)
> libreadline.so.8 => /usr/lib/libreadline.so.8 (0x0000ffffa2a1d000)
> libpthread.so.0 => /usr/lib/libpthread.so.0 (0x0000ffffa29ed000)
> libm.so.6 => /usr/lib/libm.so.6 (0x0000ffffa2941000)
> libc.so.6 => /usr/lib/libc.so.6 (0x0000ffffa27cd000)
> /lib/ld-linux-aarch64.so.1 => /usr/lib/ld-linux-aarch64.so.1
> (0x0000ffffa2bbe000)
> libncursesw.so.6 => /usr/lib/libncursesw.so.6 (0x0000ffffa2748000

Hm, is /USR actually in caps, or did you change that for emphasis?

> I'm at a loss as to where the /USR came from.
> It's not in config.log (compile time)
> nor in the psql executable (run time).

I think it came out of /etc/ld.so.conf.

BTW, by default PG would link psql using an rpath switch pointing at
/usr/local/pgsql/lib, which I assume is where your manual build
put its libpq.so.  That's evidently not having success getting that
libpq.so to be used.  Did you tell configure to --disable-rpath?
Or maybe move the installation after building it?

                        regards, tom lane


--
 GnuPG/PGP key: 0xDD4276BA
 +-----------------------------------------------------------------------------------------------------+
 | 3.14159 26535 89793 23846 26433 83279 50288 41971 69399 37510          |
 |   58209 74944[59230 78164]06286 20899 86280 +----------------------------------|
 |   34825 34211 70679*82148 08651 32823 06647 |    May the spirit                |
 |   09384 46095 50582 23172 53594 08128 48111  |      of π spread                |
 |   74502 84102 70193 85211 05559 64462 29489 |    around the world.         |
 |   54930 38196 44288 10975 66593 34461 28475 |      PI VOBISCUM!          |
 |   38196 44288 10975 66593 34461 28475 64823 +---------------------------------|
 |   37867 83165 27120 19091 45648 56692 34603 48610 45432 6648...         |
 +----------------------------------------------------------------------------------------------------+

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: md5 issues Postgres14 on OL7
Next
From: Michael Paquier
Date:
Subject: Re: md5 issues Postgres14 on OL7