Fwd: Re: Admin user issue: unable to login after changing password

sharon <sharon@xxxxxxxxxx> · Wed, 05 Feb 2014 11:34:08 +0100



      -------- Messaggio originale --------
      
        
            Oggetto:
            
            Re:  Admin user issue: unable to login after
              changing password
          
          
            Data: 
            Wed, 05 Feb 2014 11:32:48 +0100
          
          
            Mittente:
            
            sharon <sharon@xxxxxxxxxx>
          
          
            A: 
            desmodemone <desmodemone@xxxxxxxxx>
          
        
      Hello sharon,

      
                                  first :
            please use bottom posting , so it's more easy to
            read the mail history / thread from up to down.

          
          Second: could you attach the
            pg_hba.conf ?

          
          Third: how you connect to postgresql
            ?

          
          Four: after modify the pg_hba.conf,
            did you reload or restart postgresql?

          
          I explain:  if you connect to
            "localhost"  the rule 

            
            host     all             postgres             localhost    
                      trust

            
          make you enter in the database trough
            the 127.0.0.1 on 5432 ( I imagine you have the default
            settings and the firewall with the open port or firewall
            down ) without password

            
            psql -U postgres -h localhost 

            
          will connect to database

          
          if you not specified "locahost"  the
            probably rule you will meet will be about "local" connection
            :

            
            local     all             all                            
            peer

            
          that will make you enter without
            password, only if your OS account exists in the database.

            
           Bye

            
            Mat

          
        Nessun
          virus nel messaggio.

          Controllato da AVG - www.avg.com

          Versione: 2014.0.4259 / Database dei virus: 3684/7062 - Data
          di rilascio: 04/02/2014
      
      
      Hi,

      for some reason pgsql uses only the ipv6 configuration while i was
      changing the ipv4.

      Now everything is working again.

      
      Thank you very much for your help

      
      Sharon