OS: Windows 10
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)
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
c:/user/user/AppData/postgresql helped. I have no such folder nore file. The only postgres related folders I've found under
I opened CMD as an admin and run
cd %APPDATA%to find correct folder.
I created the
pgpass.confinside newly created folder
That did not change anything either.
Cholud I do some editting in REDEDIT? Source3