Re: Run procedure at startup

On 2009-07-27, Saleem EDAH-TALLY <nmset@netcourrier.com> wrote:
> --Boundary-00=_NZcbKOfdE2cMluA
> Content-Type: text/plain;
>   charset="us-ascii"
> Content-Transfer-Encoding: 7bit
>
> Hello,
>
> Is there a way to run a pl/pgsql automatically at server startup ?

pgagent perhaps? modify the startup scripts?

> Is there a way to run a pl/pgsql function with an infinite loop as a daemon ?

write a daemon (as a shell script if neccessary).
OTOH crontab or pgagent may be enough?

> Is there a way to start a pl/pgsql function that would persist after the user
> session has closed ?

pgagent perhaps?

> Is there a way for an unprivileged user to delegate a task (allowed by
> superuser) to a superuser ?

superuser specifys "security definer" when the superuser defines the
function.


><p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px;
-qt-block-indent:0;text-indent:0px; -qt-user-state:0;"><br></p>Is there a way to run a pl/pgsql automatically at server
startup?<br> 
><p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px;
-qt-block-indent:0;text-indent:0px; -qt-user-state:0;"><br></p>Is there a way to run a pl/pgsql function with an
infiniteloop as a daemon ?<br> 
><p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px;
-qt-block-indent:0;text-indent:0px; -qt-user-state:0;"><br></p>Is there a way to start a pl/pgsql function that would
persistafter the user session has closed ?<br> 
><p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px;
-qt-block-indent:0;text-indent:0px; -qt-user-state:0;"><br></p>Is there a way for an unprivileged user to delegate a
task(allowed by superuser) to a superuser ?<br> 
><p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px;
-qt-block-indent:0;text-indent:0px; -qt-user-state:0;"><br></p>Thanks in advance.<br> 
><p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px;
-qt-block-indent:0;text-indent:0px; -qt-user-state:0;"><br></p></body></html> 
> --Boundary-00=_NZcbKOfdE2cMluA--
>