I'm using bareos 19.2.7 on openSUSE leap 15.2 and have used the bareos-dbcopy command to convert my bareos mySQL database into postgresql.
The whole process went fine without any issues. But when I did some checks inside of the pgSQL db I encountered the following error select * from file; ERROR: invalid byte sequence for encoding "UTF8": 0xab ← same error as before all the other tables do give me the expected result. I presume this is from the fact that my bareos mySQL db is having a character set of UTF8mb4. I'm not sure how to overcome above error as it seems there has not been a conversion from UTF8 on mySQL to the SQL_ASCII encoding that pgSQL is expected to use for bareos I have done test backups and restores and they are working fine. Can someone advice me what the best approach is before I actually move my bareos from mySQL to pgSQL. -- You received this message because you are subscribed to the Google Groups "bareos-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to bareos-users+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/bareos-users/0356bb07-1ca6-4169-a63e-eecfdff0466bn%40googlegroups.com.
