USN-1229-1: PostgreSQL vulnerability

Ubuntu Security Notice USN-1229-1

13th October, 2011

postgresql-8.3, postgresql-8.4 vulnerability

A security issue affects these releases of Ubuntu and its derivatives:

  • Ubuntu 11.04
  • Ubuntu 10.10
  • Ubuntu 10.04 LTS
  • Ubuntu 8.04 LTS


PostgreSQL incorrectly handled blowfish passwords.

Software description

  • postgresql-8.3 - Object-relational SQL database
  • postgresql-8.4 - Object-relational SQL database


It was discovered that the blowfish algorithm in the pgcrypto module
incorrectly handled certain 8-bit characters, resulting in the password
hashes being easier to crack than expected. An attacker who could obtain
the password hashes would be able to recover the plaintext with less

Update instructions

The problem can be corrected by updating your system to the following package version:

Ubuntu 11.04:
postgresql-8.4 8.4.9-0ubuntu0.11.04
Ubuntu 10.10:
postgresql-8.4 8.4.9-0ubuntu0.10.10
Ubuntu 10.04 LTS:
postgresql-8.4 8.4.9-0ubuntu0.10.04
Ubuntu 8.04 LTS:
postgresql-8.3 8.3.16-0ubuntu0.8.04

To update your system, please follow these instructions:

In general, a standard system update will make all the necessary changes.