[rt-users] Dump all except tickets+attachments?

Jeff Blaine jblaine at kickflop.net
Wed Aug 17 11:01:30 EDT 2011

Replying to my thread starter from a few months ago.

On 6/23/2011 11:32 AM, Jeff Blaine wrote:
> If anyone has any clever advice as to how to about this,
> I'd love to hear it.
> RT 3.8.7 + security patches, PostgreSQL 8.1.23, RHEL5
> We need to replicate our production RT instance's data
> to a development instance (yes, backward), but we don't
> want to carry the ~6GB of *ticket and attachment*
> data (what else?) over to development.
> Essentially, we want the same environment in development
> as production, but with empty queues.

Warning: Do not try this.  It seemed to work fine, then
weird things started popping up.  Instead, dump everything
from production, restore everything on the dev server,
then shred the tickets on the dev server.

More information about the rt-users mailing list