Thread: CRITICAL RELEASE: Minor Releases to Fix DoS Vulnerability
PostgreSQL patch versions 8.1.2, 8.0.6, 7.4.11 and 7.3.13 are available today. The fixes in the 8.1 and 8.0 branches are critical, especially for Windows users, and users of these branches are urged to update at their earliest opportunity. One critical fix repairs a denial-of-service vulnerability: 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. The Common Vulnerabilities and Exposures (CVE) project has assigned the name CVE-2006-0105 to this issue. Another critical fix repairs an error in ReadBuffer that can cause data loss due to overwriting recently-added pages. This applies to the 8.1 and 8.0 branches on all platforms. Other fixes included are: -- Character string locale comparison bug. This may require a REINDEX on text column indexes in some locales, such as Hungarian. -- Prevent accidental changes of locale by plperl -- Two fixes for Japanese encodings -- Two fixes for COPY CSV -- Fixes for functions returning RECORD -- Fixes to autovacuum, dblink and pgcrypto Further details appear in the release notes in the documentation for the new versions, which is distributed with the source, and will be available within a few days on PostgreSQL.org. Versions 7.4.11 and 7.3.13 contain a subset of the fixes above appropriate to those versions. Currently, source packages are available for all these versions, and Windows installer packages are available for 8.1.2 and 8.0.6. Binary packages for other platforms will soon be available from the PostgreSQL Downloads[1] page and other sources. Marc G. Fournier PostgreSQL Core Member [1] - http://www.postgresql.org/download
В Пнд, 09/01/2006 в 02:33 -0400, Marc G. Fournier пишет: > -- Character string locale comparison bug. This may require a REINDEX > on text column indexes in some locales, such as Hungarian. Can we be more specific here? How is an administrator supposed to know, whether he needs to reindex his text column indexes or not? Markus Bertheau
On 1/9/06, Markus Bertheau <twanger@bluetwanger.de> wrote: > В Пнд, 09/01/2006 в 02:33 -0400, Marc G. Fournier пишет: > > > -- Character string locale comparison bug. This may require a REINDEX > > on text column indexes in some locales, such as Hungarian. > > Can we be more specific here? How is an administrator supposed to know, > whether he needs to reindex his text column indexes or not? > > Markus Bertheau > that's difficult to know because it depends on the locale behaviour, IIRC... Maybe if you are using a locale different than C and have indexes on strings then is better to REINDEX just to be sure... -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;)
Jaime Casanova wrote: > On 1/9/06, Markus Bertheau <twanger@bluetwanger.de> wrote: > > ? ???, 09/01/2006 ? 02:33 -0400, Marc G. Fournier ?????: > > > > > -- Character string locale comparison bug. This may require a REINDEX > > > on text column indexes in some locales, such as Hungarian. > > > > Can we be more specific here? How is an administrator supposed to know, > > whether he needs to reindex his text column indexes or not? > > > > Markus Bertheau > > > > that's difficult to know because it depends on the locale behaviour, IIRC... > > Maybe if you are using a locale different than C and have indexes on > strings then is better to REINDEX just to be sure... Read the specific REINDEX mentioned in the release notes and if any apply to you, you should reindex. Were they not clear? -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073