Re: [Bacula-users] sqlite to postgres|maridb migration -- how to confirm success?

2021-01-15 Thread Ken Johnson
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 wrote: For the benefit of anyone who reads this thread later, see dbcheck, provided

Re: [Bacula-users] sqlite to postgres|maridb migration -- how to confirm success?

2020-12-30 Thread Ken Johnson
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

[Bacula-users] sqlite to postgres|maridb migration -- how to confirm success?

2020-12-22 Thread Ken Johnson
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 mor