bd_pgsql_purge(8) [debian man page]

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  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_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							 BD_PGSQL_PURGE(8)

WEEKLY(5)						      BSD File Formats Manual							 WEEKLY(5)

NAME

     weekly, weekly.conf -- weekly maintenance

DESCRIPTION

     The /etc/weekly script is run, by default, every Saturday morning on a NetBSD system.  The /etc/weekly.conf file specifies which of the stan-
     dard weekly services are performed.

     The variables described below can be set to ``YES'' or ``NO'' in the /etc/weekly.conf file.  The default settings are in the
     /etc/defaults/weekly.conf file.  (Note that you should never edit /etc/defaults/weekly.conf directly, as it is often replaced during system
     upgrades.)

     rebuild_locatedb  This rebuilds the locate(1) database, /var/db/locate.database, which must also exist, in order to be rebuilt.

     rebuild_mandb     This rebuilds the apropos(1) database /var/db/man.db, using makemandb(8) with the -f option.

     rebuild_whatisdb  This rebuilds the whatis(1) database(s).  Note that NetBSD provides a default whatis.db for the system manual pages and
		       this may not be needed.	(Adjust your /etc/man.conf as necessary; see man.conf(5) for details.)

FILES

     /etc/weekly	weekly maintenance script
     /etc/weekly.conf	weekly maintenance configuration
     /etc/weekly.local	local site additions to /etc/weekly

SEE ALSO

     daily.conf(5), monthly.conf(5)

HISTORY

     The /etc/weekly script first appeared in 4.3BSD.  The /etc/weekly.conf configuration file appeared in NetBSD 1.3.

BSD
								   March 6, 2012							       BSD