"Scott Marlowe" <scott.marlowe@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
