For sanity, I'm moving attachments to file system...
Enviado do meu Telefone LG ------ Mensagem original------ De: Edson Richter Data: qua, 20 de fev de 2019 14:43 Para: Never Min;User questions and discussions about OTRS.; Cc: Assunto:Re: [otrs] OTRS 5 migration from MySQL to PostgreSQL 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://eur01.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%7Cb809a42b03954efff5cc08d6975aee4b%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636862814131873886&sdata=3ApXKJZja3i%2FZ%2FWoF5qvRjhz3m%2FsQitSH%2BbOVcMegos%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://eur01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fotrs.org%2F&data=02%7C01%7C%7Cb809a42b03954efff5cc08d6975aee4b%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636862814131883885&sdata=ozp9XslzGWK1wC2BTYqXEVAyL7wJraYxUEgJSdjwKlI%3D&reserved=0> Archive: http://lists.otrs.org/pipermail/otrs<https://eur01.safelinks.protection.outlook.com/?url=http%3A%2F%2Flists.otrs.org%2Fpipermail%2Fotrs&data=02%7C01%7C%7Cb809a42b03954efff5cc08d6975aee4b%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636862814131893890&sdata=Tt1Wev5xxpu8Bz%2F13AVieE%2B%2BX%2B83ZeaqDOCpi0xceyY%3D&reserved=0> To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs<https://eur01.safelinks.protection.outlook.com/?url=http%3A%2F%2Flists.otrs.org%2Fmailman%2Flistinfo%2Fotrs&data=02%7C01%7C%7Cb809a42b03954efff5cc08d6975aee4b%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636862814131903901&sdata=z%2ByCu5MfHy0mmSS1q7d0BTZVtLm0VkRi0lRPx4n7uQs%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
