Re: [Bacula-users] Want to run dbcheck but can't because of database size

2007-02-12 Thread James Cort
Juan Luis Frances wrote: Now the correct patch, sorry ;-) El Wednesday 07 February 2007 12:29:40 Juan Luis Frances escribió: What version of bacula? I had the same problems with 1.38.5. I attach my dirty patch. Many thanks for your patch. I compiled it, and it's been running

Re: [Bacula-users] Want to run dbcheck but can't because of database size

2007-02-12 Thread Yann Cezard
James Cort a écrit : Many thanks for your patch. I compiled it, and it's been running against my database since last Thursday. It's still going. I've long since lost count of how many records it's cleared out, but the database backup is slowly shrinking. Hi, Personnaly I resolved

[Bacula-users] Want to run dbcheck but can't because of database size

2007-02-07 Thread James Cort
Dear All, My database has grown in size to the point where it's now 18GB. I'd like to see if that can be pruned at all, but unfortunately my box only has 1GB of RAM and dbcheck fails rather horribly with an out of memory error when doing check for orphaned file records: Checking for orphaned

Re: [Bacula-users] Want to run dbcheck but can't because of database size

2007-02-07 Thread Juan Luis Frances
What version of bacula? I had the same problems with 1.38.5. I attach my dirty patch. El Wednesday 07 February 2007 12:15:50 James Cort escribió: Dear All, My database has grown in size to the point where it's now 18GB. I'd like to see if that can be pruned at all, but unfortunately my

Re: [Bacula-users] Want to run dbcheck but can't because of database size

2007-02-07 Thread Juan Luis Frances
Now the correct patch, sorry ;-) El Wednesday 07 February 2007 12:29:40 Juan Luis Frances escribió: What version of bacula? I had the same problems with 1.38.5. I attach my dirty patch. El Wednesday 07 February 2007 12:15:50 James Cort escribió: Dear All, My database has grown in size

Re: [Bacula-users] Want to run dbcheck but can't because of database size

2007-02-07 Thread Alan Brown
On Wed, 7 Feb 2007, James Cort wrote: I'd like to see if that can be pruned at all, but unfortunately my box only has 1GB of RAM and dbcheck fails rather horribly with an out of memory error when doing check for orphaned file records: More ram is cheap, if your box can fit it... Checking

Re: [Bacula-users] Want to run dbcheck but can't because of database size

2007-02-07 Thread Alan Brown
On Wed, 7 Feb 2007, Juan Luis Frances wrote: What version of bacula? I had the same problems with 1.38.5. I attach my dirty patch. I had a more elegant solution for dbcheck which I keep meaning to send to Kern and it keeps getting buried. Basically it just uses Select count() for counting

Re: [Bacula-users] Want to run dbcheck but can't because of database size

2007-02-07 Thread James Cort
Juan Luis Frances wrote: What version of bacula? I had the same problems with 1.38.5. I attach my dirty patch. Should have mentioned: it's 1.38.9 and running a Postgres backend. Your patch should work though, as dbcheck.c hasn't changed between those two versions. I'll give it a go.