Re: Yaml code

From: Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Yaml code
Date: 2023-11-22 15:05:02
Message-ID: CAJk5AtZOCF-q8mtfTFYJ9UnDSwtpFeSHj=bROVitGdj8CMiE7g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I am using openshift env and postgres 15.2. I can see cron job for
pgbackrest already. Similarly I want to execute certain postgres functions
periodically. Creating table was asked as example..

On Wed, 22 Nov 2023, 20:22 David G. Johnston, <david(dot)g(dot)johnston(at)gmail(dot)com>
wrote:

> On Wednesday, November 22, 2023, Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com>
> wrote:
>
>> I am using postgres 15.2 version. I want to write a yaml code to run a
>> cron job that creates a table emp(I'd int) every 5mns
>>
>
> This makes no sense…
>
> YAML is markup, it doesn’t run anything. Something has to interpret the
> YAML.
>
> I also can’t imagine how creating a fixed table periodically is useful;
> seems like it should fail every time but the first. What problem is this
> supposed to solve?
>
> Anyway, cron itself runs periodically - you don’t run it. Just have it
> execute a psql command or bash script that includes using psql.
>
> David J.
>
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Rajesh Kumar 2023-11-22 15:07:46 Re: Pgbouncer
Previous Message David G. Johnston 2023-11-22 14:52:24 Re: Yaml code