Topic: how to start postgresql after installation?

[allan tong]

Hi All,
new to linux, but successfully installd and run sme .
now need to install postgress for a web application.

the following 3 rpms seen to install easyly ,

postgresql-7.0.3-8.i386.rpm
postgresql-devel-7.0.3-8.i386.rpm
postgresql-server-7.0.3-8.i386.rpm


but after that i can not start postgresql , because i can not adduser to postgres. and login as user to sme.

from the postgres site , the following would start it.
/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data

and i have changed it to the following for sme

/usr/bin/initdb -D /home/e-smith/files/ibays/html/app-name/data

but it return and said it can not run in root, need to create a user.

any help please.
thanks in advance.

allan