as user postgres simply do the following:
createuser username
that will promt you for a couple of questions, asking if you want that user
to beable to make databases and to add users.
Mike
----- Original Message -----
From: "Anatoly K. Lasareff" <tolik@aaanet.ru>
To: <joydip@cal2.vsnl.net.in>
Cc: <pgsql-admin@postgresql.org>
Sent: Wednesday, March 07, 2001 2:42 AM
Subject: Re: cannot create new user in postgres
> >>>>> "j" == joydip <joydip@cal2.vsnl.net.in> writes:
>
> j> Hi all
>
> j> I have tried to configure the pg_hba.conf with
>
> j> local all
> j> trust
> j> host all 127.0.0.1 255.255.255.255 trust
>
> j> then i tried to run
>
> j> psql -h localhost template1
>
> j> but any of my domain failing to use postgresql .
>
> j> They are showing error re no entry in pg_shadow.
>
>
> j> though it was running in root ok with user postgres
>
> j> Thanks in advance for the help
>
> Who is postgres superuser? Suppose it is 'pgsql', then try
>
> psql -U pgsql templateq
>
> --
> Anatoly K. Lasareff Email: tolik@aaanet.ru
> http://tolikus.hq.aaanet.ru:8080 Phone: (8632)-710071
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>