problem creating user

From: kandiah ratnavale <ratnavale(at)shaw(dot)ca>
To: pgsql-admin(at)postgresql(dot)org
Subject: problem creating user
Date: 2004-01-12 08:27:15
Message-ID: 1073896035.8876.14.camel@h24-86-62-153.vc.shawcable.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

VERY, VERY URGENT!!

Below is a transcript of an attempt to create a user, which I trust
will be self explanatory.

Who do you think I should go to discuss this problem?

Is there a users' group in which I can post this problem for discussion?

Please help me?

-bash-2.05b$ createuser bruce
Shall the new user be allowed to create databases? (y/n) y
Shall the new user be allowed to create more new users? (y/n) y
CREATE USER
-bash-2.05b$ psql -d movies
Welcome to psql 7.3.2, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit

movies=# /q
movies-# \q
-bash-2.05b$ whoami
postgres
-bash-2.05b$ su - bruce
su: user bruce does not exist
-bash-2.05b$ createuser bruce
Shall the new user be allowed to create databases? (y/n)
Shall the new user be allowed to create more new users? (y/n) y
ERROR: CREATE USER: user name "bruce" already exists
createuser: creation of user "bruce" failed
-bash-2.05b$ su - bruce
su: user bruce does not exist
-bash-2.05b$ whoami
postgres
-bash-2.05b$

could you please tell me what is wrong here?
how would i change to user bruce?

is this a bug or am i doing something wrong?

looking forward to your comments and help,

If you cannot help me, please indicate where else I can go?

ratnavale

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Alexey Bobkov 2004-01-12 11:45:16 pg_dump/pg_restore
Previous Message Russell Shaw 2004-01-12 02:14:20 Cluster in users home