>Hi, I just installed the postgreSQL packages. However I can not add users
>because
>
>foo# createuser
>Connection to database 'template1' failed.
>FATAL 1: SetUserId: user "root" is not in "pg_shadow"
>
>createuser: database access failed.
>foo#
>
>The docs are not helping. What is the necessary steps to getting a
database up
>so I can learn SQL.
>
It sounds as if the template database has not been installed. What I did is
to log in as postgres user and:
createdb database_name
and then, to create the user
createuser database_name user
I'm not sure about syntax but all you have to do is to specify the name of
the database you want to connect to. Have a look at createuser man page
Cheers
