PostgreSQL 8.1
Read the English manualEnd of life · Recorded build 8.1.23 · 2010-12-16
This major branch is no longer supported. These records describe its history; the absence of newer security records does not establish that it is safe to run.
- First stable release
- 2005-11-08
- Support end
- 2010-11-08
- Indexed releases
- 0
- Original release-note entries
- 0
Manuals & provenance
PostgreSQL 8.1 English manual · 730 loaded pages.
Manual loaded 2026-09-27T00:10:47.078613.
Release entries: 2026-09-26. Security evidence: 2026-09-26. PDF links use the verified English manifest and locally available files. Lifecycle: PostgreSQL versioning policy.
Upgrade considerations
Major upgrades need a migration method such as dump/reload or pg_upgrade. Read the intervening major-release notes and the target manual. Minor updates can also require extra steps; review the specific release's migration notes. Official upgrade policy.
Structured release-note entries are not available for this branch. Consult its original manual.
Release history
Every indexed release keeps its original occurrences. CVE counts below are mentions in its notes, including follow-up corrections; they do not count newly fixed vulnerabilities.
No complete release entries are indexed for this branch. This does not mean it had no changes.
Security evidence
21 records from the official security matrix and release-note mentions. A fixed version is shown only when the security snapshot explicitly names this branch. A mention alone does not establish applicability or a new fix.
CVE-2010-3433 · An authenticated database user can manipulate modules and tied variables in some external procedural languages to execute code with enhanced privileges.Details
Fixed in this branch: 8.1.22.
Official affected-branch entry: 8.1.
CVE-2010-1975 · An unprivileged database user can remove superuser-only settings that were applied to his account with ALTER USER by a superuser, thus bypassing settings that should be enforced.
Fixed in this branch: 8.1.21.
Official affected-branch entry: 8.1.
CVE-2010-1170 · Insecure permissions on the pltcl_modules table could allow an authenticated user to run arbitrary Tcl code on the database server if PL/Tcl is installed and enabled.
Fixed in this branch: 8.1.21.
Official affected-branch entry: 8.1.
CVE-2010-1169 · A vulnerability in Safe.pm and PL/Perl can allow an authenticated user to run arbitrary Perl code on the database server if PL/Perl is installed and enabled.
Fixed in this branch: 8.1.21.
Official affected-branch entry: 8.1.
CVE-2009-4136 · Privilege escalation via changing session state in an index function. This closes a corner case related to vulnerabilities CVE-2009-3230 and CVE-2007-6600 (below).
Fixed in this branch: 8.1.19.
Official affected-branch entry: 8.1.
CVE-2009-4034 · NULL Bytes in SSL Certificates can be used to falsify client or server authentication. This only affects users who have SSL enabled, perform certificate name validation or client certificate authentication, and where the Certificate Authority (CA) has been tricked into issuing invalid certificates. The use of a CA that can be trusted to always issue valid certificates is recommended to ensure you are not vulnerable to this issue.
Fixed in this branch: 8.1.19.
Official affected-branch entry: 8.1.
CVE-2009-3230 · The fix for issue CVE-2007-6600 (below) failed to include protection against misuse of RESET SESSION AUTHORIZATION.
Fixed in this branch: 8.1.18.
Official affected-branch entry: 8.1.
CVE-2009-0922 · It is possible to cause a momentary denial of service when there is a failure to convert a localized error message to the client-specified encoding. A valid login is required to exploit this vulnerability.
Fixed in this branch: 8.1.17.
Official affected-branch entry: 8.1.
CVE-2007-6601 · DBLink functions combined with local trust or ident access control could be used by a malicious user togain superuser privileges. A valid login is required to exploit this vulnerability.
Fixed in this branch: 8.1.11.
Official affected-branch entry: 8.1.
CVE-2007-6600 · Two vulnerabilities in how ANALYZE executes user defined functions that are part of expression indexes allows users to gain superuser privileges. A valid login that has permissions to create functions and tables is required to exploit this vulnearbility.
Fixed in this branch: 8.1.11.
Official affected-branch entry: 8.1.
CVE-2007-4769 · Three vulnearbilities in the regular expression handling libraries can be exploited to cause a backend crash, infinite loops or memory exhaustion. This vulnearbility can be exploited through frontend applications that allow unfiltered regular expressions to be passed in queries.
Fixed in this branch: 8.1.11.
Official affected-branch entry: 8.1.
CVE-2007-2138 · A vulnerability involving insecure search_path settings allows unprivileged users to gain the SQL privileges of the owner of any SECURITY DEFINER function they are allowed to call. Securing such a function requires both a software update and changes to the function definition.
Fixed in this branch: 8.1.9.
Official affected-branch entry: 8.1.
CVE-2007-0556 · A vulnerability involving changing the data type of a table column can easily be exploited to cause a backend crash, and in principle might be used to read database content that the user should not be able to access.
Fixed in this branch: 8.1.7.
Official affected-branch entry: 8.1.
CVE-2007-0555 · A vulnerability allows suppressing the normal checks that a SQL function returns the data type it's declared to do. These errors can easily be exploited to cause a backend crash, and in principle might be used to read database content that the user should not be able to access.
Fixed in this branch: 8.1.7.
Official affected-branch entry: 8.1.
CVE-2006-5542 · A bug in the logging of V3 protocol messages can cause a denial of service. A valid login is required to exploit this vulnerability.
Fixed in this branch: 8.1.5.
Official affected-branch entry: 8.1.
CVE-2006-5541 · A bug in the coercion of unknown literals to ANYARRAY can cause a denial of service. A valid login is required to exploit this vulnerability.
Fixed in this branch: 8.1.5.
Official affected-branch entry: 8.1.
CVE-2006-5540 · A bug in the handling of aggregates in UPDATE can cause a denial of service. A valid login is required to exploit this vulnerability.
Fixed in this branch: 8.1.5.
Official affected-branch entry: 8.1.
CVE-2006-2314 · The widely-used practice of escaping ASCII single quote "'" by turning it into "\'" is unsafe when operating in multibyte encodings that allow 0x5c (ASCII code for backslash) as the trailing byte of a multibyte character.
Fixed in this branch: 8.1.4.
Official affected-branch entry: 8.1.
CVE-2006-2313 · An attacker able to submit crafted strings to an application that will embed those strings in SQL commands can use invalidly-encoded multibyte characters to bypass standard string-escaping methods, resulting in possible SQL injection.
Fixed in this branch: 8.1.4.
Official affected-branch entry: 8.1.
CVE-2006-0553 · A bug in the handling of SET ROLE allows escalation of privileges to any other database user, including superuser. A valid login is required to exploit this vulnerability.
Fixed in this branch: 8.1.3.
Official affected-branch entry: 8.1.
CVE-2006-0105 · On Windows only, the postmaster will exit if too many connection requests arrive simultaneously. This does not affect existing database connections, but will prevent new connections from being established until the postmaster is manually restarted.
Fixed in this branch: 8.1.2.
Official affected-branch entry: 8.1.
Export this branch as JSON · Compare any two indexed releases