[BUGS] BUG #6488: Installation instructions slightly wrong.

2012-02-26 Thread linehanp
The following bug has been logged on the website:

Bug reference:  6488
Logged by:  Paul Linehan
Email address:  lineh...@tcd.ie
PostgreSQL version: 9.1.2
Operating system:   Linux (Ubuntu 10.04)
Description:


The short version of the instructions say


Short Version

./configure
gmake
su
gmake install
adduser postgres
mkdir /usr/local/pgsql/data
chown postgres /usr/local/pgsql/data
su - postgres
/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
/usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data >logfile 2>&1 &
/usr/local/pgsql/bin/createdb test
/usr/local/pgsql/bin/psql test
=

but, there should be an "exit" between
the lines
chown postgres /usr/local/pgsql/data
su - postgres
otherwise, the system gets confused with
file permissions for the data directory
and throws the error 
==
FATAL:  data directory "/usr/local/pgsql/data" has group or world access
==

Should you require any further 
information, please don't hesitate
to contact me.

Rgs,

Paul...




-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs


Re: [BUGS] BUG #6488: Installation instructions slightly wrong.

2012-02-26 Thread Tom Lane
lineh...@tcd.ie writes:
> The short version of the instructions say

> 
> Short Version

> ./configure
> gmake
> su
> gmake install
> adduser postgres
> mkdir /usr/local/pgsql/data
> chown postgres /usr/local/pgsql/data
> su - postgres
> /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
> /usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data >logfile 2>&1 &
> /usr/local/pgsql/bin/createdb test
> /usr/local/pgsql/bin/psql test
> =

> but, there should be an "exit" between
> the lines
> chown postgres /usr/local/pgsql/data
> su - postgres
> otherwise, the system gets confused with
> file permissions for the data directory
> and throws the error 
> ==
> FATAL:  data directory "/usr/local/pgsql/data" has group or world access
> ==

You more than likely will have to adjust the permissions on the data
directory when following this recipe, but I don't see how exiting from
the first "su" there would fix it.  All it's likely to do is add extra
steps because you no longer have root permissions to do the second "su"
with.

regards, tom lane

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs