From owner-freebsd-questions Thu Sep 14 21:16:33 2000 Delivered-To: freebsd-questions@freebsd.org Received: from ns1.jonelrienton.org (dsl-64-34-25-237.telocity.com [64.34.25.237]) by hub.freebsd.org (Postfix) with SMTP id 2640C37B42C for ; Thu, 14 Sep 2000 21:16:21 -0700 (PDT) Received: (qmail 60145 invoked from network); 15 Sep 2000 04:33:58 -0000 Received: from debian (10.29.22.23) by zeus with SMTP; 15 Sep 2000 04:33:58 -0000 Message-ID: <02da01c01ecd$36349ac0$17161d0a@jonelrienton.org> From: "Jonel Rienton" To: "Danny" , References: <0009160112530A.00340@freebsd.freebsd.org> Subject: Re: Post Postgresql config problems Date: Thu, 14 Sep 2000 23:27:09 -0500 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG there's a recent article about Postgresql setup/config in http://www.freebsddiary.org it explains some basic post install setup/configuration Jonel Rienton http://qmail.freebsduser.org sent by qmail-1.03 on a FreeBSD 4.1-STABLE ----- Original Message ----- From: "Danny" To: Sent: Friday, September 15, 2000 9:11 AM Subject: Post Postgresql config problems | | | -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 | To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message