[Bug 871893] Re: After upgrading postgresql-databases are not accessible any more

[H H]

Kubuntu 32 bit, upgrade from Natty to Oneirc through do-upgrade.
In contrary to previous posts it seems that I have lost 2 databases during upgrade from Natty to Oneiric.

After upgrade folder /usr/lib/postgresql/9.1/main/base contains only 3 databases - template0, template1, postgres. 
There are no /usr/lib/postgresql/8.4/main/base folder where I had 2 important databases (one with personal finance data (Gnucash) ).
The original folder /usr/lib/postgresql/8.4/main/base contained 5 databases.

I didn't remember any clear warning or option to choose regarding what
will happen with postgresql during upgrade process..

I do Kubuntu upgrades earlier, and never lost databases, therefore didn't backuped myself.. 
You can call me careless (yes I will move database folder to home partition and start from now on using Cron+rsync to do database backups), but I still coudn't believe that developers allowed to loss Postgresql databases during standard upgrade ??????????????????????????? 
Really bitter lesson...

2 weeks ago I have moved to new laptop, and the old one still have
Natty, it saved me from the total disaster... but I spent 2 days trying
to figure out what am I do wrong during upgrade??? and still don't
know..

I probably leave this unresolved and agree to lost 2 weeks and reproduce
from old laptop databases at new Oneiric.

BTW. I must express my great dissapointment about Nepomuk/Strigi
behaviour after upgrade.. I must switch them off because they couldn't
end indexing process and calm down during 72 hours of usage ~100% of
CPU..

-- 
You received this bug notification because you are a member of Ubuntu
Foundations Bugs, which is subscribed to update-manager in Ubuntu.
https://bugs.launchpad.net/bugs/871893

Title:
  After upgrading postgresql-databases are not accessible any more

Status in “update-manager” package in Ubuntu:
  Fix Released
Status in “update-manager” source package in Oneiric:
  Fix Released
Status in “update-manager” source package in Precise:
  Fix Released

Bug description:
  - Install postgresql on 11.04, configure applications to access postgres
  - Upgrade from 11.04 to 11.10
  - none of the postgresql-databases are accessible any more.

  Here is one error message as given by a WEB application:
  Fatal error: Uncaught exception 'Zend_Exception' with message 'Fatal error: Can't connect to SQL server' in /opt/webacula/html/index.php:178
  Stack trace:
  #0 {main}
    thrown in /opt/webacula/html/index.php on line 178

  It looks like the postgresql-database is lost after upgrading. This is fatal. Not for a test sytem, but for a productive one!
  There are no instructions what to do before upgrading or after upgrading. The only Instructions found are those on the PostgreSQL web site. There are no warnings, no nothing. Absolutely bad. I suppose this a critical error and showstopper!

  ProblemType: Bug
  DistroRelease: Ubuntu 11.10
  Package: postgresql 9.1+122
  ProcVersionSignature: Ubuntu 3.0.0-12.20-virtual 3.0.4
  Uname: Linux 3.0.0-12-virtual x86_64
  ApportVersion: 1.23-0ubuntu3
  Architecture: amd64
  Date: Mon Oct 10 18:38:48 2011
  InstallationMedia: Ubuntu-Server 10.04.1 LTS "Lucid Lynx" - Release amd64 (20100816.2)
  PackageArchitecture: all
  ProcEnviron:
   PATH=(custom, user)
   LANG=en_US.UTF-8
   SHELL=/bin/bash
  SourcePackage: postgresql-common
  UpgradeStatus: Upgraded to oneiric on 2011-10-10 (0 days ago)

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/update-manager/+bug/871893/+subscriptions