do not automatically remove postgresql-* on dist upgrades
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
postgresql-8.3 (Ubuntu) |
Invalid
|
Undecided
|
Unassigned | ||
update-manager (Ubuntu) |
Fix Released
|
High
|
Michael Vogt |
Bug Description
Binary package hint: postgresql
Hello!
Today I've upgrade from 7.10 to 8.04, just by typing in the console:
$ gksudo "update-manager -d"
I had no troubles and now I'm running 8.04 version and everything is working as it should.
Anyway, in this upgrade I had also to upgrade my postgreSQL version. The problem is that when upgrading the database I've lost everything from the previous database in the previous version.
Anyway this could be avoided if only I've followed the upgrade instructions in http://
My question is that, when upgrading from the repositorie couldn't/shouldn't the upgrade manage to backup all the existing data and after upgrading restore it?
Best regards
I don't think that you lost your database entirely. Without knowing what you did exactly, I think this happened:
postgresql-8.2 is not supported in Ubuntu 8.04 any more, so update-manager suggested to remove the old postgresql-8.2 since it is in universe now. I take it you accepted this?
Without postgresql-8.2 installed, you cannot access/update your database any more.
You should install postgresql-8.2 again and verify that your 8.2 DB is present in "pg_lsclusters". Is it?