[prev in list] [next in list] [prev in thread] [next in thread] 

List:       freebsd-questions
Subject:    Re: Postgres - Initial Installation and Setup
From:       The Hermit Hacker <scrappy () hub ! org>
Date:       2000-01-31 23:19:40
[Download RAW message or body]

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

[prev in list] [next in list] [prev in thread] [next in thread]