Re: problem creating user

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.