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

[Martin Pitt]

> Yes, the note is printed. But on a window 132x43 it takes half a
second and it is scrolled out of sight.

That also sounds weird. It is supposed to be a debconf note which stays
on the screen forever until you press Enter. How exactly did you
upgrade? With the graphical update program, apt-get, aptitude, do-
release-upgrade? Under Ubuntu (GNOME) or Kubuntu (KDE)?

-- 
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:
  Triaged
Status in “update-manager” source package in Oneiric:
  Triaged
Status in “update-manager” source package in Precise:
  Triaged

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