[CentOS-devel] Upgrading postgresql (Re: CentOS/RHEL 5.3)
charlieb-centos-devel at budge.apana.org.au
Thu Jan 22 16:00:17 UTC 2009
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.
More information about the CentOS-devel