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

[Launchpad Bug Tracker]

This bug was fixed in the package update-manager - 1:0.152.25.4

---------------
update-manager (1:0.152.25.4) oneiric-proposed; urgency=low

  * DistUpgrade/removal_blacklist.cfg:
    - ensure that postgresql does not get removed (LP: #871893)

update-manager (1:0.152.25.3) oneiric-proposed; urgency=low

  * DistUpgrade/DistUpgradeCache.py:
    - fix crash when packages needs downgrading
  * UpdateManager/Core/utils.py:
    - do not crash if iptables does not exist, thanks to Daniel
      Holbach for reporting the issue (LP: #877514)
  * DistUpgrade/DistUpgradeQuirks.py:
    - keep poking the screensaver to ensure that it really won't
      activate during the upgrade (thanks to Jonathan Davies for
      the report)
  * tests/test_sources_list.py:
    - fix test (archive.ubuntu.com no longer listens to ftp)
  * po/*:
    - refresh again to fix regression (LP: #877461)
 -- Michael Vogt <michael.vogt at ubuntu.com>   Wed, 19 Oct 2011 09:52:08 +0200

** Changed in: update-manager (Ubuntu Oneiric)
       Status: Fix Committed => Fix Released

-- 
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:
  In Progress
Status in “update-manager” source package in Oneiric:
  Fix Released
Status in “update-manager” source package in Precise:
  In Progress

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