Installing Postgres
Installing Postgres
От:
mauroduarte@ig.com.br (Mauro)
Дата:
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
От:
Lee Harr <missive@frontiernet.net>
Дата:
In article , 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';