Perfect explanation and indeed useful suggestions.
I'll play a bit with a development server.
Thanks,
Atenciosamente,
Edson Carlos Ericksson Richter
Em 28/10/2015 12:15, Yves Dorfsman escreveu:
On 2015-10-27 20:29, Edson Richter wrote:
Hi!
Using PostgreSQL 9.3.10 x86_64 Oracle EL7 compiled
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 writes:
No, if the above does not indicate a problem, then the issue is
probably, as Francisco said, in the timezone
On 2015-10-27 20:29, Edson Richter wrote:
> Hi!
>
> Using PostgreSQL 9.3.10 x86_64 Oracle EL7 compiled by gcc (GCC) 4.8.3
> 20140911, installed using yum repository.
>
> In postgresql.conf, I do have:
>
> timezone="America/Sao_Paulo"
>
> Since DST is in place in Brazil, it is enough to "systemc
Adrian Klaver 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 config
On 10/27/2015 10:43 PM, Edson Richter wrote:
Adrian Klaver escreveu
> On 10/27/2015 07:29 PM, Edson Richter wrote:
> > Hi!
> >
> > Using PostgreSQL 9.3.10 x86_64 Oracle EL7 compiled by gcc (GCC) 4.8.3
> > 20140911, installed using yum repository.
> >
> > In postgresql.conf, I do
On Wed, Oct 28, 2015 at 6:43 AM, Edson Richter wrote:
> Configured since first setup. Brazil went DST few days ago.
> Today, executing
> Select now()
> Resulted in
>
> 2015-10-28 02:45:37-03:00
>
> I do expect
>
> 2015-10-28 03:45:37-02:00
>
> I suspect that Postgres is ignoring the DST change.
Adrian Klaver escreveu
> On 10/27/2015 07:29 PM, Edson Richter wrote:
> > Hi!
> >
> > Using PostgreSQL 9.3.10 x86_64 Oracle EL7 compiled by gcc (GCC) 4.8.3
> > 20140911, installed using yum repository.
> >
> > In postgresql.conf, I do have:
> >
> > timezone="America/Sao_Paulo"
> >
> >
On 10/27/2015 07:29 PM, Edson Richter wrote:
Hi!
Using PostgreSQL 9.3.10 x86_64 Oracle EL7 compiled by gcc (GCC) 4.8.3
20140911, installed using yum repository.
In postgresql.conf, I do have:
timezone="America/Sao_Paulo"
Since DST is in place in Brazil, it is enough to "systemctl reload
postg
Hi!
Using PostgreSQL 9.3.10 x86_64 Oracle EL7 compiled by gcc (GCC) 4.8.3
20140911, installed using yum repository.
In postgresql.conf, I do have:
timezone="America/Sao_Paulo"
Since DST is in place in Brazil, it is enough to "systemctl reload
postgresql-9.3" to make it effective?
Or a comp
