Hello Georg!
These scripts were based in the manual chapter "*Converting from MySQL to
PostgreSQL*"
http://www.bacula.org/9.2.x-manuals/en/main/Installing_Configuring_Post.html#SECTION00445
I've converted my Bacula database (about 1gb a year ago) and I help another
community user to migrate a database around (5GB) and it worked fine!
I suggest you do this migration in a test environment first.
Then if is OK, run in production environment.
And if you have some difficulties don't hesitate to contact me
Thanks for this words Kern!
Best regards
*Wanderlei Hüttel*
http://www.bacula.com.br
Em qua, 8 de ago de 2018 às 07:47, Kern Sibbald escreveu:
> Wonderlei knows Bacula well and does good work, so I imagine his script
> could work well. However, I have not personally used it. I have asked
> to get a copy of the Bacula Systems script, but all the key players are
> currently on vacation.
>
> I recommend that you try it. You can have both MySQL and PostgreSQL
> installed on the same machine, so it is rather trivial to test. You
> just need to save your current Bacula configuration (trivial if you use
> /opt/bacula as recommended) and install a build of Bacula with posgres.
> Alternatively, simply install the postgres version in a different
> directory.
>
> Best regards,
> Kern
>
> On 08/08/2018 12:51 AM, George Anchev via Bacula-users wrote:
> > On Tue, 7 Aug 2018 14:45:15 -0300 Wanderlei Huttel
> > wrote:
> >
> >> If somebody wants to migrate from MySQL to
> >> PostgreSQL I've created a script to simplify this.
> >>
> https://github.com/wanderleihuttel/bacula-utils/tree/master/convert_mysql_to_postgresql
> > Thanks for sharing!
> >
> > Kern, could you please have a look and confirm if this
> > is would work with Bacula 9.2.0 catalog and
> > convert MariaDB to Postgres correctly?
> >
> > --
> > George
> >
> >
> --
> > Check out the vibrant tech community on one of the world's most
> > engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> > ___
> > Bacula-users mailing list
> > Bacula-users@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/bacula-users
> >
>
>
>
> --
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> ___
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
>
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
