Postgres 8.4 in karmic does not upgrade 8.3 cluster or include instructions on how to do so
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
postgresql-8.4 (Ubuntu) |
New
|
Undecided
|
Unassigned |
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@
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/
autarch@
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/
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.