I don't know if this is the best way to do it, but I become root and
then 'su postgres'. This makes you the postgres user at which point
you can add the user.
Avi
On Apr 27, 2004, at 20:56, Robert Morgan wrote:
> Hi have just installed postgres and tried to open it using: psql
> template1 postgres
> and get an error ident authentication failed.
>
> How do I open the dbms to add a user?
> Can I do it from the shell?