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 <fpjb...@gmail.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 < > jauresfo...@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 >> [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 > fpjb...@gmail.com > -- Jaurès FOUTE
