Re: probable pg_hba.conf configuration issues

Sim Zacks <sim@xxxxxxxxxxxxxx> · Wed, 07 May 2014 17:49:30 +0300



    My bet is you have either another line
      in the pg_hba that says trust

      or you saved the password and forgot.

      
      Sim

      
      On 05/07/2014 05:33 PM, Ravi Roy wrote:

    
        Hi,
         
        I'm sorry if this question have been asked earlier, but i
          could not find any valid result through googling.
         
        I'm running postgresql 9.1 on Windows 7 (64 bit) and i've
          following configuration in pg_hba.conf.
         
        host     all             superuser1    127.0.0.1/32    
          password

          host     all             normaluser1  127.0.0.1/32    
          password
         
        Using command line : psql -U superuser1 & psql -U
          normaluser1 asks for password and login successfully. -
          perfect. (We are only alloing local connections, remote
          connections to database are disabled)
         
        But if I try to connect using pgadmin (from the same
          machine) it gives acess to database without password, i'm
          surprised as it does not seem to respect pg_hba.conf or i'm
          terribly wrong in the configuration somewhere. 
         
        Does somebody have any idea what is wrong? 
         
        Thank you
         
        Ravi.