Skip site navigation (1) Skip section navigation (2)

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

From: Jamie Strachan <frostfreek(at)yahoo(dot)com>
To: Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5430: initdb fails due to permissions of /usr/share/pgsql
Date: 2010-04-20 20:39:12
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
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.


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


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?

PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Repository:
Community:,  Twitter:

In response to


pgsql-bugs by date

Next:From: Devrim GÜNDÜZDate: 2010-04-21 07:42:28
Subject: Re: BUG #5430: initdb fails due to permissions of /usr/share/pgsql
Previous:From: Devrim GÜNDÜZDate: 2010-04-20 19:38:05
Subject: Re: BUG #5430: initdb fails due to permissions of /usr/share/pgsql

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group