From: | Ron Johnson <ronljohnsonjr(at)gmail(dot)com> |
---|---|
To: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Yaml code |
Date: | 2023-11-22 15:42:04 |
Message-ID: | CANzqJaDPOEeee13pSUUUUAG5fqcWPjVAYN31iZHxm5241M=Q4w@mail.gmail.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
That still doesn't make Postgresql understand YAML markup files.
If you want a YAML file to control what actions happen when, then you must
look outside Postgresql for a generic Linux or container tool..
On Wed, Nov 22, 2023 at 10:05 AM Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com>
wrote:
> 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 17:02:29 | Re: Pgbouncer |
Previous Message | Erik Wienhold | 2023-11-22 15:41:02 | Re: Pgbouncer |