Postgres Pro
Downloads
Home   >   mailing lists

Thread: Installation docs wrong?

Installation docs wrong?

From
Christopher Kings-Lynne
Date:
On this page:

http://www.postgresql.org/docs/8.0/interactive/creating-cluster.html

It has this sequence:

root# mkdir /usr/local/pgsql/data
root# chown postgres /usr/local/pgsql/data
root# su postgres
postgres$ initdb -D /usr/local/pgsql/data

However, initdb will fail in this case, since the /usr/local/pgsql dir 
is NOT owned by postgres.  (This came up on IRC helping someone)

Should it in fact be:

root# chown -R postgres /usr/local/pgsql


Chris

Re: Installation docs wrong?

From
Christopher Kings-Lynne
Date:
Sorry, on further investigation this seems to work for everyone except 
that guy - weird.

Chris

Christopher Kings-Lynne wrote:
> On this page:
> 
> http://www.postgresql.org/docs/8.0/interactive/creating-cluster.html
> 
> It has this sequence:
> 
> root# mkdir /usr/local/pgsql/data
> root# chown postgres /usr/local/pgsql/data
> root# su postgres
> postgres$ initdb -D /usr/local/pgsql/data
> 
> However, initdb will fail in this case, since the /usr/local/pgsql dir 
> is NOT owned by postgres.  (This came up on IRC helping someone)
> 
> Should it in fact be:
> 
> root# chown -R postgres /usr/local/pgsql
> 
> 
> Chris
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

Re: Installation docs wrong?

From
Michael Fuhr
Date:
On Fri, Mar 25, 2005 at 12:30:46PM +0800, Christopher Kings-Lynne wrote:

> root# mkdir /usr/local/pgsql/data
> root# chown postgres /usr/local/pgsql/data
> root# su postgres
> postgres$ initdb -D /usr/local/pgsql/data
> 
> However, initdb will fail in this case, since the /usr/local/pgsql dir 
> is NOT owned by postgres.  (This came up on IRC helping someone)

This should work.  What's the exact error?  Have you check the
permissions on all parent directories?  What's the output of the
following command?

ls -ld / /usr /usr/local /usr/local/pgsql /usr/local/pgsql/data

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/

Re: Installation docs wrong?

From
Tom Lane
Date:
Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
> On this page:
> http://www.postgresql.org/docs/8.0/interactive/creating-cluster.html

> It has this sequence:

> root# mkdir /usr/local/pgsql/data
> root# chown postgres /usr/local/pgsql/data
> root# su postgres
> postgres$ initdb -D /usr/local/pgsql/data

> However, initdb will fail in this case, since the /usr/local/pgsql dir 
> is NOT owned by postgres.  (This came up on IRC helping someone)

That doesn't matter per se.  But I wonder if /usr/local/pgsql was set up
as not world readable.
        regards, tom lane