Re: Timezones in 8.2.7

After I sent my last email, a light bulb went off. I remembered a
similar problem I had a while ago with parts of postgres not having read
permission. Sure enough after I

[root(at)xx /usr/local/pgsql]# chmod -R a+r *

then restart postgres everything is fine.

This is a IMHO a bug in the install script. All of the postgres install
should be world readable, regardless of the umask (or at least provide
a warning).

Tom Lane wrote:
> Joseph S <jks(at)selectacast(dot)net> writes:
>> Tom Lane wrote:
>>> Works for me ... what have you got TimeZone set to?
>
>> /etc/localtime -> /usr/share/zoneinfo/US/Eastern
>
> You didn't answer the question: what does "SHOW TimeZone" say?
>
> regards, tom lane