Man pages sections > man8 > bd_pgsql_purge

bd_pgsql_purge - summarizer script for bandwidthd (postgresql mode)

BD_PGSQL_PURGE(8) System Manager's Manual BD_PGSQL_PURGE(8)

NAME

bd_pgsql_purge - 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

SEE ALSO

bandwidthd(8) bandwidthd.conf(5) psql(1)
 
 
Furter information available at the website:
 
http://bandwidthd.sourceforge.net

AUTHOR

This manual page was written by Andreas Henriksson <andreas@fatal.se>, for the Debian GNU/Linux system.
 
8 Dec 2007 Debian Sid