you need to add the other users as postgres users..
createuser (username)
On Mon, 10 Aug 1998, Drew Hamilton wrote:
> Hi there!
>
> I've just installed Postgres and now I'm having problem with authentication.
> Everything works properly when I log on "directly" (logged on to UNIX as
> the same user as I'm logging onto Postgres):
>
> [postgres@urd pgsql]$ psql ichallenge
> Welcome to the POSTGRESQL interactive sql monitor:
> Please read the file COPYRIGHT for copyright terms of POSTGRESQL
>
> However, as soon as I try to use the "-u" option to specify a username
> and password, it fails, no matter who I'm logged on as:
>
> [postgres@urd pgsql]$ psql -h localhost -u ichallenge
> Username: postgres
> Password:
>
> Connection to database 'ichallenge' failed.
> PQexec() -- Request was sent to backend, but backend closed the channel before r
> esponding. This probably means the backend terminated abnormally before or whil
> e processing the request.
>
> I get the same results no matter who I'm logged into UNIX as. Once, I
> was lucky enough to get a different failure message, saying that plaintext
> password authentication had failed, but I can't duplicate it anymore.
>
> Can anyone help?
>
> - Drew
>
>
>
