That's right what I need. But for some reason, during dry-run, while checking "article_attachment" I got "died" and process ends...
Do I need to increase process memory, change batch sizes, perhaps optimize the script somehow? I'm using OEL7 with unbreakable kernel with all updates. Perl interpreter is: v5.16.3 x86_64 The attachment_table has 19.3GB in size, with 249241 rows. Enviado do meu Telefone LG ------ Mensagem original------ De: Never Min Data: qua, 20 de fev de 2019 07:08 Para: User questions and discussions about OTRS.; Cc: Assunto:Re: [otrs] OTRS 5 migration from MySQL to PostgreSQL Hi, please see this link: https://doc.otrs.com/doc/manual/admin/5.0/en/html/installation-on-windows.html<https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdoc.otrs.com%2Fdoc%2Fmanual%2Fadmin%2F5.0%2Fen%2Fhtml%2Finstallation-on-windows.html&data=02%7C01%7C%7C9f4651e2b11245dbc6d708d6971b5908%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636862541051950398&sdata=GwZqUKW8SiqUu0B%2FXf%2FPc6he96weOVQFi9owensGySI%3D&reserved=0> -Never Edson Richter <edsonrich...@hotmail.com<mailto:edsonrich...@hotmail.com>> 于2019年2月20日周三 上午6:13写道： Our company uses PostgreSQL as standard database for everything (that needs one 😉 ). So, our OTRS 5 system is the last one based on MySQL. Since we are facing some OS update issues, we decided it is time to move. I would like to know if there is a easy way to migrate data: for instance, can I bakcup (using otrs backup/restore scripts) on MySQL and restore on PostgreSQL? Or can you point me the tables that are more critical? I’ve tried to migrate using pgLoader (it is a breeze), but some contente show strange caracters after migration. I’ll appreciate your guidance or share your experience! Atenciosamente, Edson Richter Soli Deo Gloria --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/<https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fotrs.org%2F&data=02%7C01%7C%7C9f4651e2b11245dbc6d708d6971b5908%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636862541051960409&sdata=S0Zrt%2FAyYYYuafAz8%2BX769GK4S0wNu7r%2BPPjGo7XNAQ%3D&reserved=0> Archive: http://lists.otrs.org/pipermail/otrs<https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Flists.otrs.org%2Fpipermail%2Fotrs&data=02%7C01%7C%7C9f4651e2b11245dbc6d708d6971b5908%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636862541051970414&sdata=fBG6R%2Fmcxa%2F09sYxkWlqZk%2FVzdzteCL2PRr9poR%2F7c4%3D&reserved=0> To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs<https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Flists.otrs.org%2Fmailman%2Flistinfo%2Fotrs&data=02%7C01%7C%7C9f4651e2b11245dbc6d708d6971b5908%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636862541051980426&sdata=ksnwWDOlr0Bj2h3IyAyWoXnpxW%2BHsI6vIueip4VXYFQ%3D&reserved=0>
--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs
