Re: [otrs] Database Conversion from MySQL to PostgreSQL

It seems faster, but we've made no performance tests at all. We moved fo the sake of simplicity (keeping just one RDBMS to maintain). On Thu, Mar 28, 2013 at 2:12 PM, Bogdan Iosif wrote:

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

--------------------------------------------------------------------- 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