bd_pgsql_purge(8) summarizer script for bandwidthd (postgresql mode)

DESCRIPTION

This program generatet the SQL code that should be run in certain intervals to summarize the data collected by bandwidthd (in postgresql mode) and purge the detailed records. The program itself only generates the SQL code. You need to feed it to your postgresql server yourself, which can be done by piping the output to the psql program. Adding a crontab script that runs weekly and cleans up the database is recommended.

FILES

/usr/sbin/bd_pgsql_purge                - the script to generate sql code
/etc/cron.weekly/bandwidthd-pgsql       - default schedule for bd_pgsql_purge

AUTHOR

This manual page was written by Andreas Henriksson <[email protected]>, for the Debian GNU/Linux system.