[rt-users] Restarting the Database

Mario Gomide mario.gomide at agricultura.gov.br
Tue Apr 8 09:39:27 EDT 2008


Hello list!!

I have installed RT 3.6.1 with Postgres8.1.

I'm needing to clean the ticket database for a fresh start on a new 
working season, but I need to keep the users, queues, custom-fields, etc.
What I'm planning to do is:
- Clean the tables: tickets, attachments, transactions, 
objectcustomfieldvalues and links;
- Set the Current Value to 1 for each one the sequences of the above tables.

Is this procedure ok? Is there anything else I must do (or must not) ?

Mario



More information about the rt-users mailing list