Re: [otrs] Database Conversion from MySQL to PostgreSQL

28 Mar 2013

      An interesting and ingenious method. I was thinking you're using some ETL
tool.

I'm strongly considering doing the same switch as you did but I'm wary of
performance issues. Initially, I tried running OTRS on top of SQL Server
but Perl's database interface implementation for this RDBMS is very weak
(5x slower) compared to MySQL.

Did you run tests that showed PostgreSQL would be better performance-wise
or, if not, why did you move?

On Thu, Mar 28, 2013 at 6:55 PM, aledr  wrote:
...
Used mysqldump for data only;
Added 'set backslash_quote = on;' and 'set standard_conforming_strings
= off;' in the header of the dump file.
After that you need to create the PostgreSQL schema from OTRS scripts,
import your data, run OTRS post database script and adjust sequences
(you can generate the queries for that with py-mysql2pgsql and some
scripting).
Solved the article_attachment with otrs.ArticleStorageSwitch.pl.
Dropped files to filesystem, moved files to the new server and
imported to database again.
Thanks.
On Thu, Mar 28, 2013 at 12:18 PM, Bogdan Iosif 
wrote:
...
Does OTRS have a tool that you used to move the data?
On Thu, Mar 28, 2013 at 5:12 PM, aledr 
wrote:
...
Good day!
I'm moving my otrs installation from MySQL to PostgreSQL.
Almost everything went fine, except article_attachment table.
Is there any available instructions on how to move that data?
Thanks.
--
[ ]'s
Aledr - Alexandre
---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
--
[ ]'s
Aledr - Alexandre

OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs