From owner-freebsd-questions  Thu Sep 14 21:26:30 2000
Delivered-To: freebsd-questions@freebsd.org
Received: from thelab.hub.org (CDR27-115.accesscable.net [24.138.27.115])
	by hub.freebsd.org (Postfix) with ESMTP id 011A637B422
	for <freebsd-questions@FreeBSD.ORG>; Thu, 14 Sep 2000 21:26:27 -0700 (PDT)
Received: from localhost (scrappy@localhost)
	by thelab.hub.org (8.11.0/8.11.0) with ESMTP id e8F4PmE15831;
	Fri, 15 Sep 2000 01:25:49 -0300 (ADT)
	(envelope-from scrappy@hub.org)
X-Authentication-Warning: thelab.hub.org: scrappy owned process doing -bs
Date: Fri, 15 Sep 2000 01:25:48 -0300 (ADT)
From: The Hermit Hacker <scrappy@hub.org>
To: Danny <dannyh@idx.com.au>
Cc: freebsd-questions@FreeBSD.ORG
Subject: Re: Post Postgresql config problems
In-Reply-To: <0009160112530A.00340@freebsd.freebsd.org>
Message-ID: <Pine.BSF.4.21.0009150124580.94875-100000@thelab.hub.org>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
Sender: owner-freebsd-questions@FreeBSD.ORG
Precedence: bulk
X-Loop: FreeBSD.ORG


you have to do the 'createuser' as the PgSQL "superuser", which, by
default is iether pgsql or postgres ... su to that account and then run
the createuser ... 

On Sat, 16 Sep 2000, Danny wrote:

>             
> 
> -I am running
> 
> FreeBSD 3.3
> 
> - I did a make install of postgrsql sucessful 
> 
>  - I want to createuser to create a testDB but when I create a test user I
> keep getting this error message
> 
>                            $ createuser dannyh
>                            Shall the new user be allowed to create databases? (y/n) y
>                            Shall the new user be allowed to create more new users? (y/n) y
>                            psql: FATAL 1: SetUserId: user 'dannyh' is not in 'pg_shadow'
>                            createuser: creation of user "dannyh" failed
>                            $
> 
>                            Question
> 
>                            1) What is the problem? how do I fix this problem?
> 
>                            Looking forwrd to your feedback.
> 
>                            dannyh
> 
>                            dannyh@idx.com.au
> 
> 
> To Unsubscribe: send mail to majordomo@FreeBSD.org
> with "unsubscribe freebsd-questions" in the body of the message
> 

Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ hub.org 
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org 



To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-questions" in the body of the message