--- title: 'USN-933-1: PostgreSQL vulnerability | Ubuntu security notices' description: Ubuntu is an open source software operating system that runs from the desktop, to the cloud, to all your internet connected things. url: https://ubuntu.com/security/notices/USN-933-1 --- 1. [Ubuntu Security Notices](https://ubuntu.com/security/notices) 2. USN-933-1 --- # USN-933-1: PostgreSQL vulnerability Publication date 28 April 2010 Overview PostgreSQL vulnerability Releases [9.10](https://ubuntu.com/security/notices?release=karmic) [9.04](https://ubuntu.com/security/notices?release=jaunty) [8.04](https://ubuntu.com/security/notices?release=hardy) [6.06](https://ubuntu.com/security/notices?release=dapper) --- Open side navigation ## Packages * [postgresql-8.1](https://ubuntu.com/security/cves?package=postgresql-8.1) - * [postgresql-8.3](https://ubuntu.com/security/cves?package=postgresql-8.3) - * [postgresql-8.4](https://ubuntu.com/security/cves?package=postgresql-8.4) - ## Details It was discovered that PostgreSQL did not properly sanitize its input when using substring() with a SELECT statement. A remote authenticated attacker could exploit this to cause a denial of service via application crash. ## Update instructions In general, a standard system upgrade is sufficient to effect the necessary changes. [Learn more about how to get the fixes.](https://ubuntu.com/security/cves/about#security) The problem can be corrected by updating your system to the following package versions: | Ubuntu Release | Package Version | | --- | --- | | 9.10 karmic | [postgresql-8.4](https://launchpad.net/ubuntu/+source/postgresql-8.4) –  [8.4.3-0ubuntu9.10.1](https://launchpad.net/ubuntu/+source/postgresql-8.4/8.4.3-0ubuntu9.10.1) | | | | 9.04 jaunty | [postgresql-8.3](https://launchpad.net/ubuntu/+source/postgresql-8.3) –  [8.3.10-0ubuntu9.04.1](https://launchpad.net/ubuntu/+source/postgresql-8.3/8.3.10-0ubuntu9.04.1) | | | | 8.04 hardy | [postgresql-8.3](https://launchpad.net/ubuntu/+source/postgresql-8.3) –  [8.3.10-0ubuntu8.04.1](https://launchpad.net/ubuntu/+source/postgresql-8.3/8.3.10-0ubuntu8.04.1) | | | | 6.06 dapper | [postgresql-8.1](https://launchpad.net/ubuntu/+source/postgresql-8.1) –  [8.1.20-0ubuntu0.6.06.1](https://launchpad.net/ubuntu/+source/postgresql-8.1/8.1.20-0ubuntu0.6.06.1) | | | --- ### Reduce your security exposure Ubuntu Pro provides ten-year security coverage to 25,000+ packages in Main and Universe repositories, and it is free for up to five machines. [Get Ubuntu Pro](https://ubuntu.com/pro) ## References * [CVE-2010-0442](https://ubuntu.com/security/CVE-2010-0442)