Re: here does postgres take its timezone information from?

Поиск
Список
Период
Сортировка
От Andrew Gierth
Тема Re: here does postgres take its timezone information from?
Дата
Msg-id 87zhgu1adu.fsf@news-spur.riddles.org.uk
обсуждение исходный текст
Ответ на Re: here does postgres take its timezone information from?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: here does postgres take its timezone information from?
Список pgsql-general
>>>>> "Tom" == Tom Lane <tgl@sss.pgh.pa.us> writes:

 >>> 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?

 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!

-- 
Andrew (irc:RhodiumToad)



В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Function's execute overhead reducing
Следующее
От: Ivan Sergio Borgonovo
Дата:
Сообщение: Re: porting horde to Postgresql 12, dropped pg_attrdef