Thread: Installing Postgres

Installing Postgres

From
mauroduarte@ig.com.br (Mauro)
Date:
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...

Any ideas ?

Regards,
Mauro

Re: Installing Postgres

From
Lee Harr
Date:
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';