| From: | Fabrízio de Royes Mello <fabrizio(at)timbira(dot)com(dot)br> |
|---|---|
| To: | "Brandl, Wolfgang" <wolfgang(dot)brandl(at)brz(dot)gv(dot)at> |
| Cc: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Background worker process |
| Date: | 2017-12-19 15:02:21 |
| Message-ID: | CAPfkCSA+WDGQAEEkbYFBqCWKPPLGHLi+70QweJd2GHhm=4sPtA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Em ter, 19 de dez de 2017 às 10:11, Brandl, Wolfgang <
wolfgang(dot)brandl(at)brz(dot)gv(dot)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,
https://github.com/citusdata/pg_cron
--
Fabrízio de Royes Mello Timbira - http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Aleksandar Andrejevic | 2017-12-19 15:02:32 | |
| Previous Message | scott ribe | 2017-12-19 14:29:29 | Re: Estimate maintenance_work_mem for CREATE INDEX |