I try to configure pgAgent on Windows server 2008 to make automatic backup on the database. pgAgent is installed on the server and the service is running normally. I use PgAdmin3 and PostgreSql 9.3
I have already planned query using the connection string with the password in it, and it works perfectly.
Now, I try to make it by specifying the password in pgpass.conf (as said in the doc) but I always got the "Couldn't get a connection to the database !" error.
My pgpass.conf is something like this :
220.127.116.11:5432:*:admin:*** 18.104.22.168:5432:*:postgres:*** localhost:5432:*:postgres:*** localhost:5432:*:admin:*** 127.0.0.1:5432:*:admin:***
I know that some line are rhetorical, it's just that I've tried a lot of things.
I usually try to connect on localhost, but even in remote connection mode it doesn't work.
Here some examples of what I've tried with remote connection in step configuration :
user=admin host=22.214.171.124 port=5432 dbname=db user=postgres host=126.96.36.199 port=5432 dbname=db user=admin host=127.0.0.1 port=5432 dbname=db user=postgres host=127.0.0.1 port=5432 dbname=db
EDIT : in Postgres log, pgagent is connected as adminpostgres. This username isn't in the login role...
pgpass.conf is in c:/user/Application Data/postgresql
pgAgent was installed with StackBuilder as Admin
I've tried to fill the "host agent" field with the content of "pga_jobagent.jagstation" but it doesn't work either