pgAgent service for PostgreSQL does not run
2
votes
1
answer
14334
views
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
----------
**EDIT2:**
* I opened CMD as an admin and run cd %APPDATA%
to find correct folder.
* I created the pgpass.conf
inside newly created folder postgresql
in appdata
--> C:\Users\user\AppData\Roaming\postgresql\pgpass.conf
.
* I added that file as a system variable PGPASSFILE
(Source1 and Source2 ).
That did not change anything either.
Cholud I do some editting in REDEDIT? Source3
----------
Asked by tomatoeshift
(143 rep)
Sep 11, 2019, 01:52 PM
Last activity: Sep 13, 2019, 08:36 AM
Last activity: Sep 13, 2019, 08:36 AM