Re: Order by and timestamp SOLVED - Mailing list pgsql-general
From | Adrian Klaver |
---|---|
Subject | Re: Order by and timestamp SOLVED |
Date | |
Msg-id | d8e990bb-1d62-6449-cab1-f7f68bb4b08f@aklaver.com Whole thread Raw |
In response to | Re: Order by and timestamp SOLVED (Björn Lundin <b.f.lundin@gmail.com>) |
List | pgsql-general |
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@gmail.com <mailto:b.f.lundin@gmail.com> > > > > -- Adrian Klaver adrian.klaver@aklaver.com
pgsql-general by date: