Re: help getting started with postgreSQL

[Immanuel Yap <noelyap@ascus.cit.cornell.edu>]

Shaleh wrote:
> 
> 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.

postgres doesn't allow `root' to manipulate the database, as that could
be a breach of security.  Create a user `postgres' who will be database
administrator and run createuser from there.

Noel
-- 
Immanuel V. Yap         e-mail: noelyap@ascus.cit.cornell.edu
Curator, RiceBlastDB            ivy1@cornell.edu
Plant Breeding Dept.    office: (607) 255-3103
Cornell University        home: (607) 257-3463
320 Bradfield Hall
Ithaca NY 14853