It is possible that this version already fixes the deadlock. However, everyone who experienced that in the past: If the hangs do not occur any more, then the logs should reveal the underlying error condition. Please watch out for 'multiple active vacuums for index' and 'out of btvacinfo slots' error messages in the logs.
postgresql-8.2 (8.2.3-2) experimental; urgency=low . * debian/control: Add Perl dependency to p-8.2-plperl, to ensure that creating plperl functions works (as opposed to plperlu, which only needs libperl). (see bug #412135) * debian/control: Do not mention nor suggest 'pgdocs' any more in p-doc's description since pgdocs is only available for 7.4. (see bug #405097) * debian/patches/04-timezone-symlinks.patch: - Use the timezone database from the system tzdata instead of shipping our own. Towards a single authoritative time zone database in Debian and Ubuntu... :) (LP: #41159) - Drop previous hardlink-to-symlink patch to zic, since that is irrelevant now. - debian/control: Add tzdata dependency. * Add debian/patches/12-vacuum-cycle-hang.patch: Properly release our semaphore lock before erroring out wit elog() to prevent deadlocks on vacuum errors. Thanks to Heikki Linnakangas! * debian/rules: Have a test suite failure fail the build again. Let's ignore the old kernels on the Debian mips[el] buildds for now. -- Postgres 8.2 on Feisty beta dies regularly https://launchpad.net/bugs/93042 -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs