Francisco Reyes writes: > Using Bacula 1.38.11 in FreeBSD 6.1 > Using disk volumes. > > I have a pool with a large set of Purged volumes, yet Bacula continues to > make new volumes in the pool.
Better queries. To get count. select count(*) from media where volstatus = 'Purged' and recycle = 1 and volretention/(3600*24) < (CURRENT_DATE-lastwritten::date)::int To see them select volumename,mediatype,firstwritten::date,lastwritten::date, labeldate::date,volstatus,recycle, volretention/(3600*24) as Retention, (CURRENT_DATE-lastwritten::date)::int as Age from media where volstatus = 'Purged' and recycle = 1 and volretention/(3600*24) < (CURRENT_DATE-lastwritten::date)::int limit 10; Anyone else using postgresql and disk volumes could try these queries to see if they are experiencing simmilar issues? On my setup I find 358 volumes which are purged, marked for recycle and with last_writen greater than the expiration date. This, in my case, adds up to 716GB of dead space!! ------------------------------------------------------------------------- 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
