Public bug reported:

I'm seeing a bug in both 8.4 and 9.1 after upgrading through do-release-
upgrade from lucid to precise.

Steps to Repro:

1) Install either 9.1 from pitti's repo, or use 8.4 in lucide
2) run do-release-upgrade
3) Skip the reboot
4) run the following

root@ubuntu:~# sudo -u postgres psql -l
could not change directory to "/root"
psql: FATAL:  database locale is incompatible with operating system
DETAIL:  The database was initialized with LC_COLLATE "en_US.UTF-8",  which is 
not recognized by setlocale().
HINT:  Recreate the database with another locale or install the missing locale.
root@ubuntu:~#

5) After restarting postgresql (or postgresql-8.4 if that is what you
are working with), everything is fine.

This causes problems for packages that use the database, as their
postinst will typically fail restarting the service.

** Affects: postgresql-9.1 (Ubuntu)
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to postgresql-9.1 in Ubuntu.
https://bugs.launchpad.net/bugs/1058218

Title:
  do-release-upgrade (lucid->precise) leaves postgres (8.4 & 9.1) in bad
  state.

Status in “postgresql-9.1” package in Ubuntu:
  New

Bug description:
  I'm seeing a bug in both 8.4 and 9.1 after upgrading through do-
  release-upgrade from lucid to precise.

  Steps to Repro:

  1) Install either 9.1 from pitti's repo, or use 8.4 in lucide
  2) run do-release-upgrade
  3) Skip the reboot
  4) run the following

  root@ubuntu:~# sudo -u postgres psql -l
  could not change directory to "/root"
  psql: FATAL:  database locale is incompatible with operating system
  DETAIL:  The database was initialized with LC_COLLATE "en_US.UTF-8",  which 
is not recognized by setlocale().
  HINT:  Recreate the database with another locale or install the missing 
locale.
  root@ubuntu:~#

  5) After restarting postgresql (or postgresql-8.4 if that is what you
  are working with), everything is fine.

  This causes problems for packages that use the database, as their
  postinst will typically fail restarting the service.

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/postgresql-9.1/+bug/1058218/+subscriptions

-- 
Mailing list: https://launchpad.net/~desktop-packages
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~desktop-packages
More help   : https://help.launchpad.net/ListHelp

Reply via email to