From: Tom Lane <tgl@sss.pgh.pa.us>
To: Adrian Klaver <adrian.klaver@aklaver.com>
cc: Adnan Dautovic <daut@mailbox.org>, pgsql-general@postgresql.org
Subject: Re: Failure of postgres_fdw because of TimeZone setting
In-reply-to: <549c75f4-194e-4de8-aca5-1a5aaa216dd5@aklaver.com>
References: <5DF49366-10D1-42A4-99BF-F9A7DC3AB0F4@mailbox.org> <faf7d602-57b6-47de-87ab-a61baa9ccca1@aklaver.com> <0849E257-0A15-4C2F-A41B-7E0E4B716CAE@mailbox.org> <1273542.1712326418@sss.pgh.pa.us> <98F8816F-0AC2-4308-961F-4C7A4FC2C646@mailbox.org> <549c75f4-194e-4de8-aca5-1a5aaa216dd5@aklaver.com>
Comments: In-reply-to Adrian Klaver <adrian.klaver@aklaver.com>
	message dated "Wed, 10 Apr 2024 13:04:38 -0700"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <4179142.1712781094.1@sss.pgh.pa.us>
Date: Wed, 10 Apr 2024 16:31:34 -0400
Message-ID: <4179143.1712781094@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/4179143.1712781094%40sss.pgh.pa.us>
Precedence: bulk

Adrian Klaver <adrian.klaver@aklaver.com> writes:
> On 4/10/24 12:38, Adnan Dautovic wrote:
>> By the way, the row count of pg_timezone_names is 385, but I do
>> not know how that compares to a more standard installation.

> On my instance of Postgres 16.2, 1196.

You're probably using a build with --with-system-tzdata pointing
at a system tzdata tree that includes leap-second-aware zones.
These tend to have duplicative entries like "America/New_York"
and "posix/America/New_York".  (There's also a subtree like
"right/America/New_York", but we reject those because we don't
do leap seconds.)  The real number of distinct zones in a
standard tzdata file set these days is a shade under 600.

			regards, tom lane