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@isotest ~]# more /etc/redhat-release=20
Red Hat Enterprise Linux ES release 4 (Nahant Update 3)
[root@isotest ~]# rpm -e postgresql-server
[root@isotest ~]# rm -fr /usr/share/pgsql/
[root@isotest ~]# rpm -i postgresql-server-8.4.3-2PGDG.el4.i386.rpm=20
warning: postgresql-server-8.4.3-2PGDG.el4.i386.rpm: V3 DSA signature: NOKE=
Y, key ID e8e345b8
[root@isotest ~]# ls -ld /usr/share/pgsql/timezone
drwxr-x---  19 root root 4096 Apr 20 16:27 /usr/share/pgsql/timezone
[root@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=C3=9CND=C3=9CZ <devrim@gunduz.org>
To: Jamie Strachan <frostfreek@yahoo.com>
Cc: pgsql-bugs@postgresql.org
Sent: Tue, April 20, 2010 3:38:05 PM
Subject: Re: [BUGS] BUG #5430: initdb fails due to permissions of /usr/shar=
e/pgsql

Hi,

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

Cannot reproduce it on my 8.4+CentOS 4 box:

-bash-3.00$  initdb --pgdata=3D/var/lib/pgsql/data --auth=3Dident
...
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,
--=20
Devrim G=C3=9CND=C3=9CZ
PostgreSQL Dan=C4=B1=C5=9Fman=C4=B1/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