On 13/05/2024 00:39, Tom Lane wrote:
> Hm. It occurs to me that there *is* a system-specific component to
> the amount of WAL emitted during initdb: the number of locales
> that "locale -a" prints translates directly to the number of
> rows inserted into pg_collation. [...]
Yes. Another system-specific circumstance affecting WAL position is the
name length of the unix user doing initdb. I've seen 039_end_of_wal
failing consistently under user aaaaaaaa but working fine with aaaa,
both on the same machine at the same time.
To be more precise, on one particular machine under those particular
circumstances (including set of locales) it would work for any username
with length < 8 or >= 16, but would fail for length 8..15 (in bytes, not
characters, if non-ASCII usernames were used).
--
Anton Voloshin
Postgres Professional, The Russian Postgres Company
https://postgrespro.ru