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 [EMAIL PROTECTED] "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
