From: | Edson Richter <edsonrichter(at)hotmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
Subject: | Re: PostgreSQL Timezone and Brazilian DST |
Date: | 2015-10-28 05:43:49 |
Message-ID: | COL402-EAS376B9007C89CAC3863B64A4CF210@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
---- 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"
> >
> > Since DST is in place in Brazil, it is enough to "systemctl reload
> > postgresql-9.3" to make it effective?
>
> Are you saying that you just changed the timezone setting or that time
> in Brazil just went from standard time to DST and you want to know
> whether Postgres will automatically pick that up with the existing
> setting as above?
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.
I just want to know if reload or restart is enough to make Postgres get into track.
Thanks,
Edson
>
> > Or a complete restart is required?
> >
> > Thanks,
> >
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
From | Date | Subject | |
---|---|---|---|
Next Message | 657985552@qq.com | 2015-10-28 07:12:15 | Re: Re: [GENERAL] 回复: postgres cpu 100% need help |
Previous Message | Adrian Klaver | 2015-10-28 04:11:18 | Re: PostgreSQL Timezone and Brazilian DST |