From: Tom Lane <tgl@sss.pgh.pa.us>
To: Adnan Dautovic <daut@mailbox.org>
cc: Adrian Klaver <adrian.klaver@aklaver.com>, pgsql-general@postgresql.org
Subject: Re: Failure of postgres_fdw because of TimeZone setting
In-reply-to: <0849E257-0A15-4C2F-A41B-7E0E4B716CAE@mailbox.org>
References: <5DF49366-10D1-42A4-99BF-F9A7DC3AB0F4@mailbox.org> <faf7d602-57b6-47de-87ab-a61baa9ccca1@aklaver.com> <0849E257-0A15-4C2F-A41B-7E0E4B716CAE@mailbox.org>
Comments: In-reply-to Adnan Dautovic <daut@mailbox.org>
	message dated "Fri, 05 Apr 2024 11:39:04 +0200"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <1273541.1712326418.1@sss.pgh.pa.us>
Date: Fri, 05 Apr 2024 10:13:38 -0400
Message-ID: <1273542.1712326418@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/1273542.1712326418%40sss.pgh.pa.us>
Precedence: bulk

Adnan Dautovic <daut@mailbox.org> writes:
> However, this lead me to [2] and I find the output very
> interesting:

> SELECT * FROM pg_timezone_names ORDER BY name;

>> "name"	"abbrev"	"utc_offset"	"is_dst"
>> "Turkey"	"+03"	"03:00:00"	false
>> "UCT"	"UCT"	"00:00:00"	false
>> "Universal"	"UTC"	"00:00:00"	false
>> "W-SU"	"MSK"	"03:00:00"	false

Wow.  To clarify, is that the *whole* result?
But even if you just excerpted it, you're clearly
missing a lot of entries.

Per your other answer, the remote DB doesn't seem to have
been built with --with-system-tzdata, so it must be relying
on a Postgres-private copy of the tzdb data set, and evidently
a fair number of entries in that have gone missing.  Postgres
itself would never modify that data after installation, so
we're left to speculate about filesystem corruption or
somebody's odd desire to remove "unnecessary" files.

Out of curiosity, does
	SET timezone to 'GMT';
work?

			regards, tom lane