Received: from news.tht.net (news.hub.org [216.126.91.242])
	by postgresql.org (8.11.3/8.11.4) with ESMTP id f8GF3Q736085;
	Sun, 16 Sep 2001 11:03:26 -0400 (EDT)
	(envelope-from news@news.tht.net)
Received: (from news@localhost)
	by news.tht.net (8.11.4/8.11.4) id f8GEd2J30420;
	Sun, 16 Sep 2001 10:39:02 -0400 (EDT) (envelope-from news)
From: "TeuK" <humpf@yahoo.fr>
X-Newsgroups: comp.databases.postgresql.docs,
	comp.databases.postgresql.questions, linux.postgres
Subject: Re: adding a superuser
Date: Sun, 16 Sep 2001 16:38:51 +0200
Organization: Club-Internet (France)
Lines: 32
Message-ID: <9o2dhq$gc$1@front4m.grolier.fr>
References: <_pQo7.71168$xb.37085264@news1.mntp1.il.home.com>
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
To: pgsql-docs@postgresql.org.pgsql-general@postgresql.org
X-Archive-Number: 200109/37
X-Sequence-Number: 969

I think user root is not known in Postgres user and that's why you want to
add it (;

try :

createuser -d -a -U postgres root

As a rule postgres is running under postgres user account that is a
superuser.

So try psl -U postgres
"Karl Babcock" <karl@knbenterprises.com> a écrit dans le message news:
_pQo7.71168$xb.37085264@news1.mntp1.il.home.com...
> 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
>
>