On 5/9/07, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> "Wade Hampton" <wadehamptoniv@gmail.com> writes:
> > On my CentOS 5.0 box with the RHEL version of Postgresql 8.4.2, the
> > initial initdb step fails with the error
>
> > "WARNING: cold not read time zone file "Default" : permission denied.
> > FATAL: invalid value for parameter "timezone_abbreviations": "Default"
>
> "8.4.2"? Did this message fall through a time warp?
Oops, 8.2.4, my bad.
> Anyway, having been burnt before I always wonder about SELinux whenever
> any strange permission failures turn up on recent RHEL/Fedora systems.
> Look in /var/log/messages to see if there's an "avc denied" log entry
> corresponding to this, or temporarily turn off SELinux with
> /usr/sbin/setenforce and see if it works then.
SELinux is off and there were no avc denied messages in /var/log/messages....
>
> If it is SELinux preventing the access, you probably need to run
> restorecon to fix the SELinux labels on these files. If it still
> doesn't work after that, file a bug report against the selinux policy
> module.
I ran strace on it and it dies at the same place each time:
su postgres -c "strace initdb -D /var/lib/pgsql/data"
..
write(4, "insert OID = 1153 (timestampz_"...., 116WARNING: could
not read.....
... = -1 EPIPE (Broken pipe)
/etc/localtime is:
TZif2\0... UTC... UTC0
locale is en_US.UTF-8
I am downloading the source rpm and building RPMS specifically for
CentOS 5 to see if it helps.
Thanks,
--
Wade Hampton