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.