Re: adding a superuser
Re: adding a superuser
От:
Arne Weiner <aswr@gmx.de>
Дата:
Karl Babcock wrote: > > Hi, I have just installed PostgreSQL 7.1 and am having a hard time adding > users. I am trying to add a superuser but I keep getting errors with the > createuser script. > > I am user 'root' on the Linux system when I run: > > lightning:/# createuser -d -a root > psql: FATAL 1: user "root" does not exist > createuser: creation of user "root failed > > Does anyone know how I could create a superuser or any user? > > Thanks in advance, > > Karl You have to supply the -U option if you specify the username in the command line. createuser -d -a -U root Or you just say: createuser -d -a and you will be prompted for username. Arne Weiner.