<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.0.9">
</HEAD>
<BODY>
Hello All,<BR>
<BR>
What is the best way to archive data from RT (using Postgres) say on a yearly basis. However, this data should be available at any point of time of read/search if required. <BR>
<BR>
Say, for e.g. -<BR>
If I have 5 years data in RT, which I do not require everyday, I would like to archive it yearly so that it does not slow the performance of my system. However, at the same time, if I have a request to look for some information in the archived data, I should be able to look at it immediately.<BR>
<BR>
Please suggest.<BR>
<BR>
Regards,<BR>
Ritu
<p>
<pre>
----------------------------------------------------------------
NETCORE SOLUTIONS *** Ph: +91 22 5662 8000 Fax: +91 22 5662 8134
MailServ and FlexiMail: Messaging Solutions: <a href="http://netcore.co.in">http://netcore.co.in</a>
Pragatee: Integrated Server-Software Suite: <a href="http://www.pragatee.com">http://www.pragatee.com</a>
Emergic Freedom: Server-centric Computing: <a href="http://www.emergic.com">http://www.emergic.com</a>
BlogStreet: Blog Profiles and RSS Ecosystem: <a href="http://blogstreet.com">http://blogstreet.com</a>
Deeshaa: Rural Development: <a href="http://www.deeshaa.com">http://www.deeshaa.com</a>
Rajesh Jain's Weblog on Technology: <a href="http://www.emergic.org">http://www.emergic.org</a>
----------------------------------------------------------------
</pre>
</BODY>
</HTML>