Date: Mon, 31 Jan 2000 19:19:40 -0400 (AST) From: The Hermit Hacker <scrappy@hub.org> To: sobrien@quicksilver.co.nz Cc: "freebsd-questions@FreeBSD.ORG" <freebsd-questions@FreeBSD.ORG> Subject: Re: Postgres - Initial Installation and Setup Message-ID: <Pine.BSF.4.21.0001311918410.411-100000@thelab.hub.org> In-Reply-To: <3896160F.D15BDDCE@patho.gen.nz>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?Pine.BSF.4.21.0001311918410.411-100000>