Re: Yaml code

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux