Postgres Pro
Downloads
Home   >   mailing lists

Thread: problem creating user

problem creating user

From
kandiah ratnavale
Date:
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

Re: problem creating user

From
postgres@jal.org
Date:
On Mon, 12 Jan 2004, kandiah ratnavale wrote:

> -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?

You are confusing OS users with postgres users.

Createuser makes a postgres user; making OS users depends on your
flavour of unix, but useradd will probably work for you.

'man useradd'.

-j



--
Jamie Lawrence                                        jal@jal.org
"In my little way, I'm sneakily helping people understand a bit more
about the sort of people God likes."
   - Larry Wall.

Re: problem creating user

From
Manuel Sugawara
Date:
kandiah ratnavale <ratnavale@shaw.ca> writes:

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

You are confusing unix users with postgres users. They are different
so the su command does not work. You can use the -U switch to psql to
connect as another user

psql -U bruce -d movies

Read the psql(1) and createuser(1) manual pages for details.

Regards,
Manuel.