public inbox for [email protected]
help / color / mirror / Atom feedFrom: Tom Lane <[email protected]>
To: Adnan Dautovic <[email protected]>
Cc: Adrian Klaver <[email protected]>
Cc: [email protected]
Subject: Re: Failure of postgres_fdw because of TimeZone setting
Date: Fri, 05 Apr 2024 10:13:38 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
<[email protected]>
<[email protected]>
Adnan Dautovic <[email protected]> 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
view thread (6+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: Failure of postgres_fdw because of TimeZone setting
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox