Re: here does postgres take its timezone information from?

From: Thomas Munro <thomas(dot)munro(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Palle Girgensohn <girgen(at)pingpong(dot)net>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, Chris Withers <chris(at)withers(dot)org>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>, "pgsql(at)freebsd(dot)org" <pgsql(at)freebsd(dot)org>
Subject: Re: here does postgres take its timezone information from?
Date: 2019-11-16 22:06:38
Message-ID: CA+hUKG+F8eqWurdBsfgQ7qf=x2MdXQML+_1TUajeDuokjPadBQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sat, Nov 16, 2019 at 7:13 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Palle Girgensohn <girgen(at)pingpong(dot)net> writes:
> > 15 nov. 2019 kl. 21:32 skrev Thomas Munro <thomas(dot)munro(at)gmail(dot)com>:
> >> Ugh. It doesn't have the old backward compatibility names like
> >> US/Pacific installed by default, which is a problem if that's what
> >> initdb picked for your cluster (or you've stored references to any of
> >> those names in other ways).
>
> > One quick fix is to revert the change. Tom thinks this is not reason to revert. Would it be enough to edit the postgresql.conf to use the correct "modern" name for US/Pacific (PST?)? In rhar case, an update note might be sufficient?
>
> I think the "official" name of that zone is America/Los_Angeles.
> But initdb might seize on the US/Pacific alias, if available,
> because it's shorter. We've seen related problems with other
> time zone names, though usually it was just cosmetic and not a
> reason for the postmaster to fail to start.
>
> Yes, changing the zone name in postgresql.conf should be a sufficient
> fix. In theory, a FreeBSD user ought to know the "official" alias
> for their zone, since the rest of the system would expect that.
> So this is slightly tedious if initdb chose a non-official alias,
> but I don't think it's reason to panic.

Perhaps the best thing would be to revert this for the older
PostgreSQL releases so that people doing minor version upgrades are
inconvenienced by a system that can't start up after "pkg upgrade",
but do it for 12 since not many people will be using that yet?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Nicolas Paris 2019-11-16 22:18:50 Re: ERROR: COPY escape must be a single one-byte character (multi-delimiter appears to work on Postgres 9.0 but does not on Postgres 9.2)
Previous Message Josef Šimánek 2019-11-16 17:43:24 Re: REINDEX VERBOSE unknown option