date:20190220

Re: [otrs] OTRS 5 migration from MySQL to PostgreSQL

2019-02-20 Thread Never Min

Hi,

please see this link:
https://doc.otrs.com/doc/manual/admin/5.0/en/html/installation-on-windows.html


-Never


Edson Richter  于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/
> Archive: http://lists.otrs.org/pipermail/otrs
> To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs
>
-
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs

Re: [otrs] OTRS 5 migration from MySQL to PostgreSQL

2019-02-20 Thread Edson Richter

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


-Never


Edson Richter 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/
Archive: 
http://lists.otrs.org/pipermail/otrs
To unsubscribe: 
http://lists.otrs.org/mailman/listinfo/otrs
-
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs

Re: [otrs] OTRS 5 migration from MySQL to PostgreSQL

2019-02-20 Thread Edson Richter

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


-Never


Edson Richter 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/
Archive: 
http://lists.otrs.org/pipermail/otrs
To unsubscribe: 
http://lists.otrs.org/mailman/listinfo/otrs
-
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs

Re: [otrs] OTRS 5 migration from MySQL to PostgreSQL

2019-02-20 Thread Edson Richter

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


-Never


Edson Richter 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/
Archive: 
http://lists.otrs.org/pipermail/otrs
To unsubscribe: 
http://lists.otrs.org/mailman/listinfo/otrs
-
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs

[otrs] RES: OTRS 5 migration from MySQL to PostgreSQL

2019-02-20 Thread Edson Richter

Thank you very much. It is wonderful how easy this script made my day.
The only think I’ll point is that documentation is far behind the PDF that you 
have access through the web interface.
Also, would be nice to add a suggestion for large installations to put all 
attachments on filesystem first – a “dry-run” will just die with 19Gb of 
attachments in mysql database (and I suspect that a migration also will die).


Atenciosamente,

Edson Richter



Soli Deo Gloria

De: otrs  Em nome de Never Min
Enviada em: quarta-feira, 20 de fevereiro de 2019 07:08
Para: User questions and discussions about OTRS. 
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


-Never


Edson Richter 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/
Archive: 
http://lists.otrs.org/pipermail/otrs
To unsubscribe: 
http://lists.otrs.org/mailman/listinfo/otrs
-
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs

[otrs] OTRS 5 - after CloneDB, all FAQ are without images (attachments?)

2019-02-20 Thread Edson Richter

  1.  I’ve moved all attachments to FS using the script.
  2.  Run the CloneDB to move from MySQL to PostgreSQL.
  3.  After, moved all files from FS from one server to the new server

When I look to tickets, images and attachments are normal.
When I look FAQ entries, no images are shown.

Any tip?

Atenciosamente,

Edson Richter



Soli Deo Gloria

De: otrs  Em nome de Edson Richter
Enviada em: quinta-feira, 21 de fevereiro de 2019 00:01
Para: User questions and discussions about OTRS. 
Assunto: [otrs] RES: OTRS 5 migration from MySQL to PostgreSQL

Thank you very much. It is wonderful how easy this script made my day.
The only think I’ll point is that documentation is far behind the PDF that you 
have access through the web interface.
Also, would be nice to add a suggestion for large installations to put all 
attachments on filesystem first – a “dry-run” will just die with 19Gb of 
attachments in mysql database (and I suspect that a migration also will die).


Atenciosamente,

Edson Richter



Soli Deo Gloria

De: otrs mailto:otrs-boun...@lists.otrs.org>> Em 
nome de Never Min
Enviada em: quarta-feira, 20 de fevereiro de 2019 07:08
Para: User questions and discussions about OTRS. 
mailto:otrs@lists.otrs.org>>
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


-Never


Edson Richter 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/
Archive: 
http://lists.otrs.org/pipermail/otrs
To unsubscribe: 
http://lists.otrs.org/mailman/listinfo/otrs
-
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs

Re: [otrs] OTRS 5 migration from MySQL to PostgreSQL

Re: [otrs] OTRS 5 migration from MySQL to PostgreSQL

Re: [otrs] OTRS 5 migration from MySQL to PostgreSQL

Re: [otrs] OTRS 5 migration from MySQL to PostgreSQL

[otrs] RES: OTRS 5 migration from MySQL to PostgreSQL

[otrs] OTRS 5 - after CloneDB, all FAQ are without images (attachments?)

6 matches

Site Navigation

Mail list logo

Footer information