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