Feedback-ID: i76984098:Fastmail
Message-ID: <6f432420-cb0e-4e2f-943c-26be2579bf53@aklaver.com>
Date: Wed, 10 Apr 2024 14:25:38 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Failure of postgres_fdw because of TimeZone setting
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Adnan Dautovic <daut@mailbox.org>, pgsql-general@postgresql.org
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>
 <4179143.1712781094@sss.pgh.pa.us>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <4179143.1712781094@sss.pgh.pa.us>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: <https://www.postgresql.org/message-id/6f432420-cb0e-4e2f-943c-26be2579bf53%40aklaver.com>
Precedence: bulk


On 4/10/24 1:31 PM, Tom Lane wrote:
> 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.

It's the PGDG package running on Ubuntu 22.04.

> 
> 			regards, tom lane

-- 
Adrian Klaver
adrian.klaver@aklaver.com