PostgreSQL(9.4) Scheduling Agent pgAgent : Couldn&

2019-07-09 07:43发布

I have been trying to schedule a job using pgAgent. But, I am getting the below error:

"Couldn't get a connection to the database"

Following are the configurations:

pgAgent Configuration:

pgAgent Configuration


Scheduled Job Configuration:

Scheduled Job Configuration

Please help to get it resolved.

1条回答
叼着烟拽天下
2楼-- · 2019-07-09 08:24

I have resolved the issue. I did make the credential entry "localhost:5432:testing:postgres:[Enter password]" in file "pgpass.conf" which exist at location "C:\Users\sys*[service username]*\AppData\Roaming\postgresql". Now it is working perfectly.

查看更多
登录 后发表回答