Query: bd_pgsql_purge
OS: debian
Section: 8
Format: Original Unix Latex Style Formatted with HTML and a Horizontal Scroll Bar
BD_PGSQL_PURGE(8) System Manager's Manual BD_PGSQL_PURGE(8)NAMEbd_pgsql_purge - summarizer script for bandwidthd (postgresql mode)DESCRIPTIONThis 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 your- self, 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_purgeSEE ALSObandwidthd(8) bandwidthd.conf(5) psql(1) Furter information available at the website: http://bandwidthd.sourceforge.netAUTHORThis manual page was written by Andreas Henriksson <andreas@fatal.se>, for the Debian GNU/Linux system. 8 Dec 2007 BD_PGSQL_PURGE(8)