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@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@selectacast.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