Re: here does postgres take its timezone information from?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
Cc: Palle Girgensohn <girgen(at)pingpong(dot)net>, Thomas Munro <thomas(dot)munro(at)gmail(dot)com>, 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-18 01:40:38
Message-ID: 24057.1574041238@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk> writes:
> Tom> I think the "official" name of that zone is America/Los_Angeles.
> Tom> But initdb might seize on the US/Pacific alias, if available,

> And now you know why I have been saying for so many years that initdb
> should use the official names!

[ shrug... ] The installed format doesn't provide any way to
distinguish which are the "official" names. They're typically
all hardlinks to the same file.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Gierth 2019-11-18 01:56:14 Re: here does postgres take its timezone information from?
Previous Message Ivan Sergio Borgonovo 2019-11-18 00:29:44 Re: porting horde to Postgresql 12, dropped pg_attrdef