Re: Background worker process - Mailing list pgsql-admin

From Fabrízio de Royes Mello
Subject Re: Background worker process
Date
Msg-id CAPfkCSA+WDGQAEEkbYFBqCWKPPLGHLi+70QweJd2GHhm=4sPtA@mail.gmail.com
Whole thread Raw
In response to Background worker process  ("Brandl, Wolfgang" <wolfgang.brandl@brz.gv.at>)
List pgsql-admin

Em ter, 19 de dez de 2017 às 10:11, Brandl, Wolfgang <wolfgang.brandl@brz.gv.at> escreveu:

Hello

We want to start processes controlled by a prostgres table which acts like crontab.

So we want to start a background worker process which starts the defined functions.

 

Is it possible to start from a background worker process a child process with a specific User. So this process can only acces the data for his authority.

 

Like a SQL Intrusion with this definition nobody can start a process a Postgres superuser.


Already exists a "crontab like" background worker project [1].

Regards,

--
   Fabrízio de Royes Mello         Timbira - http://www.timbira.com.br/
   PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento

pgsql-admin by date:

Previous
From: scott ribe
Date:
Subject: Re: Estimate maintenance_work_mem for CREATE INDEX
Next
From: Aleksandar Andrejevic
Date:
Subject: