"Scott Marlowe" <scott.marlowe@gmail.com> 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