Bacula-users

Re: [Bacula-users] Reducing the size of the database.

2008-10-21 14:19:42
Subject: Re: [Bacula-users] Reducing the size of the database.
From: "John Drescher" <drescherjm AT gmail DOT com>
To: "Bacula-users AT lists.sourceforge DOT net" <Bacula-users AT lists.sourceforge DOT net>
Date: Tue, 21 Oct 2008 14:16:53 -0400
> You have to run:
>
> echo "16" |dbcheck -b -f -c /path/to/bacula-dir.conf -C dbname workingdir
> vacuumdb -q -d dbname -z -f
> reindexdb -q dbname
>
> After running these commands my database size was reduced from 10 GB to 8.0 
> GB.
>
Just did this on my postgresql database. It went from 22.5 GB to 27 GB
(during the process) and then to 17 GB so the reindexing did help.

Thanks,
John

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users