Postgres 8.4 in karmic does not upgrade 8.3 cluster or include instructions on how to do so

Bug #463355 reported by Dave Rolsky on 2009-10-29
This bug affects 14 people
Affects Status Importance Assigned to Milestone
postgresql-8.4 (Ubuntu)

Bug Description

Binary package hint: postgresql-8.4

I upgraded to Karmic, which removed the postgresql-8.3 packages and upgraded to 8.4.

That's all fine, but along the way it simply initialized a new database, without upgrading my existing data, and I can't even find any docs explaining how to do this.

I tried this:

 autarch@houseabsolute:~$ sudo pg_upgradecluster -v 8.4 8.3 main
 Error: target cluster 8.4/main already exists

First, that required I re-install postgresql-8.3, then I got the error you see above.

Then, I tried moving /var/lib/postgresql/8.4/main out of the way and got:

 autarch@houseabsolute:~$ sudo pg_upgradecluster -v 8.4 8.3 main
 Error: specified cluster is not running

Hmm, should I start pg 8.3? I did that, then got the first error that the target cluster exists.

Finally, I figured out that I needed to have 8.3 running, then move both /etc/postgresql/8.4 and /var/lib/postgresql/8.4 out of the way entirely.

At the very least, new packages need clear instructions on how to migrate, although ideally this would be done automatically as part of the upgrade.

Upgrade instructions are in /usr/share/doc/postgresql-common/README.Debian.gz.

In version 8.4.2-2 of this package both this file and a (poor) summary of the upgrade is displayed during the package upgrade. These instructions could be made clearer.

For your particular problem you needed to stop and drop the 8.4 cluster before the upgrade.

This is real nuissance in Lucid, since you need 8.3 installed to do pg_upgradecluster and 8.3 gets uninstalled and unsupported when upgrading to Lucid. Do I really need to install 8.3 from the sources to be able to do this, or is there a better way?

Tim Keitt (tkeitt) wrote :

Agreed. This is a real pain. Did you end up installing from source?

No I just hoped for the best and installed the Karmic .deb packages. That worked ... thanks for asking.

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Duplicates of this bug

Other bug subscribers