Changing password for the postgres user?
I am trying to change the password for the postgres user but it doesn't work... I
have tried changing it from pgAdmin, EMS PostgreSQL Manager, etc but whatever
password I set, I still can log in without using password.... (And it seems that no
sql code is run on the server)
What am i missing?
Regards,
BTJ
--
-----------------------------------------------------------------------------------------------
Bj�rn T Johansen
btj@havleik.no
-----------------------------------------------------------------------------------------------
Someone wrote:
"I understand that if you play a Windows CD backwards you hear strange Satanic messages"
To which someone replied:
"It's even worse than that; play it forwards and it installs Windows"
-----------------------------------------------------------------------------------------------
Bj�rn T Johansen wrote:
I am trying to change the password for the postgres user but it doesn't work... I
have tried changing it from pgAdmin, EMS PostgreSQL Manager, etc but whatever
password I set, I still can log in without using password.... (And it seems that no
sql code is run on the server)What am i missing?
Have you checked your pg_hba.conf ?
It will be set to trust most likely which means the user doesn't need a
password change it to crypt or password or md5 depending on your needs.
http://www.postgresql.org/docs/8.0/interactive/client-authentication.html#EXAMPLE-PG-HBA.CONF
Gavin
Bjørn T Johansen <btj@havleik.no> writes:
I am trying to change the password for the postgres user but it
doesn't work... I have tried changing it from pgAdmin, EMS
PostgreSQL Manager, etc but whatever password I set, I still can log
in without using password.... (And it seems that no sql code is run
on the server)What am i missing?
Editing pg_hba.conf?
-Doug
Aaahh, of course.... I forgot about the trust settings I have there...
BTJ
Gavin Love wrote:
Show quoted text
Bj�rn T Johansen wrote:
I am trying to change the password for the postgres user but it
doesn't work... I
have tried changing it from pgAdmin, EMS PostgreSQL Manager, etc but
whatever
password I set, I still can log in without using password.... (And it
seems that no
sql code is run on the server)What am i missing?
Have you checked your pg_hba.conf ?
It will be set to trust most likely which means the user doesn't need a
password change it to crypt or password or md5 depending on your needs.http://www.postgresql.org/docs/8.0/interactive/client-authentication.html#EXAMPLE-PG-HBA.CONF
Gavin