Re: BUG #5430: initdb fails due to permissions of /usr/share/pgsql

I have posted the bug to the RPM maintainers, over at Command Prompt.
So, 5430 can be closed.

This is affecting my CentOS 4 release.
(I have to support RHEL/CentOS 4, 5, and some others too.)

[root(at)isotest ~]# more /etc/redhat-release
Red Hat Enterprise Linux ES release 4 (Nahant Update 3)
[root(at)isotest ~]# rpm -e postgresql-server
[root(at)isotest ~]# rm -fr /usr/share/pgsql/
[root(at)isotest ~]# rpm -i postgresql-server-8.4.3-2PGDG.el4.i386.rpm
warning: postgresql-server-8.4.3-2PGDG.el4.i386.rpm: V3 DSA signature: NOKEY, key ID e8e345b8
[root(at)isotest ~]# ls -ld /usr/share/pgsql/timezone
drwxr-x--- 19 root root 4096 Apr 20 16:27 /usr/share/pgsql/timezone
[root(at)isotest ~]# ls -ld /usr/share/pgsql/timezonesets/
drwxr-x--- 2 root root 4096 Apr 20 16:27 /usr/share/pgsql/timezonesets/

other is denied access.

Thanks,

Jamie Strachan.

----- Original Message ----
From: Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>
To: Jamie Strachan <frostfreek(at)yahoo(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Sent: Tue, April 20, 2010 3:38:05 PM
Subject: Re: [BUGS] BUG #5430: initdb fails due to permissions of /usr/share/pgsql

Hi,

On Mon, 2010-04-19 at 14:22 +0000, Jamie Strachan wrote:
>
> for my CentOS 4 install.
>
> service postgresql initdb fails with no error message.
>
> So, I su'd to postgres, and ran
>
> initdb --pgdata=/var/lib/pgsql/data --auth=ident
> which is what service postgresql initdb does.
> This command failed, with the error message:
>
> could not open directory "/usr/share/pgsql/timezonesets"

Cannot reproduce it on my 8.4+CentOS 4 box:

-bash-3.00$ initdb --pgdata=/var/lib/pgsql/data --auth=ident
...
Success. You can now start the database server using:
...

timezonesets directory has already *enough* permissions for postgres
user to read it:

drwxr-xr-x 2 root root 4096 2010-03-19 09:45 timezonesets

Are you sure that you did not chmod somewhere between installing package
and initdb'ing?

Regards,
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Repository: http://yum.pgrpms.org
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz