Michael Fuhr <mike@xxxxxxxx> writes: > On Sat, Apr 09, 2005 at 02:46:01AM -0700, goa wrote: >> We had developed some apllication with postgres-7.0.3-8 as back end >> now that we have upgraded all our servers to redhat9.0,also we cannot >> use new version of postgres since there is some issues with date fields >> which we use of postgres-7.0 > Could you elaborate on those issues? 7.0.3 is over four years > old -- aside from new functionality in later releases, there have > been numerous bug fixes since then. You really should consider > using a newer version; I'm sure the people on these lists would be > willing to help solve whatever problems that might cause. The oldest version that the community considers even slightly supported is 7.2.*. 7.1.* and before have fundamental, unfixable data-loss risks (for instance, after 4 billion transactions you WILL lose all your data in 7.0.*). So you would be far better advised to spend your effort on fixing your application to make it play with a current PG release than on trying to recompile such an ancient release. BTW, with my Red Hat hat on, I would say that RHL9 is about equally obsolete. Why aren't you updating to a more modern platform, if you're troubling to update at all? regards, tom lane
