[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    Re: Yaml code
From:       Ron Johnson <ronljohnsonjr () gmail ! com>
Date:       2023-11-22 15:42:04
Message-ID: CANzqJaDPOEeee13pSUUUUAG5fqcWPjVAYN31iZHxm5241M=Q4w () mail ! gmail ! com
[Download RAW message or body]

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.dba09@gmail.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.g.johnston@gmail.com>
> wrote:
>
>> On Wednesday, November 22, 2023, Rajesh Kumar <
>> rajeshkumar.dba09@gmail.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.
>>
>>

[Attachment #3 (text/html)]

<div dir="ltr"><div>That still doesn&#39;t make Postgresql understand YAML markup \
files.</div><div><br></div><div>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..</div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, \
Nov 22, 2023 at 10:05 AM Rajesh Kumar &lt;<a \
href="mailto:rajeshkumar.dba09@gmail.com">rajeshkumar.dba09@gmail.com</a>&gt; \
wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="auto">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..</div><br><div class="gmail_quote"><div dir="ltr" \
class="gmail_attr">On Wed, 22 Nov 2023, 20:22 David G. Johnston, &lt;<a \
href="mailto:david.g.johnston@gmail.com" \
target="_blank">david.g.johnston@gmail.com</a>&gt; wrote:<br></div><blockquote \
class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid \
rgb(204,204,204);padding-left:1ex">On Wednesday, November 22, 2023, Rajesh Kumar \
&lt;<a href="mailto:rajeshkumar.dba09@gmail.com" rel="noreferrer" \
target="_blank">rajeshkumar.dba09@gmail.com</a>&gt; wrote:<br><blockquote \
class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid \
rgb(204,204,204);padding-left:1ex"><div dir="auto">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&#39;d int) \
every 5mns</div></blockquote><div><br></div><div>This makes no \
sense…</div><div><br></div><div>YAML is markup, it doesn't run anything.   \
Something has to interpret the YAML.</div><div><br></div><div>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?</div><div><br></div><div>Anyway, cron itself runs periodically - you don't run \
it.   Just have it execute a psql command or bash script that includes using \
psql.</div><div><br></div><div>David J.</div><div><br></div> </blockquote></div>
</blockquote></div></div>



[prev in list] [next in list] [prev in thread] [next in thread]