Re: postgres help - Mailing list pgsql-admin

From Tom Lane
Subject Re: postgres help
Date
Msg-id 22298.1113200758@sss.pgh.pa.us
Whole thread Raw
In response to Re: postgres help  (Michael Fuhr <mike@fuhr.org>)
List pgsql-admin
Michael Fuhr <mike@fuhr.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

pgsql-admin by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Automatically updating pg_hba.conf
Next
From: Theo Galanakis
Date:
Subject: Mysql to postgres