Bug#301883: asterisk: sqlite logging enabled by default and never rotated
John Goerzen
John Goerzen <jgoerzen@complete.org>, 301883@bugs.debian.org
Mon, 4 Apr 2005 15:03:02 -0500
On Mon, Apr 04, 2005 at 09:32:31PM +0200, Kilian Krause wrote:
> the query would be something like "delete from $mytable where
> $insertdate < $(today-1month)" with the variables holding the correct
> names etc.
>
> Yet I strongly disagree with this behaviour for a default. At least the
> 1 month rollback sounds like too few from a data-warehouse point of view
> and too much from a duty of secrecy point of view. The only real
> alternative sounds to be a debconf asking for the proper length.
The alternative could be to do a rotation scheme; SELECT records from
the source, INSERT them into the destination, then DELETE from the
source. But that gets more complex.
> Does that sound ok for everybody?
Sounds fine to me.
>
> --
> Best regards,
> Kilian