[rt-users] seperating queues (repost)

[Alek Cesarz]

repost as i got no answer so far... maybe nobody noticed... ((-;
>>
hello rt users,
i am happy rt user for 2 years or so, and run into a problem recently. i
hope that somebody will know how to solve it.

situation:
one RT2 instance running 4 main queues: TWS, nietypowe, abuse, problem.
first two are used internally and have something like 500 tickets total.
third one is used to catch incoming abuse reports and has 40 000
tickets. fourth is not used anylonger (we developed our own ticketing
system connected to CRM applications), but has 10 000 old tickets.
current db is postgres.

idea:
i want to:
1. install RT3 on 2 servers and migrate to mysql (it was reported to be
faster with rt).
2. import abuse to server 1.
3. import TWS and nietypowe to server 2.
4. tar/gzip/rm -rf the rest

problem:
i have no idea how to do it...

hope somebody will show me the tools or procedure on doing this.
best regards,
-- 
Alek Cesarz : NOD manager : ALEK1-RIPE
+48 22 860 69 60 : Crowley Data Poland