Determining/Setting a server's time zone - Mailing list pgsql-general

From Madison Kelly
Subject Determining/Setting a server's time zone
Date
Msg-id 49C811B2.8030302@alteeve.com
Whole thread Raw
Responses Re: Determining/Setting a server's time zone  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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
-------------------------------
  2009-03-23 18:16:36.591653-04
(1 row)

   The only thing I can think of is that my server is set to believe the
BIOS time is UTC and my workstation is set to EDT. Does PostgreSQL check
this from the host machine?

   For reference, my server is Debian Sarge (4.0) and my workstation is
Ubuntu 8.10.

Thanks!

Madi

pgsql-general by date:

Previous
From: "Leif B. Kristensen"
Date:
Subject: Re: PostgreSQL versus MySQL for GPS Data
Next
From: Ivan Sergio Borgonovo
Date:
Subject: Re: text column constraint, newbie question