This is probably a question for a PostgreSQL group, but I though users using 
bacula may have come across this problem.

I am using PostgreSQL for the database, last week when I checked, my database 
size was 10GB. I removed one month worth of volumes from the bacula database 
and ran dbcheck command. It deleted about 40,000 rows from the database, but 
the database size was still 10GB. Next, I ran postgresql vacuumdb (vacuumdb -q 
-d bacula -z -f)command to reclaim the space used by deleted rows, but the 
database size is still 10GB. How do I reduce the size of the database?

I also backup the catalog every night using pgdump command. Before I deleted 
the 40,000 rows the backup file size was 800MB, after deleting 40,000 rows the 
backup file size is still 800MB.


# df -h /baculaDB
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/VolGroup01-baculaDB
                      99G   11G   83G  12% /baculaDB


bacula=# select pg_database.datname, 
pg_size_pretty(pg_database_size(pg_database.datname)) as size from pg_database;
 datname  |  size   
-----------+---------
template1 | 4272 kB
template0 | 4272 kB
postgres  | 4272 kB
bacula    | 10 GB
(4 rows)


Hemant Shah
E-mail: hjrrs AT yahoo DOT com

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

-------------------------------------------------------------------------
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