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

[Launchpad Bug Tracker]

You have been subscribed to a public bug:

- 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)

** Affects: update-manager (Ubuntu)
     Importance: High
     Assignee: Michael Vogt (mvo)
         Status: Triaged


** Tags: amd64 apport-bug oneiric
-- 
After upgrading postgresql-databases are not accessible any more
https://bugs.launchpad.net/bugs/871893
You received this bug notification because you are a member of Ubuntu Foundations Bugs, which is subscribed to update-manager in Ubuntu.