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

Поиск
Список
Период
Сортировка
От Arturas Mazeika
Тема pgAgent does not start with message “ERROR: Couldn't register event handle.”
Дата
Msg-id CAAUL=cEG_9OF3AMzE+yyGKnCuJy473KmGOa-L8no_GUgjn+htg@mail.gmail.com
обсуждение исходный текст
Список pgadmin-support
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

В списке pgadmin-support по дате отправления:

Предыдущее
От: richard coleman
Дата:
Сообщение: Re: SQL_ASCII support (or lack thereof)
Следующее
От: Dave Page
Дата:
Сообщение: Re: SQL_ASCII support (or lack thereof)