Z
Z
zencd2014-10-21 21:20:55
PostgreSQL
zencd, 2014-10-21 21:20:55

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

1 answer(s)
R
red_led, 2014-10-22
@red_led

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 question

Ask a Question

731 491 924 answers to any question