Re: Determining/Setting a server's time zone

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Madison Kelly <linux(at)alteeve(dot)com>
Cc: postgres list <pgsql-general(at)postgresql(dot)org>
Subject: Re: Determining/Setting a server's time zone
Date: 2009-03-23 23:33:18
Message-ID: 4919.1237851198@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Madison Kelly <linux(at)alteeve(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alban Hertroys 2009-03-23 23:39:49 Re: text column constraint, newbie question
Previous Message Tom Lane 2009-03-23 23:26:59 Re: 1- and 2-dimensional indexes on same column: why is the 2d one preferred?