Postgres Pro
Downloads
Home   >   mailing lists

Re: PG_Cron - Error Message Connection failed - Mailing list pgsql-general

From FOUTE K. Jaurès
Subject Re: PG_Cron - Error Message Connection failed
Date
Msg-id CAHQ1jffs1+Gzy3OtOgkscCH0U7WkVkNCmy384uSWKOWojQjh7Q@mail.gmail.com
Whole thread Raw
In response to Re: PG_Cron - Error Message Connection failed  (Fabricio Pedroso Jorge <fpjbito@gmail.com>)
Responses Re: PG_Cron - Error Message Connection failed
List pgsql-general
Tree view
hello Fabricio,

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

Le ven. 12 mai 2023 à 17:05, Fabricio Pedroso Jorge <fpjbito@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 <jauresfoute@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.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@gmail.com 


-- 
Jaurès FOUTE

		
	


	
	
Attachment

	
	

					

					





	

	pgsql-general by date:
	
	

	
	

		
			

	        	

	       			Previous
	    		

	    		
	From:
	"David G. Johnston"

	Date:
	



	Subject:
	Re: Adding SHOW CREATE TABLE
 

	    	

	    
	    
	    
			

	        	

	       			Next
	    		

	    		
	From:
	Adrian Klaver

	Date:
	



	Subject:
	Re: PG_Cron - Error Message Connection failed