By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,515 Members | 1,363 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,515 IT Pros & Developers. It's quick & easy.

database cluster for general user

P: 1
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 (
Expand|Select|Wrap|Line Numbers
  1. 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:
Expand|Select|Wrap|Line Numbers
  1. psql: FATAL:  database "[user_nama]" does not exist
and he try run createdb test he get these message:
Expand|Select|Wrap|Line Numbers
  1. 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
Dec 20 '07 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 700
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 (
Expand|Select|Wrap|Line Numbers
  1. 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:
Expand|Select|Wrap|Line Numbers
  1. psql: FATAL:  database "[user_nama]" does not exist
and he try run createdb test he get these message:
Expand|Select|Wrap|Line Numbers
  1. 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
Dec 20 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.