On 5/9/07, Tom Lane <[EMAIL PROTECTED]> wrote:
"Wade Hampton" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
