Re: help getting started with postgreSQL
On Wed, 7 Oct 1998, 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.
You need to be the user 'postgres' in order to add users :> Try
this (as root)
su - postrges
createuser
Hope this helps.
Reply to: