"S.Thanga Prakash" <thanga@midascomm.com> writes:
> We are already in the process of migrating toward 8.1 .
> For existing support, we like to support with 7.1.3 .
No, just stop right there; your reasonable-sounding premise is utterly
not reasonable. You should be making every possible effort to get any
existing 7.1 databases decommissioned. NOW. Not tomorrow, not next
week. If you have data that is critical enough to worry about having a
transition process, get it out of there. Expending further effort to
"support" continued use of an inherently unreliable database is a
disservice to your customers. Sooner or later it *will* eat their data.
(Not "might"; WILL. Are you familiar with the XID wraparound problem?)
You've been warned.
regards, tom lane
PS: if you have application compatibility issues that prevent an
immediate migration to 8.*, consider using PG 7.2.8 as a stopgap
solution. 7.2.* is not supported anymore either, but at least it
avoids the XID wraparound gotcha; and the later 7.2.* releases fix
a lot of other critical bugs.