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

[Launchpad Bug Tracker]

** Branch linked: lp:~ubuntu-core-dev/update-manager/oneiric

-- 
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:
  In Progress
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