Обсуждение: pgAgent does not start with message “ERROR: Couldn't register event handle.”

Поиск
Список
Период
Сортировка

pgAgent does not start with message “ERROR: Couldn't register event handle.”

От
Arturas Mazeika
Дата:
Dear postgres Folk,

I am able to start the pgAgent in debug mode on a windows (server 2016) machine with the help of

    C:\Program Files (x86)\pgAgent\bin>pgagent.exe DEBUG "host=localhost port=5432 user=postgres dbname=postgres password=********"

I also tested that I can start jobs through pgAdmin III.

Starting a service from services in Windows fails with a generic message. If I login as postgres user

    runas /user:postgres cmd

and then try to start the service there using the same command as in services:

    C:\Program Files (x86)\pgAgent\bin>pgagent.exe RUN pgAgent "host=localhost port=5432 user=postgres dbname=postgres password=*******"

I get an error

    ERROR: Couldn't register event handle.

(which is what I suppose the service does) How can I solve the issue?

(supplying a password over command line is not a problem. We have successfully tested different approaches including pgpass and pg_hba successfully. I am trying to nail down why the service does not start in a regular way here).

I believe that the version of pgAgent is 1.22.

I posted this question also on

https://dba.stackexchange.com/questions/207067/pgagent-does-not-start-with-message-error-couldnt-register-event-handle

Cheers,
Arturas