Re: PostgreSQL Timezone and Brazilian DST

Поиск
Список
Период
Сортировка
От Edson Richter
Тема Re: PostgreSQL Timezone and Brazilian DST
Дата
Msg-id BLU436-SMTP1250D5073BA3FFCE078437ACF210@phx.gbl
обсуждение исходный текст
Ответ на Re: PostgreSQL Timezone and Brazilian DST  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Thanks, Tom.
I'll play a bit with this in a development server.


Regards,

Atenciosamente,

Edson Carlos Ericksson Richter

Em 28/10/2015 12:06, Tom Lane escreveu:
> Adrian Klaver <adrian.klaver@aklaver.com> writes:
>> No, if the above does not indicate a problem, then the issue is
>> probably, as Francisco said, in the timezone definitions. The thing is,
>> you are on 9.3.10 which has the latest time zone data file:
> Since OEL is a naked ripoff of Red Hat, I would assume that they configure
> Postgres the same way Red Hat does, ie --with-system-tzdata.  So what will
> matter in that respect is whether your "tzdata" package is up to date, not
> which PG version you're running.
>
> However, AFAICT the spring DST transition rule in Brazil hasn't changed
> since 2008 or so, so it seems rather unlikely that anybody would have
> tzdata old enough for that to be a problem.
>
> I'm betting the OP simply didn't have Postgres' timezone parameter set
> properly.  Yes, that can be fixed with a reload (as a moment's
> experimentation would have shown).
>
>             regards, tom lane
>
>



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

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: Waiting on ExclusiveLock on extension 9.3, 9.4 and 9.5
Следующее
От: Edson Richter
Дата:
Сообщение: Re: PostgreSQL Timezone and Brazilian DST