On 3/17/20 8:57 AM, Björn Lundin wrote:
I am still not sure that this can be marked solved. I am trying to
figure out how running a different version of psql once can affect
another version of psql. That would seem to imply psql changed
something on the server and AFAIK sorting/ordering is done by the
server not the client.
Ok if you want, I can
* keep the server as is
* give you ssh access to it
Well, some digging around at the above confirmed that the date sorting
is working correctly now. The only thing I could find is what I take to
be a discrepancy between the 9.4 and 9.6 instances of psql. Namely that
the 9.4 instance does not have a link to libm:
linux-vdso.so.1 (0x00007ffc381f5000)
libpq.so.5 => /usr/lib/x86_64-linux-gnu/libpq.so.5 (0x00007fd35f958000)
libssl.so.1.0.0 => /usr/lib/x86_64-linux-gnu/libssl.so.1.0.0
(0x00007fd35f6f7000)
libedit.so.2 => /usr/lib/x86_64-linux-gnu/libedit.so.2 (0x00007fd35f4bf000)
libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007fd35f120000)
libssl.so.1.1 => /usr/lib/x86_64-linux-gnu/libssl.so.1.1
(0x00007fd35eeb4000)
libcrypto.so.1.1 => /usr/lib/x86_64-linux-gnu/libcrypto.so.1.1
(0x00007fd35ea1a000)
libgssapi_krb5.so.2 => /usr/lib/x86_64-linux-gnu/libgssapi_krb5.so.2
(0x00007fd35e7cf000)
libldap_r-2.4.so.2 => /usr/lib/x86_64-linux-gnu/libldap_r-2.4.so.2
(0x00007fd35e57e000)
libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0
(0x00007fd35e361000)
libcrypto.so.1.0.0 => /usr/lib/x86_64-linux-gnu/libcrypto.so.1.0.0
(0x00007fd35df65000)
libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x00007fd35dd61000)
libncurses.so.5 => /lib/x86_64-linux-gnu/libncurses.so.5
(0x00007fd35db3e000)
libtinfo.so.5 => /lib/x86_64-linux-gnu/libtinfo.so.5 (0x00007fd35d914000)
libbsd.so.0 => /lib/x86_64-linux-gnu/libbsd.so.0 (0x00007fd35d6fe000)
/lib64/ld-linux-x86-64.so.2 (0x00007fd35fe07000)
libkrb5.so.3 => /usr/lib/x86_64-linux-gnu/libkrb5.so.3 (0x00007fd35d424000)
libk5crypto.so.3 => /usr/lib/x86_64-linux-gnu/libk5crypto.so.3
(0x00007fd35d1f1000)
libcom_err.so.2 => /lib/x86_64-linux-gnu/libcom_err.so.2
(0x00007fd35cfed000)
libkrb5support.so.0 => /usr/lib/x86_64-linux-gnu/libkrb5support.so.0
(0x00007fd35cde1000)
libkeyutils.so.1 => /lib/x86_64-linux-gnu/libkeyutils.so.1
(0x00007fd35cbdd000)
libresolv.so.2 => /lib/x86_64-linux-gnu/libresolv.so.2 (0x00007fd35c9c6000)
liblber-2.4.so.2 => /usr/lib/x86_64-linux-gnu/liblber-2.4.so.2
(0x00007fd35c7b7000)
libsasl2.so.2 => /usr/lib/x86_64-linux-gnu/libsasl2.so.2
(0x00007fd35c59c000)
libgnutls.so.30 => /usr/lib/x86_64-linux-gnu/libgnutls.so.30
(0x00007fd35c203000)
librt.so.1 => /lib/x86_64-linux-gnu/librt.so.1 (0x00007fd35bffb000)
libz.so.1 => /lib/x86_64-linux-gnu/libz.so.1 (0x00007fd35bde1000)
libp11-kit.so.0 => /usr/lib/x86_64-linux-gnu/libp11-kit.so.0
(0x00007fd35bb7c000)
libidn.so.11 => /lib/x86_64-linux-gnu/libidn.so.11 (0x00007fd35b948000)
libtasn1.so.6 => /usr/lib/x86_64-linux-gnu/libtasn1.so.6
(0x00007fd35b735000)
libnettle.so.6 => /usr/lib/x86_64-linux-gnu/libnettle.so.6
(0x00007fd35b4fe000)
libhogweed.so.4 => /usr/lib/x86_64-linux-gnu/libhogweed.so.4
(0x00007fd35b2c9000)
libgmp.so.10 => /usr/lib/x86_64-linux-gnu/libgmp.so.10 (0x00007fd35b046000)
libffi.so.6 => /usr/lib/x86_64-linux-gnu/libffi.so.6 (0x00007fd35ae3d000)
Let me know, and I’ll mail you (privately) login details
I am going to move the data, and I have the whole set of daily pg_dumps
I need to set it up elsewhere.
--
Björn Lundin
b.f.lundin@xxxxxxxxx <mailto:b.f.lundin@xxxxxxxxx>
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
