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 <t...@sss.pgh.pa.us> wrote:
> "Theodore M Rolle, Jr." <ster...@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... |
+----------------------------------------------------------------------------------------------------+
