pgAgent service for PostgreSQL does not run

by tomatoeshift   Last Updated September 11, 2019 14:06 PM

OS: Windows 10

PostgreSQL 11.4

I Installed PgAgent with Stackbuilder setup.

In Windows services; PostgreServer service is running. However, the pgAgent service is stopped. When I try to start pgAdmin service from there I get this error message:

The PostgreSQL Scheduling Agent - pgAgent service on Local Computer started and then stopped. 
Some services stop automatically if they are not in use by other services or programs. 

I have the pgAgent service to log On As -->LocalSystem (Note, I have also tried to change it to an windows administrator account)

When opening pgAdmin 4 I can see the pgAgent Jobs tab as well as create jobs.

Acording to the description on this page ,one should create an extension as well. However, when pgAgent was installed , there wasen't copied any extension files to %\PostgreSQL\11\share\extension so I can not create the extension in pgAdmin

Any advice on how I get the pgAgent service to run my jobs I have createn in pg Admin?

EDIT: On This thread They state that editing pgpass.conf in c:/user/user/AppData/postgresql helped. I have no such folder nore file. The only postgres related folders I've found under C:\Users is C:\Users\user\AppData\Roaming\pgAdmin



Related Questions


Auto start pgAgent

Updated May 11, 2016 09:02 AM