Hello, Just so everyone knows how I feel about SQLite -- it is a great program, written by a very good programmer. It is probably closer to Postgres than to MySQL in its syntax. However, it is really not an appropriate database for many reasons for Bacula, and maintaining the update tables scripts is very time consuming. I will continue to keep the source code as long as Sven and others contribute what is necessary to keep it working.
Now to the point of my email: There is a migration script in <bacula>/examples/database that should convert an SQLite database to Postgres. I have no idea if it works. If any of you have working scripts (I think I read about one recently), please attach it to a bug report (best way to ensure it is not lost). If I get any more scripts, I will happily commit them to the examples directory. Best regards, Kern On 4/30/19 8:03 AM, Josip Deanovic wrote: > On Monday 2019-04-29 14:36:07 Dimitri Maziuk via Bacula-users wrote: >> On 4/29/19 1:57 PM, Josip Deanovic wrote: >>> Because of the reasons Kern already wrote. >> Yes, but they have nothing to do with the question. > It does. It implies that it is not supported by the authors/maintainers > of the Bacula and therefore such setup is not future-proof. > > Not that I wouldn't like to see the SQLite continue although I don't > use it (I like to have as many options as possible) but if it complicates > maintenance and authors/maintainers are not ready to continue it, I > don't see any other option but discontinue as it would only hurt people > who try to use it and rely on it in the future while the support breaks > again and there will be nobody to fix it (the last good people from Debian > jumped in and made it work again). > > Maybe an effort is needed to help people to move from the SQLite > to mysql/postgres. E.g. some migration scripts or something. > I am not sure if those exist already. I think somebody said that > they don't exist. > > > Regards! > _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
