Hello, My Setup: bacula-1.38.8 Catalog on PostgreSQL 8.0 Server File Storage
I'm seeing my Catalog Database getting larger and larger. the "file" table has >45 million records now and uses over 10GB on disk. Doing a "list jobtotals" shows only about 5 million files total. (this looks much more realistic than 45millions) It seems, that for some reason, file entries (and maybe others too) are not pruned from the catalog. Calling "prune files client=xxx" gives a "No files to prune". As I've seen in the database, there are records for Clients, which are no more in the configuration of bacula-dir. Is it possible, either from bconsole or with some great SQL query, to make some sort of database cleanup and delete such unused entries from catalog ? You may imagine, that playing around with some SQL-Queries is a very time- and memory- consuming task on this (45000000 row) table. I would appreciate any help, regards -- Ing. Wolfgang Powisch System Engineer next layer Telekommunikationsdienstleistungs- und Beratungs GmbH tel: +43 664 3176411 | fax: +43 59966 366 1329 | web: www.nextlayer.at my layers: Unix | Linux | HA | Mail | Web | SOAP | XML | Softwaredesign ------------------------------------------------------------------------- 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
