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 Message-ID: <Pine.BSF.4.21.0009150124580.94875-100000@thelab.hub.org> In-Reply-To: <0009160112530A.00340@freebsd.freebsd.org>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?Pine.BSF.4.21.0009150124580.94875-100000>