From owner-freebsd-questions Mon Jan 31 23: 0:31 2000 Delivered-To: freebsd-questions@freebsd.org Received: from mail.wcarey.com (mail.wcarey.com [209.181.61.113]) by builder.freebsd.org (Postfix) with ESMTP id 0DA4D3D0B for ; Mon, 31 Jan 2000 23:00:25 -0800 (PST) Received: from mail.wcarey.com (mail.wcarey.com [209.181.61.113]) by mail.wcarey.com (8.9.3/8.9.3) with ESMTP id UAA29121; Mon, 31 Jan 2000 20:12:28 -0800 (PST) (envelope-from wcarey@wcarey.com) Date: Mon, 31 Jan 2000 20:12:28 -0800 (PST) From: Woody Carey To: sobrien@quicksilver.co.nz Cc: "freebsd-questions@FreeBSD.ORG" Subject: Re: Postgres - Initial Installation and Setup In-Reply-To: <3896160F.D15BDDCE@patho.gen.nz> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG Hi Sarton, When I installed postgresql from the ports on my 3.2-R box, making sure to also follow the directions on www.postgres.org, the port made a 'pgsql' user for me. Good luck guessing what the password for the user is! ;-) - Woody On Tue, 1 Feb 2000, Sarton O'Brien wrote: > Just a few questions that I seem to have trouble answering with the web. > > Without reading any documentation, I installed postgres as root, is this > wrong?(Documentation kind of says it is but am not 100% sure) > > Do I have to install as a su? > > If yes to the above, can I remedy the problem without re-installing. > > This is the error msg that is displayed. > > laptop2# createuser > Connection to database 'template1' failed > FATAL 1: SetUserId: user 'root' is not in 'pg_shadow' > > createuser: database access failed > > replace 'root' with 'myusername' in the su situation. > > Thanks for any help. > > > 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