database cluster for general user

[teguh]

Hi all...


please help me, I'm a newbie...
I'm using centos 5.1 on 64 bit architcture and postgresql 8.1. Actually there is alredy postgres user, but i want my general user can create their selves database cluster.
when one of the user run initdb to directory which have been created the process is running well and gave success message.
Then he run pg_ctl to my data directory (

pg_ctl -D data -l logfile start

) after change port number which different with default postgresql port in postgresql.conf file and he get message that the postmaster is starting.
then he run psql and get this message:

psql: FATAL:  database "[user_nama]" does not exist

and he try run createdb test he get these message:

createdb: could not connect to database postgres: FATAL:  role "[user_nama]" does not exist

am I miss some setting?

additional question:
before, I using debian and there is pg_createcluster command in the same version of postgresql. But i can't find this one on CentOS. Is there additional package for enable the cluster related command?



best regard,




teguh wahyu

[rski]

Hi all...


please help me, I'm a newbie...
I'm using centos 5.1 on 64 bit architcture and postgresql 8.1. Actually there is alredy postgres user, but i want my general user can create their selves database cluster.
when one of the user run initdb to directory which have been created the process is running well and gave success message.
Then he run pg_ctl to my data directory (

pg_ctl -D data -l logfile start

) after change port number which different with default postgresql port in postgresql.conf file and he get message that the postmaster is starting.
then he run psql and get this message:

psql: FATAL:  database "[user_nama]" does not exist

and he try run createdb test he get these message:

createdb: could not connect to database postgres: FATAL:  role "[user_nama]" does not exist

am I miss some setting?

additional question:
before, I using debian and there is pg_createcluster command in the same version of postgresql. But i can't find this one on CentOS. Is there additional package for enable the cluster related command?



best regard,

teguh wahyu

create database user user_nama using command
createuser user_nama