"Scott Marlowe" <[EMAIL PROTECTED]> writes: > Weirdly, I'm getting the right offsets, but my timezone in pgsql is > navajo... For the OS it's America/Denver like I set it. And there's > no timezone set in postgresql.conf.
According to the TZ files, "Navajo" is just an alias for "America/Denver": Link America/Denver Navajo IIRC we have the TZ-intuiting code set to prefer shorter names when it has two equally good matches to the system's timezone behavior, so that's why it's picking "Navajo". regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general