Kern Sibbald wrote:
> On Monday 06 February 2006 18:04, Russell Howe wrote:
> 
>>Well, the time is nigh. Our SQLite database has hit 1.3GB and creates a
>>900MB dump file, which is big enough to cause our bacula Xen virtual
>>machine to run out of space when running a catalog backup.
>>
>>We have a Postgres (7.4) server with plenty of space, so I thought I'd
>>try importing the catalog into that.. things didn't go so smoothly, so I
>>ended up knocking up a script to do the import.
>>
>>I haven't actually tested this yet, so it's probably broken and riddled
>>with bugs. Still, enjoy :)
> 
> I've added this to the examples/dbdump directory -- perhaps not the most 
> obvious place.  If you ever have an update, please send it to me.
> 
> Thanks for the contribution, in addition to your regular Bacula list spam 
> filtering work :-)

heh, I should add that the script is pretty broken. I've got a more up
to date version at http://siksai.co.uk/~rhowe/software/sqlite2pgsql but
it's still not quite right.

Still, it may make the transition slightly less painful for anyone else
who has to do it. In the end, I blew our catalog away after getting
complaints from SQLite about the database file being corrupt. I started
afresh with Postgres. We were switching to a new drive and a whole new
set of tapes, so the catalog was only of historical interest in case we
needed to restore from a while back. In about 4 months, it would be
rendered completely useless.

I'm tempted to knock up yet another web interface to the database,
however, so you might see some Java stuff from me in the not too distant
future.

-- 
Russell Howe
[EMAIL PROTECTED]


-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Reply via email to