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: [EMAIL PROTECTED] Curator, RiceBlastDB [EMAIL PROTECTED] Plant Breeding Dept. office: (607) 255-3103 Cornell University home: (607) 257-3463 320 Bradfield Hall Ithaca NY 14853
