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