Обсуждение: Yaml code

Поиск
Список
Период
Сортировка

Yaml code

От
Rajesh Kumar
Дата:
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

Re: Yaml code

От
"David G. Johnston"
Дата:
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.

Re: Yaml code

От
Rajesh Kumar
Дата:
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.

Re: Yaml code

От
Ron Johnson
Дата:
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.