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
