Background worker process - Mailing list pgsql-admin

From Brandl, Wolfgang
Subject Background worker process
Date
Msg-id F2EB158D72DC6A4F97877DD0BB6F020E6138D650@CMD0MBX-AB01.cmd0.cna.at
Whole thread Raw
Responses Re: Background worker process  (Laurenz Albe <laurenz.albe@cybertec.at>)
Re: Background worker process  (Fabrízio de Royes Mello <fabrizio@timbira.com.br>)
List pgsql-admin

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.

 

Any idea?

Regards

Wolfgang

pgsql-admin by date:

Previous
From: Devrim Gündüz
Date:
Subject: Re: Couldn't create plperl language
Next
From: Laurenz Albe
Date:
Subject: Re: WG: Extension using the current connection handle