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@xxxxxxxxx> 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 showAny help is welcome--Jaurès FOUTE
Fabrício Pedroso Jorge.
Database Architect / Database Engineer
Database Architect / Database Engineer
