Thread: Issue with Centos 5, Postgres 8.3 (RHEL5 build), timezones

Issue with Centos 5, Postgres 8.3 (RHEL5 build), timezones

From
"Wade Hampton"
Date:
Greetings!  I am really excited about trying 8.3 for the speedups,
autovacuum, and UUID support.

I am currently testing Postgresql 8.3 on Centos 5.  When I try to run
service postgresql initdb, I get the following error:

WARNING:  could not read time zone file "Default": Permission denied
FATAL:  invalid value for parameter "timezone_abbreviation": "Default"

Which file is it trying to read and how can I fix this?

Thanks,
--
Wade Hampton

Re: Issue with Centos 5, Postgres 8.3 (RHEL5 build), timezones

From
Tom Lane
Date:
"Wade Hampton" <wadehamptoniv@gmail.com> writes:
> I am currently testing Postgresql 8.3 on Centos 5.  When I try to run
> service postgresql initdb, I get the following error:

> WARNING:  could not read time zone file "Default": Permission denied
> FATAL:  invalid value for parameter "timezone_abbreviation": "Default"

> Which file is it trying to read and how can I fix this?

$sharedir/timezonesets/Default --- if you're not sure where $sharedir
is, "pg_config --sharedir" will tell you.

I'd venture it's either a directory ownership/permissions problem or
an obsolete selinux policy ...

            regards, tom lane