Hello Michel
I've created some scripts to do this job.
https://github.com/wanderleihuttel/bacula-utils/tree/master/convert_mysql_to_postgresql
I only had some troubles with the Log table, but I've changed some
registries manually and everything worked fine.
A guy in Brazil with a database with 6gb used these scripts and had no
problems
Regards
*Wanderlei Hüttel*
http://www.huttel.com.br
2017-11-28 8:19 GMT-02:00 Martin Simmons <mar...@lispworks.com>:
> >>>>> On Mon, 27 Nov 2017 19:13:15 +0000, Michel Figgins said:
> >
> > Hello,
> > I'm trying to migrate from a mysql backend to a postgresql backend
> and I'm getting an error importing the RestoreObject table. Specifically
> I'm getting :
> > ERROR: invalid input syntax for type bytea
> > LINE 1: ...bjectCompression) VALUES (1588,'job_metadata.xml','<B\
> 0A\0C\...
> > Googling around leads me to believe that Postgres isn't liking the
> format of RestoreObject field, but I'm stumped as to how to change it.
> > So my questions: Can anyone suggest a way to modify the INSERT
> statement to one Postgres will understand?
>
> You will need to munge MySQL's output for the RestoreObject.RestoreObject
> column into either bytea hex or escape format (see
> https://www.postgresql.org/docs/9.6/static/datatype-binary.html).
>
>
> > Do I actually need to import this table, or will the entries get
> re-populated as successful backups are completed?
>
> Yes, I think you do need to import it if you want to be able to restore
> these
> jobs. It stores per-job information including Windows VSS data, but maybe
> other things as well.
>
> __Martin
>
> ------------------------------------------------------------
> ------------------
> 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
