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