Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

pgAgent Windows service stops when PostgreSQL service is unavailable. #43

Open
JBHighHair opened this issue Dec 15, 2024 · 0 comments
Open

Comments

@JBHighHair
Copy link

JBHighHair commented Dec 15, 2024

When the PostgreSQL service is unavailable (for example during postgres patching) the pgAgent (Version 4.2) Windows service stops with the message "Failed to query jobs table!".

The Event Viewer details are below...

image

The problem here is that there is no trigger to restart the pgAgent service once the PostgreSQL service is running again.

Setting the pgAgent service with the following recovery settings does not work on Windows Server 2019....

image

Why does the pgAgent service need to stop?
Couldn't it wait and attempt reconnection after 30 seconds or so?

Thanks.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant