Re: Re: postmaster question

Lonnie Cumberland wrote:
> 
> Hello Mitch,
> 
> I have been trying to do just that and hove found that by going to my init.d
> directory and starting up the "postgresql" service helps.
> 
> Now the problem seems to be that even though I have just used "pg_passwd" to
> add me as a user, I am now getting an error message back saying that:
> 
> ---------------------------------------------------------------
> Connection to database 'template1' failed.
> FATAL 1:  SetUserId: user 'lonnie' is not in 'pg_shadow'
> 
> createdb: database creation failed on testpg.
> ----------------------------------------------------

Make sure that postgres is actually running by checking "ps aux | grep post"
Make sure that initdb has been run.
Make sure that you have created a user with "createuser" (I think this
is the one for you)

- Richard Huxton