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
