On 2009-07-27, Saleem EDAH-TALLY <nm...@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 >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-- > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
