Hello Uwe I've made a script to migrate MySQL/MariaDB to PostgreSQL https://github.com/wanderleihuttel/bacula-utils/tree/master/convert_mysql_to_postgresql
I've found errors only in the Log table. I've looked for chars with wrong encoding and make an update in MySQL, did a dump and import again for PostgreSQL only this table Best regards *Wanderlei Hüttel* Em ter., 30 de ago. de 2022 às 13:44, Martin Simmons <mar...@lispworks.com> escreveu: > >>>>> On Tue, 30 Aug 2022 16:04:08 +0200, Uwe Schuerkamp said: > > > > Hello Charles, > > > > thanks for "INSERT only" idea... it's worked partially. After removing > > some double quotes and other characters using sed psql didn't like, > > the import runs for a while and then stops with the following error: > > > > INSERT 0 6 > > ERROR: duplicate key value violates unique constraint "status_pkey" > > DETAIL: Key (jobstatus)=(A) already exists. > > > > > > Any idea what could be causing this? > > That looks like the JobStatus table. Don't migrate that one because the > make_postgresql_tables script inserts all of the rows that are needed. > > __Martin > > > _______________________________________________ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users >
_______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
