> 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.
