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 "systemctl reload > postgresql-9.3" to make it effective? > Or a complete restart is required?
First a side note, if you work with systems and people in more than one time zone, I strongly recommend and it will make your life much simpler if you configure all your servers in UTC (looking at logs, reasoning about automated/cron jobs etc...). Note that you can set the timezone on a per session basis with `set timezone="America/Sao_Paulo"`. Now if you do want to work in local time zone, so America/Sao Paulo in your case: If the timezone is set correctly, we do not need to re-start anything when the DST switch happens. Postgresql will follow the time zone set at the OS level, run the command `timedatectl` to check if your RedHat is set to what you expect. In postgres, use `show timezone` and verify that it says "localtime". If you want postgres to use at a different time zone than the OS, then do configure timezone in postgresql.conf, and yes you will need to restart postgres once you have made that change. -- http://yves.zioup.com gpg: 4096R/32B0F416 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
