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@xxxxxxxxxxxxx> wrote:
"Theodore M Rolle, Jr." <stercor@xxxxxxxxx> 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... |
+----------------------------------------------------------------------------------------------------+
