Date: Mon, 31 Jan 2000 20:12:28 -0800 (PST) From: Woody Carey <wcarey@wcarey.com> 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.10.10001312010230.29113-100000@mail.wcarey.com> In-Reply-To: <3896160F.D15BDDCE@patho.gen.nz>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?Pine.BSF.4.10.10001312010230.29113-100000>