From owner-freebsd-questions Thu Sep 14 21: 2: 0 2000 Delivered-To: freebsd-questions@freebsd.org Received: from pop.idx.com.au (pop.idx.com.au [203.14.30.10]) by hub.freebsd.org (Postfix) with ESMTP id 9E09337B423 for ; Thu, 14 Sep 2000 21:01:56 -0700 (PDT) Received: from freebsd.freebsd.org (idxwc02-164.idx.com.au [203.166.0.164]) by pop.idx.com.au (8.9.3/8.9.3) with SMTP id PAA04635 for ; Fri, 15 Sep 2000 15:01:53 +1100 From: Danny To: freebsd-questions@freebsd.org Subject: Post Postgresql config problems Date: Sat, 16 Sep 2000 01:11:38 +1100 X-Mailer: KMail [version 1.0.21] Content-Type: text/plain MIME-Version: 1.0 Message-Id: <0009160112530A.00340@freebsd.freebsd.org> Content-Transfer-Encoding: 8bit Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG -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