[Qgis-user] start Postgresql/Postgis function automatically

[pcreso at pcreso.com]

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 <tech_dev at wildintellect.com> wrote:

From: Alex Mandel <tech_dev at wildintellect.com>
Subject: Re: [Qgis-user] start Postgresql/Postgis function automatically
To: Qgis-user at lists.osgeo.org
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 <lehodey at 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>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://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
>

_______________________________________________
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/20130408/c4081b11/attachment.html>