On Fri, 23 Jan 2009, John Summerfield wrote:
And then there's postgresql. One has to backup one's data before upgrading major postgresql releases and then restore into the new.
I consider that a major upstream bug.
However, at the least a %pre script should create an SQL dump before upgrading major releases, so user is not left with an unusable blob.
Better would be for postgresql to ship a standalone SQL dumper, which can read old file formats.