hi!

i am looking for a script that would re-sync my volumes and the
catalog as it is stored in the database (postgresql 8.1 in my case).

The volumes are full, so i try to get rid of some bloated, unnecessary backups.

after some manual probing and fiddling with the database, and some
auto-pruning (only the jobs, with the files still there even though i
thought they should get pruned just the same, as i configured it to do
that) i now have a catalog out of sync with the volumes, which are
still full. New backups fail with a "full" error.

so i want to get rid of all data on the volumes that is not referneced
in the catalog anymore.
furthermore i want to be able to get rid of entries in the catalog
where the files are not presents in the volumes anymore.

i do backups to disk-storage, so the script could do a find and then
go over the database and try to sync that with the files present, and
then remove the orphaned files.

i am not yet familiar with the layout of the database but i dont
imagine it would be so complicated to do.

i imagine i have to watch out for references to files in the catalog
when removing orphans. where would those be found and what should i do
about it?

/andreas

------------------------------------------------------------------------------
Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
-Strategies to boost innovation and cut costs with open source participation
-Receive a $600 discount off the registration fee with the source code: SFAD
http://p.sf.net/sfu/XcvMzF8H
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users