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. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
