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
