From owner-freebsd-questions Mon Jan 31 15:20:27 2000 Delivered-To: freebsd-questions@freebsd.org Received: from thelab.hub.org (nat198.40.mpoweredpc.net [142.177.198.40]) by hub.freebsd.org (Postfix) with ESMTP id 708011500E for ; Mon, 31 Jan 2000 15:20:21 -0800 (PST) (envelope-from scrappy@hub.org) Received: from localhost (scrappy@localhost) by thelab.hub.org (8.9.3/8.9.1) with ESMTP id TAA01028; Mon, 31 Jan 2000 19:19:40 -0400 (AST) (envelope-from scrappy@hub.org) X-Authentication-Warning: thelab.hub.org: scrappy owned process doing -bs Date: Mon, 31 Jan 2000 19:19:40 -0400 (AST) From: The Hermit Hacker 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 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) you have to install as root, but when you do the 'initdb' and run the database, it has to be done as a non-root user, *generally* postgres or pgsql ... > 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. create a 'postgres superuser', which I believe the port already does, and do everything as it ... To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message