hello Fabricio,
the listen_addresses is set to *
the result of psql command line
The job on pg_cron
Le ven. 12 mai 2023 à 17:05, Fabricio Pedroso Jorge <fpjbito@xxxxxxxxx> 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@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
Jaurès FOUTE
