Re: postgres help

Michael Fuhr <mike(at)fuhr(dot)org> 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