In article <b5f11c7e.0208051532.7639f184@posting.google.com>, Mauro wrote:
> Hi,
>
> I'm having problems with users authentication in Postgres with linux.
> I have a user postgres and others. If in my pg_hba.conf I put
> passsword in AUTH_TYPE no users can log in with a message of
> authentication failed for user 'username', if I put trust every user
> log in without prompt of password and when I put crypt, again every
> user log in without prompt of password. I stop and start postgresql
> with no errors...
>
Do the users have passwords?
Did you do something like:
ALTER USER steve WITH PASSWORD 'ht6r&kww';