Re: Pgagent is not reading pgpass file either in Windows or Linux.

George Neuner <gneuner2@xxxxxxxxxxx> · Mon, 4 Jun 2018 20:18:39 -0400



    On 6/4/2018 6:31 PM, nageswara Bandla
      wrote:

    
      I have figured out the issue with pgAgent both in
        Windows and Linux. 
        
          PgAgent
            seems to ignore pgpass.conf/.pgpass whenever it has
            127.0.0.1 (127.0.0.1:5432:*:postgres:postgres)
            throws an error:
           
              DEBUG: Creating DB
              connection: user=postgres
              port=5432 hostaddr=127.0.0.1 dbname=linuxpostgresdb
           
                WARNING:
              Couldn't create the primary connection (attempt 1):
              fe_sendauth: no password
              supplied
          

          The
            solution could be update .pgpass to have (
            localhost:5432:*:postgres:postgres
              ) and then pgagent works fine without issues.
          

          I
            think, pgagent is not inline with libpq.dll while passing
            host address parameter. I have raised this concern with
            pgagent github where exactly they need to change the code in
            order for pgagent to be in line with psql program. 
          

        https://github.com/postgres/pgagent/issues/14

        
    Wow !!!

    
    I don't use pgpass much at all - usually I want the security of
    providing the password manually.  Since we started with the idea
    that the file wasn't being read properly, I was mainly trying to
    figure out how Windows could be screwing that up. <grin>

    
    There is a difference between localhost and 127.0.0.1:  localhost is
    DNS resolved - usually from the local hosts file - and thus works
    with either IPv4 or IPv6 addressing.  But it never would have
    occurred to me that using one vs the other, on an otherwise properly
    configured system, should cause an error.

    
    Great work finding that.

    George