Re: PG_Cron - Error Message Connection failed

hello Fabricio,

the listen_addresses is set to *
the result of psql command line
[image: image.png]
The job on pg_cron
[image: image.png]

Le ven. 12 mai 2023 à 17:05, Fabricio Pedroso Jorge <fpjbito(at)gmail(dot)com> a
écrit :

> 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(at)gmail(dot)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
>> [image: image.png]
>>
>> Any help is welcome
>>
>> --
>> Jaurès FOUTE
>>
>
>
> --
> *Fabrício Pedroso Jorge.*
> Database Architect / Database Engineer
>
> *LinkedIn Profile*
> http://br.linkedin.com/in/fabriciojorge
>
> *Contacts:*
> + 353 085 8221706
> fpjbito(at)gmail(dot)com
>

--
Jaurès FOUTE