DOKK / manpages / debian 11 / bandwidthd-pgsql / bd_pgsql_purge.8.en
BD_PGSQL_PURGE(8) System Manager's Manual BD_PGSQL_PURGE(8)

bd_pgsql_purge - summarizer script for bandwidthd (postgresql mode)

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.

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

bandwidthd(8) bandwidthd.conf(5) psql(1)

Furter information available at the website:
http://bandwidthd.sourceforge.net

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

8 Dec 2007