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
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).
On Tue, Jan 4, 2022 at 1:32 PM Tom Lane <t...@sss.pgh.pa.us> wrote:
> "Theodore M Rolle, Jr." <ster...@gmail.com> writes:
> > I don't use pacman for PostgreSQL.
> > I compile from source.
>
> The point is that your from-source build of psql might be linking
> to an out-of-date copy of libpq.so provided by the OS. Linux
> machines tend to do that (i.e., prefer libraries in /usr/lib[64])
> unless you mess with the dynamic loader's configuration.
>
> Try "ldd /path/to/psql" and see what it says about which libpq
> is getting used.
>
> 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... |
+----------------------------------------------------------------------------------------------------+
