From: | Christoph Berg <myon(at)debian(dot)org> |
---|---|
To: | Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com> |
Cc: | Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Collation versioning |
Date: | 2018-09-05 10:35:25 |
Message-ID: | 20180905103524.GA13620@msg.df7cb.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Re: Thomas Munro 2018-09-04 <CAEepm=0uEQCpfq_+LYFBdArCe4Ot98t1aR4eYiYTe=yavQygiQ(at)mail(dot)gmail(dot)com>
> I was reminded about that by recent news
> about an upcoming glibc/CLDR resync that is likely to affect
> PostgreSQL users (though, I guess, probably only when they do a major
> OS upgrade).
Or replicating/restoring a database to a newer host.
> ... or, on a Debian system using the locales package, like this:
>
> libc_collation_version_command = 'dpkg -s locales | grep Version: |
> sed "s/Version: //"'
Ugh. This sounds horribly easy to get wrong on the user side. I could
of course put that preconfigured into the Debian packages, but that
would leave everyone not using any of the standard distro packagings
in the rain.
> Does anyone know
> of a way to extract a version string from glibc using existing
> interfaces? I heard there was an undocumented way but I haven't been
> able to find it -- probably because I was, erm, looking in the
> documentation.
That sounds more robust. Googling around:
https://www.linuxquestions.org/questions/linux-software-2/how-to-check-glibc-version-263103/
#include <stdio.h>
#include <gnu/libc-version.h>
int main (void) { puts (gnu_get_libc_version ()); return 0; }
$ ./a.out
2.27
Hopefully that version info is fine-grained enough.
Christoph
From | Date | Subject | |
---|---|---|---|
Next Message | Etsuro Fujita | 2018-09-05 11:02:04 | Re: Problem while updating a foreign table pointing to a partitioned table on foreign server |
Previous Message | Victor Spirin | 2018-09-05 10:06:06 | PostgreSQL does not start when max_files_per_process> 1200 on Windows 7 |