problem creating user

[p***@jal.org]

-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.org
"In my little way, I'm sneakily helping people understand a bit more
about the sort of people God likes."
- Larry Wall.



---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[Manuel Sugawara]

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.

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ***@postgresql.org

[Martinelli Paolo A.]

With "createuser bruce" you have created a user in the PostgreSQL environment while using the bash command "su - bruce" you are switching user in the SO (i.e. Linux) environment.

You can solve your problem either using bash the command "adduser bruce" to create the same user also in the OS or connecting to PostgreSQL using "psql -d DBName -U UserName".

Bye,

Paolo
________________________________

Da: pgsql-admin-***@postgresql.org per conto di kandiah ratnavale
Inviato: lun 1/12/2004 09:27
A: pgsql-***@postgresql.org
Oggetto: [ADMIN] problem creating user


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



---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ***@postgresql.org)



---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend