Madison Kelly <linux@xxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
