[rt-users] Migration to a new server

[Jourdan Perla]

That's the way to do it.

Just a warning. You will overwrite all the tickets on your new server, so I hope you're not in production yet.

From: rt-users-bounces at lists.bestpractical.com [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Sergio Mesquita
Sent: Friday, April 05, 2013 9:22 AM
To: Gary Mason
Cc: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] Migration to a new server

Hello Gary!
The better way it´s to dump your database.
After that, you need to upload to the new server, and finaly use the comand make upgrad database.
I upgrade my server from 3.6.0 to 4.0.10.
Works like a charm.

2013/4/5 Gary Mason <g.mason at fairfx.com<mailto:g.mason at fairfx.com>>
Hi,

I have inherited an RT 3.6.7 system with around 300,000 tickets in it, taking up about 40GB of disk space.

The hardware this runs on is getting on a bit, and response times are now getting to the frustratingly slow point.

I have a new server (Debian Squeeze) on which I have managed to get RT 4.0.7 up and running via backports PPA.  I have managed to include all the configuration and scrips from the existing system, and have created a few tickets in order to be able to demonstrate the updated UI/reporting/graphs etc to the helpdesk team.  People here are impressed :)

My problem is that I have been asked to migrate all the current tickets over to the new system in order to retain history.  I have next to no postgresql knowledge and am at a loss as to how to do this. I have briefly looked at the migration documents online, but I can't find anything that resembles a "run this script, point it to the current and new installations, cross your fingers and hold your breathe ..." type of migration script that would be so useful.

Is there anything that I can read, or can anyone offer some suggestions, as to how I can get the ticket information from the current to the new server ?

Thanks,
Gary



--
Cumprimentos/Mit freundlichen Gruss/Best Regards

Sergio Mesquita
Phone:
e-mail:sergio.mesquitaa at gmail.com<mailto:e-mail%3Asergio.mesquitaa at gmail.com>
www.gmail.com<http://www.gmail.com>
------------------------------------------------------------------------------
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20130405/c5fe9e52/attachment.htm>