Hi,
How/Where does PostgreSQL set or determine the local time zone?
On my server, I am seeing (+00):
db= SELECT now();
now
---
2009-03-23 22:32:47.595491+00
(1 row)
But on my workstation I am seeing (-04):
db= SELECT now();
now
Madison Kelly li...@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
Tom Lane wrote:
Madison Kelly li...@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
On Mon, Mar 23, 2009 at 6:14 PM, Madison Kelly li...@alteeve.com wrote:
Tom Lane wrote:
Madison Kelly li...@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
Madison Kelly li...@alteeve.com writes:
Server (PostgreSQL 8.1):
$ date
Mon Mar 23 20:07:20 EDT 2009
db= show timezone;
TimeZone
--
GMT
(1 row)
Hmm. Apparently, this machine is configured so that TZ is set properly
in the environment of user login processes (perhaps in