Re: help getting started with postgreSQL

["Rodrigo Moya" <Moya_Rodrigo/madrid_tecnologia@sinvest.es>]

>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