Le dim. 14 mai 2023 à 16:12, Adrian Klaver <adrian.kla...@aklaver.com> a écrit :
> On 5/14/23 00:20, FOUTE K. Jaurès wrote: > > > > > > Le sam. 13 mai 2023 à 15:59, Adrian Klaver <adrian.kla...@aklaver.com > > <mailto:adrian.kla...@aklaver.com>> 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? > > > > > > Copy and paste that content in your reply. > > > > > > > > > Hello @Adrian Klaver <mailto:adrian.kla...@aklaver.com > > <mailto:adrian.kla...@aklaver.com>> sorry for the > > > delais. > > > Copy of content of cron.job ? > > > > The text version of whatever was in the image in this post: > > > > > > i'm using Ubuntu server 22.04 LTS with PostgreSQL 13 > > I install pg_cron using the command: sudo apt-get -y install > > postgresql-13-cron > > Not what was requested. > > In the post linked to here: > > > https://www.postgresql.org/message-id/CAHQ1jffWF7Y8c1X7EK3JvbLJgw1GEcVk0uPa3%2B0CJo4h8PFHVw%40mail.gmail.com > > there was an image of the result of: > > SELECT cron.schedule( 'TEST','30 seconds', $$SELECT 1$$); > > Provide that result as text. > > jobid | schedule | command | nodename | nodeport | database | username | active | jobname -------+------------+----------+-----------+----------+--------------------------------------------+----------+--------+--------- 8 | 30 seconds | SELECT 1 | localhost | 5692 | databasename | postgres | t | TEST (1 row) > > > > > > > > https://www.postgresql.org/message-id/CAHQ1jffWF7Y8c1X7EK3JvbLJgw1GEcVk0uPa3%2B0CJo4h8PFHVw%40mail.gmail.com > < > https://www.postgresql.org/message-id/CAHQ1jffWF7Y8c1X7EK3JvbLJgw1GEcVk0uPa3%2B0CJo4h8PFHVw%40mail.gmail.com > > > > > > Or at least what was in the database column. > > > > > -- > > > Jaurès FOUTE > > > > -- > > Adrian Klaver > > adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com> > > > > > > > > -- > > Jaurès FOUTE > > -- > Adrian Klaver > adrian.kla...@aklaver.com > > -- Jaurès FOUTE
