| 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: | Whole Thread | Raw Message | 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.
>
>
| 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 |