Unrecognized time zone name: "GMT"

Testing RT 3.8.8 with PostgreSQL 9.0.3, seeing these warnings in the
Apache error log:

[Wed Feb 9 18:46:38 2011] [warning]: DBD::Pg::st execute failed:
ERROR: unrecognized time zone name: “GMT”
(/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:509)
[Wed Feb 9 18:46:38 2011] [warning]: RT::Handle=HASH(0xb14ed7c)
couldn’t execute the query ‘SET TIME ZONE ‘GMT’’ at
/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 522

Looks like these errors occur on every ticket transaction, for example
saving a Comment. I confirmed that correct timestamps are getting
assigned to ticket transactions.

Any ideas are greatly appreciated.

Thanks-

Lee

Testing RT 3.8.8 with PostgreSQL 9.0.3, seeing these warnings in the
Apache error log:

That’s unusual. What timezones does your Pg know about?

-kevin

Great question Kevin, turns out the timezone files were not readable
by postgres. This fix worked:

chmod o+r /usr/local/pgsql/share/timezone/*

Thanks again for your prompt and excellent help.

Lee