| From: | Jasen Betts <jasen(at)xnet(dot)co(dot)nz> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Run procedure at startup |
| Date: | 2009-08-02 12:32:26 |
| Message-ID: | h5410q$77e$1@reversiblemaps.ath.cx |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 2009-07-27, Saleem EDAH-TALLY <nmset(at)netcourrier(dot)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 infinite loop 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 persist after 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--
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sam Mason | 2009-08-02 14:09:19 | Re: Division by zero |
| Previous Message | Pavel Stehule | 2009-08-02 12:20:18 | Re: Division by zero |