[Qgis-user] start Postgresql/Postgis function automatically

[Christian Röttger]

Hi,

i tried pgagent as you suggested and it works well. I searched for another
solution, because i wanted to reduce the maintenance work on the server
(install, config autostart, etc.). The problem with triggers is, that i
have a lot of points and the changes should be triggered to start the
analysis. This has to be done everytime a point changes and takes some
time. Thats why i thought to do it periodically.

Thanks for helping


> If you don't mind doing it by event instead of time you can use a
> database trigger. Example, for each new point the trigger happens and
> adds the info you need. That way there is never a point without the
> information.
>
> That's 100% in postgres as is.
>
> Enjoy,
> Alex
>
>
> On 04/05/2013 02:36 AM, Christian Röttger wrote:
> > Thanks,
> >
> > i will give it a try. Maybe you have some good documentation for me, but
> i
> > will see what google has for me.
> >
> > So there is no build in solution, only the way of installing or
> configuring
> > additional packages, etc. which means "more" server maintenance ...
> >
> >
> > 2013/4/4 Fred Lehodey <lehodey at gmail.com<http://mc/compose?to=lehodey@gmail.com>
> >
> >
> >> http://www.pgadmin.org/download/pgagent.php
> >>
> >>
> >>
> >>
> >> On Thu, Apr 4, 2013 at 4:11 PM, Christian Röttger <
> chris.roettger at web.de <http://mc/compose?to=chris.roettger@web.de>>wrote:
> >>
> >>> Hi,
> >>>
> >>> sorry this question is more postgresql related, but maybe here is
> >>> somebody with postgres skills :) I wrote a function which should be
> >>> launched maybe every hour, or just once a night. Is there a
> possibility to
> >>> start this function directly in postgresql and not in a workaround
> like a
> >>> cronjob?
> >>>
> >>> The background is that i have some point and line tables and wrote a
> >>> function which assigns the points in a specific distance to the lines.
> >>>
> >>>
> >>> Greets
> >>> Christian
> >>>
> >>> _______________________________________________
> >>> Qgis-user mailing list
> >>> Qgis-user at lists.osgeo.org<http://mc/compose?to=Qgis-user@lists.osgeo.org>
> >>> http://lists.osgeo.org/mailman/listinfo/qgis-user
> >>>
> >>>
> >>
> >
> >
> >
> > _______________________________________________
> > Qgis-user mailing list
> > Qgis-user at lists.osgeo.org<http://mc/compose?to=Qgis-user@lists.osgeo.org>
> > http://lists.osgeo.org/mailman/listinfo/qgis-user
> >
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org <http://mc/compose?to=Qgis-user@lists.osgeo.org>
> http://lists.osgeo.org/mailman/listinfo/qgis-user
>
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20130410/428c103a/attachment.html>