Postgresql – pgAgent service for PostgreSQL does not run

pgadminpgagentpostgresqlwindowswindows 10

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

Best Answer

I'm not sure what I did, but I have the service running now. I guess it is a combination of little of everything

Open CMD as administrator
browse to pgagent.exe
- cd C:\Program Files\PostgreSQL\pgAgent\bin
Remove the pgAgent service (if pgAgent service is installed, but does not work)
- pgAgent REMOVE pgAgent
Then I installed the service again.
- pgAgent INSTALL pgAgent -u WindowsUser -p WindowsPassword hostaddr=127.0.0.1 dbname=postgres user=postgres password=postgePassword
(Not sure if the following steps are needed but) Open Windows services
There you can confirm the windows account that runs the service.
open up pgpass.conf in %APPDATA/postgresql and add the line
- 127.0.0.1:5432:*:windowsUsername:windowsPassword
add pgpass.conf as system variable PGPASSFILE

Related Solutions

PostgreSQL: The database cluster initialization failed

I had the same issue installing 9.1.4 on Windows 7. I managed to find a solution online that worked.

The steps I followed are:

Uninstall PostgreSQL
Delete the postgres user if it still exists.
```
net user postgres /delete
```
Create the postgres user with a password you can remember
```
net user /add postgres <password>
```
Add the postgres user to the Administrators group
```
net localgroup administrators postgres /add
```
Add the postgres user to the Power Users group
```
net localgroup "power users" postgres /add
```
Run a command window as the postgres user
```
runas /user:postgres cmd.exe
```
Run the install file from within the command window.
```
C:\Download\postgresql-9.1.4-1-windows.exe
```
This should run the installation successfully.
Remove the postgres user from the Administrators group.
```
net localgroup administrators postgres /delete
```

Postgresql – Pg install: “The database cluster initialisation failed”

It appears that the root cause of this issue may have been that @Celeritas's computer had an incorrect value for the COMSPEC environment variable. It had a trailing semicolon, so instead of the normal:

C:\Windows\system32\cmd.exe

it was:

C:\Windows\system32\cmd.exe;

This one-character difference is enough. The above isn't a valid command prompt path, so popen() calls were failing. Unfortunately, instead of something useful like:

'"C:\Windows\system32\cmd.exe;"' is not recognized as an internal or external command, operable program or batch file

it instead reports the delightfully useful error No error:

initdb: could not execute command ""C:/Program Files/PostgreSQL/9.2/bin/postgres.exe" --boot -x1 -F ": No error

See related:

I've reported this to the installer team and written a wiki entry to describe it. See blog post.

The issue was eventually resolved by:

Editing the COMSPEC environment variable
Uninstalling PostgreSQL
Rebooting
Reinstalling PostgreSQL

though there was a lot more before that which shouldn't actually be necessary to resolve this, including doing a total manual clean uninstall of PostgreSQL by hand.

Now I just want to find the people who wrote the program that modified this environment variable.

Best Answer

Related Solutions

PostgreSQL: The database cluster initialization failed

Postgresql – Pg install: “The database cluster initialisation failed”

Related Question