You might also look at PgAgent, part of the PgAdmin tool: http://www.pgadmin.org/download/pgagent.php
Allows similar functionality to cron with a db admin context. Brent Wood --- On Tue, 4/9/13, Alex Mandel <[email protected]> wrote: From: Alex Mandel <[email protected]> Subject: Re: [Qgis-user] start Postgresql/Postgis function automatically To: [email protected] Date: Tuesday, April 9, 2013, 4:03 AM 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 <[email protected]> > >> http://www.pgadmin.org/download/pgagent.php >> >> >> >> >> On Thu, Apr 4, 2013 at 4:11 PM, Christian Röttger >> <[email protected]>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 >>> [email protected] >>> http://lists.osgeo.org/mailman/listinfo/qgis-user >>> >>> >> > > > > _______________________________________________ > Qgis-user mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/qgis-user > _______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
_______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
