Re: pg_hba.conf problem?

> This one below is part of my pg_hba.conf file:
>
> # This default configuration allows any local user to connect as any
> # PostgreSQL username, over either UNIX domain sockets or IP:
>
> host         all         127.0.0.1     255.255.255.255     crypt
> host         athena      172.28.61.13  255.255.255.255     trust   amgarcia

> Basically, I want user "amgarcia" to authenticate before connecting to the database.
> If I change the "trust" to "crypt", the server asks for a password.  It, however, does
> not want to accept the password "abc123".

Do you have a file amgarcia in your $PGDATA?  AFAIK the last parameter is
not a username it's an external file containing users that are allowed to
authenticate.