Read this tutorial it has got everyting you need to know about psql.
Document herewith attached
On Sat, 23 Sep 2000, Chris wrote:
> Greetings,
>
> When ever a normal user (anyaccount besides "postgres") tries to
> run psql they get the following message:
>
> Connection to database 'dank' failed.
> FATAL 1: SetUserId: user "chrisp" is not in "pg_shadow"
>
>
> How do i fix this?