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/ ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
