Lists: | pgsql-admin |
---|
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 |
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
From: | Manuel Sugawara <masm(at)fciencias(dot)unam(dot)mx> |
---|---|
To: | ratnavale(at)shaw(dot)ca |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: problem creating user |
Date: | 2004-01-16 16:58:54 |
Message-ID: | m3ptdjal8i.fsf@conexa.fciencias.unam.mx |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-admin |
kandiah ratnavale <ratnavale(at)shaw(dot)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.
From: | postgres(at)jal(dot)org |
---|---|
To: | kandiah ratnavale <ratnavale(at)shaw(dot)ca> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: problem creating user |
Date: | 2004-01-16 17:01:44 |
Message-ID: | 20040116170144.GG32160@clueinc.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-admin |
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(at)jal(dot)org
"In my little way, I'm sneakily helping people understand a bit more
about the sort of people God likes."
- Larry Wall.