Answer the question
In order to leave comments, you need to log in
Do I need to move PostgreSQL to the new time zone on October 26, 2014?
Let's assume arrows are translated in Java , in Debian Wheezy too. With MySQL, they say you need to do passes .
What about PostgreSQL 9 - does it require a separate setup?
Answer the question
In order to leave comments, you need to log in
I understand that postgres has its own database and you need to: 1) update the minor version 2) restart the server.
If the postgres is built with the "--with-system-tzdata=DIR" flag, then it is enough to restart the server after updating tzdata in the system
. Check if something needs to be changed by running SELECT now()+'6 days'::interval;
and looking at the time zone as a result. If you really
want to
hardcode it , you can .SET TIMEZONE TO "+3";
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question