This looks like a bug in pgloader's type parser so I don't think you fix it with a cast.
If this is being caused by the PathVisibility table then you could try to either delete that table if it is empty or alter its schema definition to use bigint instead of int8 and integer instead of int4. (I'm assuming you are working with a copy of the bacula.db file, not the live one.) __Martin >>>>> On Mon, 22 Jul 2019 17:03:12 -0700, David Brodbeck said: > > 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 < > [email protected]> wrote: > > > On 5/9/19 5:41 PM, David Brodbeck wrote: > > > On Wed, May 1, 2019 at 3:14 PM Phil Stracchino <[email protected]> > > 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 > > [email protected] > > https://lists.sourceforge.net/lists/listinfo/bacula-users > > > > > -- > David Brodbeck > System Administrator, Department of Mathematics > University of California, Santa Barbara _______________________________________________ Bacula-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/bacula-users
