Received: from news.tht.net (news.hub.org [216.126.91.242])
	by postgresql.org (8.11.3/8.11.4) with ESMTP id f8GA3O762745;
	Sun, 16 Sep 2001 06:03:24 -0400 (EDT)
	(envelope-from news@news.tht.net)
Received: (from news@localhost)
	by news.tht.net (8.11.4/8.11.4) id f8G9oT127027;
	Sun, 16 Sep 2001 05:50:29 -0400 (EDT) (envelope-from news)
From: Arne Weiner <aswr@gmx.de>
X-Newsgroups: comp.databases.postgresql.docs,
	comp.databases.postgresql.questions
Subject: Re: adding a superuser
Date: Sun, 16 Sep 2001 12:01:53 +0200
Organization: Hub.Org Networking Services (http://www.hub.org)
Lines: 31
Message-ID: <3BA47891.C06B247B@gmx.de>
References: <_pQo7.71168$xb.37085264@news1.mntp1.il.home.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Complaints-To: scrappy@hub.org
X-Mailer: Mozilla 4.5 [en] (X11; I; Linux 2.2.18 i586)
X-Accept-Language: en
To: pgsql-docs@postgresql.org.pgsql-general@postgresql.org
X-Archive-Number: 200109/38
X-Sequence-Number: 970

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.