Public bug reported:
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:
auta...@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:
auta...@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.
** Affects: postgresql-8.4 (Ubuntu)
Importance: Undecided
Status: New
--
Postgres 8.4 in karmic does not upgrade 8.3 cluster or include instructions on
how to do so
https://bugs.launchpad.net/bugs/463355
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
--
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs