[CentOS-devel] Upgrading postgresql (Re: CentOS/RHEL 5.3)

Thu Jan 22 16:00:17 UTC 2009
Charlie Brady <charlieb-centos-devel at budge.apana.org.au>

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.