File: bd_pgsql_purge.8

package info (click to toggle)
bandwidthd 2.0.1%2Bcvs20090917-18
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid, trixie
  • size: 1,316 kB
  • sloc: sh: 3,010; ansic: 2,752; php: 1,263; yacc: 216; makefile: 152; lex: 36; sql: 27
file content (31 lines) | stat: -rw-r--r-- 973 bytes parent folder | download | duplicates (9)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
.TH BD_PGSQL_PURGE 8 "8 Dec 2007"
.SH NAME
bd_pgsql_purge - summarizer script for bandwidthd (postgresql mode)
.SH DESCRIPTION
.LP
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.
.br
.SH FILES
.nf
/usr/sbin/bd_pgsql_purge		- the script to generate sql code
/etc/cron.weekly/bandwidthd-pgsql	- default schedule for bd_pgsql_purge
.fi
.SH SEE ALSO
bandwidthd(8)
bandwidthd.conf(5)
psql(1)
.br
.sp
Furter information available at the website:
.br
.I http://bandwidthd.sourceforge.net
.SH AUTHOR
This manual page was written by Andreas Henriksson <andreas@fatal.se>, for
the Debian GNU/Linux system.