[rt-users] Migration to a new server

ktm at rice.edu ktm at rice.edu
Fri Apr 5 12:22:25 EDT 2013

On Fri, Apr 05, 2013 at 05:16:44PM +0100, Gary Mason wrote:
> 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

Hi Gary,

There are README and UPGRADING documents that come in the source
distribution from Best Practical. You will need to follow those
documents to upgrade the current database.


More information about the rt-users mailing list