Re: PG_Cron - Error Message Connection failed

Поиск

Список

Период

Сортировка

От	Fabricio Pedroso Jorge
Тема	Re: PG_Cron - Error Message Connection failed
Дата	12 мая 2023 г. 19:05:03
Msg-id	CAJDTwK1M9XCP2dGA_Vq0Cpbi92VbUSxFypMU0esiJ6iVLe6y9w@mail.gmail.com обсуждение исходный текст
Ответ на	PG_Cron - Error Message Connection failed (FOUTE K. Jaurès <jauresfoute@gmail.com>)
Ответы	Re: PG_Cron - Error Message Connection failed
Список	pgsql-general

Дерево обсуждения

Try checking the view cron.job, column "nodename", if it's set to "localhost", change it (via an UPDATE) to the address defined in "listen_address" parameter and see if this works.

Em sex., 12 de mai. de 2023 às 17:00, FOUTE K. Jaurès <jauresfoute@gmail.com> escreveu:

Hello everyone,

Can someone help me to understand this issue. I installed and configured pg_cron on the server and I was able to connect without providing a password using psql command line.
But when i schedule a job, like this: SELECT cron.schedule( 'TEST','30 seconds', $$SELECT 1$$);
the result show

Any help is welcome

--
Jaurès FOUTE