>>>>> On Wed, 07 Feb 2007 11:56:28 +0000, James Cort said:
>
> Juan Luis Frances wrote:
> > What version of bacula?
> >
> > I had the same problems with 1.38.5. I attach my "dirty" patch.
> >
> >
> Should have mentioned: it's 1.38.9 and running a Postgres backend.
Even if the database is 18GB on disk, it might be full of unused space.
I run the following script every night to solve this problem. Reindexing
weekly makes a huge difference for Postgres 7, but may not be needed for
Postgres 8.
#!/bin/sh
#
# shell script to keep Bacula PostgreSQL database at a reasonable size
#
bindir=/usr/local/bin
full=""
if test `date +%u` = "7"; then
full="--full"
for index in file_filenameid_idx file_jobid_idx file_jpfid_idx
file_pathid_idx file_pkey; do
echo "Reindexing $index"
$bindir/psql -c "reindex index $index;" -U pgsql bacula
done
fi
if $bindir/vacuumdb -U pgsql $full --analyze --verbose bacula; then
echo "Vacuuming of Bacula PostgreSQL database succeeded."
else
echo "Vacuuming of Bacula PostgreSQL database failed."
fi
exit 0
__Martin
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier.
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
