The "quick fix" would seem to be scheduling a cron job that sends a query like
this to the InterMapper database:
DELETE FROM event WHERE end_time < now() - '30 days'::interval CASCADE;
(adjusting the interval as appropriate - the formatting is very friendly and
described in the Postgres manual @
http://www.postgresql.org/docs/8.4/static/datatype-datetime.html#DATATYPE-INTERVAL-INPUT)
(I haven't looked, but I assume this is essentially what the maintenance page
does...)
-MG
On Jun 14, 2012, at 10:14 AM, dschnur wrote:
>
> Currently, no, retention policies don't govern events. That capability is
> something we're planning to add, though, as we see customer databases growing
> larger. It will likely take the form of an additional setting for each
> policy, just like the existing raw/5-minute/hourly/daily settings.
>
> Until then you can delete events past a certain age via the maintenance page,
> but there's no way to schedule that action.
>
> There might be a different way to approach this, but I need to do a little
> research before I can answer. Please send mail to [email protected],
> and mention this forum post in the body. The resulting support ticket will
> be passed to me, and I can explain further.
>
> David
>
> -----------
> David Schnur
> Dartware, LLC
>
>
> -------------------- m2f --------------------
>
> Read this topic online here:
> http://forums.intermapper.com/viewtopic.php?p=4107#4107
>
>
>
>
>
> ____________________________________________________________________
> List archives:
> http://www.mail-archive.com/intermapper-talk%40list.dartware.com/
> To unsubscribe: send email to: [email protected]
>
____________________________________________________________________
List archives:
http://www.mail-archive.com/intermapper-talk%40list.dartware.com/
To unsubscribe: send email to: [email protected]
