Feedback-ID: i131946ab:Fastmail
Message-ID: <b408954e-56ea-f2bc-6749-56c46fd4411e@enterprisedb.com>
Date: Mon, 7 Nov 2022 13:21:52 +0100
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:102.0)
 Gecko/20100101 Thunderbird/102.4.1
Subject: Re: Collation version tracking for macOS
To: Thomas Munro <thomas.munro@gmail.com>
Cc: Jeremy Schneider <schneider@ardentperf.com>, Peter Geoghegan
 <pg@bowt.ie>, "Finnerty, Jim" <jfinnert@amazon.com>,
 "Nasby, Jim" <nasbyj@amazon.com>, Tom Lane <tgl@sss.pgh.pa.us>,
 pgsql-hackers <pgsql-hackers@postgresql.org>
References: <b37c2acd-24f4-07c9-da6e-6fec66137f69@enterprisedb.com>
 <D9EBBA4F-C92C-4B26-AB4D-6038BC52793D@ardentperf.com>
 <398aabd1-ad95-ba2d-d70a-dd5d90bf6e07@enterprisedb.com>
 <CA+hUKGL36vXMfcaDq+U1ZkoSsdfFnNx7GxhGM7aYzEbKs1W0=Q@mail.gmail.com>
 <CA+hUKGKq=iLH3bY+nK7v8b2zBCuKOk-fe0cP0it2RxNaWFVxYA@mail.gmail.com>
 <9f93a7b9-d144-9e48-40ef-36f7593e425e@enterprisedb.com>
 <CA+hUKGLxWZNpvPVuRkiXT9TwDLgHK-hinpZ856o88vVZM7kHzA@mail.gmail.com>
 <CA+hUKGKCbFVBg52gGLo+HUD+NxfJCwaLwbvRDZ+HTFC4MeOk0w@mail.gmail.com>
Content-Language: en-US
From: Peter Eisentraut <peter.eisentraut@enterprisedb.com>
In-Reply-To: 
 <CA+hUKGKCbFVBg52gGLo+HUD+NxfJCwaLwbvRDZ+HTFC4MeOk0w@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: 
 <https://www.postgresql.org/message-id/b408954e-56ea-f2bc-6749-56c46fd4411e%40enterprisedb.com>
Precedence: bulk

On 02.11.22 00:57, Thomas Munro wrote:
> 3.  Library availability.  This is a problem for downstream
> communities to solve.  For example, the people who build Windows
> installers might want to start bundling the ICU versions from their
> earlier releases, the people involved with each Linux/BSD distro would
> hopefully figure out a good way to publish the packages from older OS
> releases in one repo, and the people running managed systems probably
> do their own packaging anyway, they'll figure it out.  I realise that
> you are involved in packaging and I am not, so we probably have
> different perspectives: I get to say "and here, magic happens!" :-)

I made a Homebrew repository for ICU versions 50 through 72: 
https://github.com/petere/homebrew-icu

All of these packages build and pass their self-tests on my machine.  So 
from that experience, I think maintaining a repository of ICU versions, 
and being able to install more than one for testing this feature, is 
feasible.

Now I have started building PostgreSQL against these, to get some 
baseline of what is supported and actually works.  The results are a bit 
mixed so far, more to come later.

The installation instructions currently say that the minimum required 
version of ICU is 4.2.  That was the one that shipped with RHEL 6.  I 
think we have de-supported RHEL 6 and could increase that.  The version 
in RHEL 7 is 50.

(My repository happens to start at 50 because the new versioning system 
started at 49, but 49 doesn't appear to be tagged at the icu github site.)

Note: Recent versions of libxml2 link against icu.  This isn't a 
problem, thanks to the symbol versioning, but if you get libxml2 via 
pkg-config, you might get LDFLAGS from not the icu version you wanted.