Thread

1. Changing password for the postgres user?

   Bjørn T Johansen <btj@havleik.no> — 2005-06-23T11:34:28Z

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

2. Re: Changing password for the postgres user?

   Gavin Love <gavin@aardvarkmedia.co.uk> — 2005-06-23T11:52:11Z

   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
   
   

3. Re: Changing password for the postgres user?

   Douglas McNaught <doug@mcnaught.org> — 2005-06-23T12:12:04Z

   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
   
   

4. Re: Changing password for the postgres user?

   Bjørn T Johansen <btj@havleik.no> — 2005-06-23T13:47:24Z

   Aaahh, of course.... I forgot about the trust settings I have there...
   
   BTJ
   
   Gavin Love wrote:
   > 
   > 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