Because people find nice to have a logo in your email signature, I have some tickets with more than 300 attachments... Most of them are repeated logos in mail signature... That's odd.
Enviado do meu Telefone LG ------ Mensagem original------ De: Edson Richter Data: qua, 20 de fev de 2019 15:20 Para: Never Min;User questions and discussions about OTRS.; Cc: Assunto:Re: [otrs] OTRS 5 migration from MySQL to PostgreSQL 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://eur03.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%7Cdf2bcabb40ce4ac9a96e08d697602796%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636862836572447510&sdata=%2BUamla3BtIUcYKJ82OfpI8YC%2FsCwfeQQeaY%2F8uzfzZc%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://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fotrs.org%2F&data=02%7C01%7C%7Cdf2bcabb40ce4ac9a96e08d697602796%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636862836572457509&sdata=kVb9%2F3KLMJZE%2BfQU%2FeMT6iZEBX%2FVDsGlVQYAsm4%2FpUI%3D&reserved=0> Archive: http://lists.otrs.org/pipermail/otrs<https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Flists.otrs.org%2Fpipermail%2Fotrs&data=02%7C01%7C%7Cdf2bcabb40ce4ac9a96e08d697602796%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636862836572467527&sdata=dQnABqQR93T6JM7R%2BMm6B6%2Bg9X2Se4oR9ixNTtu45JQ%3D&reserved=0> To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs<https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Flists.otrs.org%2Fmailman%2Flistinfo%2Fotrs&data=02%7C01%7C%7Cdf2bcabb40ce4ac9a96e08d697602796%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636862836572477532&sdata=WhmM4IlJyeDg6hCnlRq30KeV0UotPlDxPHnHhEkuSo4%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
