I am making a job in postgresql using pgagent when I run my job it says coudn't connect to db. Can any one guide me what is the issue? I tried to find on internet but could not find anything beneficial. I have created my own Database named 'TestDB' . I have only one connection string in pgpass.conf
which is localhost:5432:postgres:postgres:test