Migrating from SQLite to Postgres seems to be hard to get right. There doesn't appear to be any reliable, officially sanctioned way to do it. I did it a while back with pgloader and thought I'd gotten it correct, but my next set of incrementals was huge because Bacula thought every single file had changed.
On Wed, Dec 30, 2020 at 2:05 PM Ken Johnson <kjohn...@eclypse.org> wrote: > For the benefit of anyone who reads this thread later, see dbcheck, > provided > as part of bacula. > > Ken > > > > -----Original Message----- > From: Ken Johnson [mailto:kjohn...@eclypse.org] > Sent: Tuesday, December 22, 2020 6:04 PM > To: bacula-users@lists.sourceforge.net > Subject: [Bacula-users] sqlite to postgres|maridb migration -- how to > confirm success? > > Hello, > > I am facing the sqlite to postgres or mariadb (mysql) migration of the > Bacula database. The current db file is about 5GB, after a vacuum. Right > now I think I will choose the one with the best migration tools I can get > for it. Otherwise, I do not know of a reason to care. I have done more > admin on mariadb, I have done more coding (not that much) using postgres. > On the server in question; both postgres and mariadb are already installed. > > I am aware of the two scripts from 2006 in examples/database/ in the source > distribution. > > I have just under 50 media in the database, with 10 stored offsite; bscan > is > not a usable option for me. > > > Here is my question: when I think the conversion is complete, what is the > best reasonable method to confirm the success of the conversion? > > > Thank you and best regards, > > Ken > > > > > > > > > > > _______________________________________________ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users > > > > _______________________________________________ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users > -- David Brodbeck (they/them) 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
