Re: Determining/Setting a server's time zone

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Determining/Setting a server's time zone
Дата
Msg-id 4919.1237851198@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Determining/Setting a server's time zone  (Madison Kelly <linux@alteeve.com>)
Ответы Re: Determining/Setting a server's time zone  (Madison Kelly <linux@alteeve.com>)
Список pgsql-general
Madison Kelly <linux@alteeve.com> writes:
>    How/Where does PostgreSQL set or determine the local time zone?

Well, "show timezone" will tell you what PG is using.  Where it came
from is a bit harder to answer.  The default is to use whatever
zone is current according to the postmaster's startup environment,
and that would depend on some factors you didn't tell us, like
how you're starting the postmaster.  Do your two machines report
the same timezone when you run "date" as a shell command?

The easy solution is to set the value you want in postgresql.conf.

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: 1- and 2-dimensional indexes on same column: why is the 2d one preferred?
Следующее
От: Alban Hertroys
Дата:
Сообщение: Re: text column constraint, newbie question