Thanks for the helpful advice. It sounds like an issue with timestamp translation, though I am far from a database expert.
I am working on the same approach, pgloader to postgresql. I do not do incrementals, so that particular issue will not be a problem here. Of course, full backups five times/week probably contributes to the 5GB size of the database, which adds challenges of its own. If my energy holds up and my to-do list is not too long, I hope to post a summary here when complete. Ken -----Original Message----- From: David Brodbeck [mailto:brodb...@math.ucsb.edu] Sent: Wednesday, January 13, 2021 5:46 PM To: bacula-users Subject: Re: [Bacula-users] sqlite to postgres|maridb migration -- how to confirm success? 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
