Re: PostgreSQL Timezone and Brazilian DST - Mailing list pgsql-general

From Edson Richter
Subject Re: PostgreSQL Timezone and Brazilian DST
Date
Msg-id BLU436-SMTP1250D5073BA3FFCE078437ACF210@phx.gbl
Whole thread Raw
In response to Re: PostgreSQL Timezone and Brazilian DST  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Jeff Janes
Date:
Subject: Re: Waiting on ExclusiveLock on extension 9.3, 9.4 and 9.5
Next
From: Edson Richter
Date:
Subject: Re: PostgreSQL Timezone and Brazilian DST