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 <[email protected]> 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 <[email protected]> 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 <[email protected]> >> wrote: >> > Does OTRS have a tool that you used to move the data? >> > >> > >> > On Thu, Mar 28, 2013 at 5:12 PM, aledr <[email protected]> >> > 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 --------------------------------------------------------------------- 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
