Re: PG_Cron - Error Message Connection failed

Le lun. 15 mai 2023 à 05:12, FOUTE K. Jaurès a écrit : > > > Le dim. 14 mai 2023 à 21:12, Adrian Klaver a > écrit : > >> On 5/14/23 13:04, FOUTE K. Jaurès wrote: >> > >> > >> > Le dim. 14 mai 2023 à 16:12, Adrian Klaver > > > a écrit : >> >> > >> > Not what

Re: PG_Cron - Error Message Connection failed

Le dim. 14 mai 2023 à 21:12, Adrian Klaver a écrit : > On 5/14/23 13:04, FOUTE K. Jaurès wrote: > > > > > > Le dim. 14 mai 2023 à 16:12, Adrian Klaver > > a écrit : > > > > > Not what was requested. > > > > In the post linked to here: > > > > >

Re: PG_Cron - Error Message Connection failed

On 5/14/23 13:04, FOUTE K. Jaurès wrote: Le dim. 14 mai 2023 à 16:12, Adrian Klaver > a écrit : Not what was requested. In the post linked to here:

Re: PG_Cron - Error Message Connection failed

Le dim. 14 mai 2023 à 16:12, Adrian Klaver a écrit : > On 5/14/23 00:20, FOUTE K. Jaurès wrote: > > > > > > Le sam. 13 mai 2023 à 15:59, Adrian Klaver > > a écrit : > > > > On 5/13/23 00:54, FOUTE K. Jaurès wrote: > > > > > > > > > > > > >

Re: PG_Cron - Error Message Connection failed

On 5/14/23 00:20, FOUTE K. Jaurès wrote: Le sam. 13 mai 2023 à 15:59, Adrian Klaver > a écrit : On 5/13/23 00:54, FOUTE K. Jaurès wrote: > > > >     In your original post in the image under the database column it looks >     

Re: PG_Cron - Error Message Connection failed

Le sam. 13 mai 2023 à 15:59, Adrian Klaver a écrit : > On 5/13/23 00:54, FOUTE K. Jaurès wrote: > > > > > > > > > In your original post in the image under the database column it looks > > like, to my old eyes, there is a list of database names. > > > > Is that the case? > > > >

Re: PG_Cron - Error Message Connection failed

On 5/13/23 00:54, FOUTE K. Jaurès wrote: In your original post in the image under the database column it looks like, to my old eyes, there is a list of database names. Is that the case? Copy and paste that content in your reply. Hello @Adrian Klaver

Re: PG_Cron - Error Message Connection failed

Le ven. 12 mai 2023 à 20:21, Adrian Klaver a écrit : > On 5/12/23 09:41, FOUTE K. Jaurès wrote: > > Understand @Adrian Klaver . > > the log show: > > 2023-05-12 17:30:19.327 WAT [46190] LOG: cron job 8 starting: SELECT 1 > > 2023-05-12 17:30:19.339 WAT [46190]

Re: PG_Cron - Error Message Connection failed

On 5/12/23 09:41, FOUTE K. Jaurès wrote: Understand @Adrian Klaver  . the log show: 2023-05-12 17:30:19.327 WAT [46190] LOG:  cron job 8 starting: SELECT 1 2023-05-12 17:30:19.339 WAT [46190] LOG:  cron job 8 connection failed Well that did not go anywhere.

Re: PG_Cron - Error Message Connection failed

Understand @Adrian Klaver . the log show: 2023-05-12 17:30:19.327 WAT [46190] LOG: cron job 8 starting: SELECT 1 2023-05-12 17:30:19.339 WAT [46190] LOG: cron job 8 connection failed Le ven. 12 mai 2023 à 17:23, Adrian Klaver a écrit : > On 5/12/23 09:22, FOUTE K. Jaurès wrote: > > 1) Please

Re: PG_Cron - Error Message Connection failed

On 5/12/23 09:22, FOUTE K. Jaurès wrote: 1) Please do not top post. Use inline posting 2) Do not use images, copy and paste as text. hello Fabricio, the listen_addresses is set to * the result of psql command line image.png The job on pg_cron image.png What does the Postgres log show when

Re: PG_Cron - Error Message Connection failed

hello Fabricio, the listen_addresses is set to * the result of psql command line [image: image.png] The job on pg_cron [image: image.png] Le ven. 12 mai 2023 à 17:05, Fabricio Pedroso Jorge a écrit : > Try checking the view cron.job, column "nodename", if it's set to > "localhost", change it

Re: PG_Cron - Error Message Connection failed

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 escreveu: > Hello everyone, > > Can someone help me to

PG_Cron - Error Message Connection failed

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