Re: Upgrade to Red Hat Linux 9 broke PostgreSQL

Absolutely.
Do a pg_dumpall before any version upgrade.

My point was that RH has screwed up many software packages lately by
switching to the new NPTL version of glibc. Not only is it in RH 9, but
they also replaced the libraries in RH 8.0. They recently patched the
new glibc and broke more things...

At least FreeBSD accepts patches, and implements them giving the
submitter credit withing a short time. I recently patched the
radiusd-cistron port to fix some problems that would cause core dumps,
and tidied up some uninitialized variables.

If the problem was just failure to backup the databases before
installing a new version of PG then, that is nobodies failt but the
administrator. Reading errata, and other standards docs before install
one would discover they needed to dump and delete before the upgrade
then restore the data afterwards.

The RH issues I was rerferenceing came with *NO* warnings that all sorts
of things would imminently be broken.

I am tired of people sticking up for RH's failure to do proper QA tests,
and there closed opensource ideas.


Guy

Lamar Owen wrote:

>On Tuesday 15 April 2003 14:23, Guy Fraser wrote:
>
>
>>What a mess...
>>RH has fouled up a lot of stuff lately...
>>I'm not even going to go there...
>>
>>
>
>It's as much a problem with other RPM-based distributions of Linux as it is
>with Red Hat.  And I am of the strong opinion that it is just as much the
>fault of the  way PostgreSQL forces upgrades as it is a fault with any
>particular distributor.
>
>Even a straight portupgrade on FreeBSD is broken.  It's a mess because of the
>way PostgreSQL needs to be upgraded.
>
>