Re: Determining/Setting a server's time zone

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