Madison Kelly 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 /etc/profil
On Mon, Mar 23, 2009 at 6:14 PM, Madison Kelly wrote:
> Tom Lane wrote:
>>
>> Madison Kelly 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
Tom Lane wrote:
Madison Kelly 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 e
Madison Kelly 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 th
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
---
