>>>>> 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