Postgres Pro
Downloads
Home   >   mailing lists

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

From Fabricio Pedroso Jorge
Subject Re: PG_Cron - Error Message Connection failed
Date
Msg-id CAJDTwK1M9XCP2dGA_Vq0Cpbi92VbUSxFypMU0esiJ6iVLe6y9w@mail.gmail.com
Whole thread Raw
In response to PG_Cron - Error Message Connection failed  (FOUTE K. Jaurès <jauresfoute@gmail.com>)
Responses Re: PG_Cron - Error Message Connection failed  (FOUTE K. Jaurès <jauresfoute@gmail.com>)
List pgsql-general
Tree view 
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 

		
	


	
	
Attachment

	
	

					

					





	

	pgsql-general by date:
	
	

	
	

		
			

	        	

	       			Previous
	    		

	    		
	From:
	FOUTE K. Jaurès

	Date:
	



	Subject:
	PG_Cron - Error Message Connection failed
 

	    	

	    
	    
	    
			

	        	

	       			Next
	    		

	    		
	From:
	"David G. Johnston"

	Date:
	



	Subject:
	Re: Adding SHOW CREATE TABLE