Finally got some time to poke at this again. pgloader looked promising, but almost immediately I ran into problems with it not understanding some of SQLite's types:
What I am doing here? > At > int8 > ^ (Line 1, Column 3, Position 3) > In context SQLITE-TYPE-NAME: > While parsing SQLITE-TYPE-NAME. Problem: > The production > #\8 > does not satisfy the predicate ALPHA-CHAR-P. I haven't tried to manually specify a cast yet, but I was curious if anyone else had run into this. On Fri, May 10, 2019 at 11:08 AM Dimitri Maziuk via Bacula-users < bacula-users@lists.sourceforge.net> wrote: > On 5/9/19 5:41 PM, David Brodbeck wrote: > > On Wed, May 1, 2019 at 3:14 PM Phil Stracchino <ph...@caerllewys.net> > wrote: > > >> Surely you could have just bscanned the media you had? > >> > > ... Obviously now that > > the SQLite rug is going to be pulled out from under me I may have to > > revisit the bscan idea. > > I haven't tried this myself, this is purely theoretical, etc., etc., but > there's this: https://github.com/dimitri/pgloader -- just don't delete > the dump file at the end of catalog backup job, create postgres database > using bacula's scripts, and see if you can get that dump file in. > > Of course if you only have a couple of volumes, on-disk, bscan'ing them > in will be faster. > -- > Dimitri Maziuk > Programmer/sysadmin > BioMagResBank, UW-Madison -- http://www.bmrb.wisc.edu > > _______________________________________________ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users > -- David Brodbeck System Administrator, Department of Mathematics University of California, Santa Barbara
_______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
