<feed xmlns='http://www.w3.org/2005/Atom'>
<title>pkgsrc/databases/postgresql91, branch pkgsrc-2016Q3</title>
<subtitle>[no description]</subtitle>
<id>https://git.osdyson.ru/mirror/pkgsrc/atom?h=pkgsrc-2016Q3</id>
<link rel='self' href='https://git.osdyson.ru/mirror/pkgsrc/atom?h=pkgsrc-2016Q3'/>
<link rel='alternate' type='text/html' href='https://git.osdyson.ru/mirror/pkgsrc/'/>
<updated>2016-08-23T06:28:15Z</updated>
<entry>
<title>The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 9.5.4, 9.4.9, 9.3.14, 9.2.18 and 9.1.23. This release fixes two security issues. It also patches a number of other bugs reported over the last three months. Users who rely on security isolation between database users should update as soon as possible. Other users should plan to update at the next convenient downtime.</title>
<updated>2016-08-23T06:28:15Z</updated>
<author>
<name>adam</name>
<email>adam@pkgsrc.org</email>
</author>
<published>2016-08-23T06:28:15Z</published>
<link rel='alternate' type='text/html' href='https://git.osdyson.ru/mirror/pkgsrc/commit/?id=bef76e05cd3cb12c06c80740d23c42b9a749ed2e'/>
<id>urn:sha1:bef76e05cd3cb12c06c80740d23c42b9a749ed2e</id>
<content type='text'>
Security Issues
---------------
Two security holes have been closed by this release:

CVE-2016-5423: certain nested CASE expressions can cause the server to crash.
CVE-2016-5424: database and role names with embedded special characters can allow code injection during administrative operations like pg_dumpall.
The fix for the second issue also adds an option, -reuse-previous, to psql's \connect command. pg_dumpall will also refuse to handle database and role names containing line breaks after the update. For more information on these issues and how they affect backwards-compatibility, see the Release Notes.

Bug Fixes and Improvements
--------------------------
This update also fixes a number of bugs reported in the last few months. Some of these issues affect only version 9.5, but many affect all supported versions:

Fix misbehaviors of IS NULL/IS NOT NULL with composite values
Fix three areas where INSERT ... ON CONFLICT failed to work properly with other SQL features.
Make INET and CIDR data types properly reject bad IPv6 values
Prevent crash in "point ## lseg" operator for NaN input
Avoid possible crash in pg_get_expr()
Fix several one-byte buffer over-reads in to_number()
Don't needlessly plan query if WITH NO DATA is specified
Avoid crash-unsafe state in expensive heap_update() paths
Fix hint bit update during WAL replay of row locking operations
Avoid unnecessary "could not serialize access" with FOR KEY SHARE
Avoid crash in postgres -C when the specified variable is a null string
Fix two issues with logical decoding and subtransactions
Ensure that backends see up-to-date statistics for shared catalogs
Prevent possible failure when vacuuming multixact IDs in an upgraded database
When a manual ANALYZE specifies columns, don't reset changes_since_analyze
Fix ANALYZE's overestimation of n_distinct for columns with nulls
Fix bug in b-tree mark/restore processing
Fix building of large (bigger than shared_buffers) hash indexes
Prevent infinite loop in GiST index build with NaN values
Fix possible crash during a nearest-neighbor indexscan
Fix "PANIC: failed to add BRIN tuple" error
Prevent possible crash during background worker shutdown
Many fixes for issues in parallel pg_dump and pg_restore
Make pg_basebackup accept -Z 0 as no compression
Make regression tests safe for Danish and Welsh locales</content>
</entry>
<entry>
<title>Bump PKGREVISION for perl-5.24.0 for everything mentioning perl.</title>
<updated>2016-07-09T06:37:46Z</updated>
<author>
<name>wiz</name>
<email>wiz@pkgsrc.org</email>
</author>
<published>2016-07-09T06:37:46Z</published>
<link rel='alternate' type='text/html' href='https://git.osdyson.ru/mirror/pkgsrc/commit/?id=4701ae8cf9bfd483f12f23f64c3467266286f68f'/>
<id>urn:sha1:4701ae8cf9bfd483f12f23f64c3467266286f68f</id>
<content type='text'>
</content>
</entry>
<entry>
<title>Remove PostgreSQL split-up contrib packages, now replaced by</title>
<updated>2016-06-19T21:09:54Z</updated>
<author>
<name>fhajny</name>
<email>fhajny@pkgsrc.org</email>
</author>
<published>2016-06-19T21:09:54Z</published>
<link rel='alternate' type='text/html' href='https://git.osdyson.ru/mirror/pkgsrc/commit/?id=fdd5e98e6ff31a2f488faed174282604f926f1d3'/>
<id>urn:sha1:fdd5e98e6ff31a2f488faed174282604f926f1d3</id>
<content type='text'>
single postgresql9[1-5]-contrib packages. OK by adam@.</content>
</entry>
<entry>
<title>Import postgresql9[1-5]-contrib packages. These supersede the</title>
<updated>2016-06-19T20:48:28Z</updated>
<author>
<name>fhajny</name>
<email>fhajny@pkgsrc.org</email>
</author>
<published>2016-06-19T20:48:28Z</published>
<link rel='alternate' type='text/html' href='https://git.osdyson.ru/mirror/pkgsrc/commit/?id=a0099211e117ed9a4d3aa71a43210de2d929fd4d'/>
<id>urn:sha1:a0099211e117ed9a4d3aa71a43210de2d929fd4d</id>
<content type='text'>
previous handful of packages like -datatypes or -dblink. They
contain all of the contrib subtree, matching what similar packages
carry in e.g. FreeBSD ports or what PostgreSQL users generally
expect.

This subtree contains porting tools, analysis utilities, and
plug-in features that are not part of the core PostgreSQL system,
mainly because they address a limited audience or are too
experimental to be part of the main source tree. This does not
preclude their usefulness.</content>
</entry>
<entry>
<title>This release fixes a number of issues reported by users over the last two months. Most database administrators should plan to upgrade at the next available downtime, unless they have been affected directly by the fixed issues.</title>
<updated>2016-05-23T14:27:34Z</updated>
<author>
<name>adam</name>
<email>adam@pkgsrc.org</email>
</author>
<published>2016-05-23T14:27:34Z</published>
<link rel='alternate' type='text/html' href='https://git.osdyson.ru/mirror/pkgsrc/commit/?id=35584ddb17ec1422cfb339127c29b8c327d5e908'/>
<id>urn:sha1:35584ddb17ec1422cfb339127c29b8c327d5e908</id>
<content type='text'>
</content>
</entry>
<entry>
<title>The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 9.5.2, 9.4.7, 9.3.12, 9.2.16, and 9.1.21. This release fixes two security issues and one index corruption issue in version 9.5. It also contains a variety of bug fixes for earlier versions. Users of PostgreSQL 9.5.0 or 9.5.1 should update as soon as possible.</title>
<updated>2016-04-09T12:51:44Z</updated>
<author>
<name>adam</name>
<email>adam@pkgsrc.org</email>
</author>
<published>2016-04-09T12:51:44Z</published>
<link rel='alternate' type='text/html' href='https://git.osdyson.ru/mirror/pkgsrc/commit/?id=c1273ab2e1a33f57a3b87babc6d69c5423adf79c'/>
<id>urn:sha1:c1273ab2e1a33f57a3b87babc6d69c5423adf79c</id>
<content type='text'>
This release closes security hole CVE-2016-2193, where a query plan might get reused for more than one ROLE in the same session. This could cause the wrong set of Row Level Security (RLS) policies to be used for the query.

The update also fixes CVE-2016-3065, a server crash bug triggered by using pageinspect with BRIN index pages. Since an attacker might be able to expose a few bytes of server memory, this crash is being treated as a security issue.</content>
</entry>
<entry>
<title>Bump PKGREVISION for security/openssl ABI bump.</title>
<updated>2016-03-05T11:27:40Z</updated>
<author>
<name>jperkin</name>
<email>jperkin@pkgsrc.org</email>
</author>
<published>2016-03-05T11:27:40Z</published>
<link rel='alternate' type='text/html' href='https://git.osdyson.ru/mirror/pkgsrc/commit/?id=ee3e800374a703dffb75012abfd6460dc7e71dbb'/>
<id>urn:sha1:ee3e800374a703dffb75012abfd6460dc7e71dbb</id>
<content type='text'>
</content>
</entry>
<entry>
<title>Use OPSYSVARS.</title>
<updated>2016-02-25T11:46:20Z</updated>
<author>
<name>jperkin</name>
<email>jperkin@pkgsrc.org</email>
</author>
<published>2016-02-25T11:46:20Z</published>
<link rel='alternate' type='text/html' href='https://git.osdyson.ru/mirror/pkgsrc/commit/?id=7fdd43d846dce67b6998fa5441196ffaa1b56e5b'/>
<id>urn:sha1:7fdd43d846dce67b6998fa5441196ffaa1b56e5b</id>
<content type='text'>
</content>
</entry>
<entry>
<title>drop PKGREVISION after update</title>
<updated>2016-02-25T01:45:05Z</updated>
<author>
<name>tnn</name>
<email>tnn@pkgsrc.org</email>
</author>
<published>2016-02-25T01:45:05Z</published>
<link rel='alternate' type='text/html' href='https://git.osdyson.ru/mirror/pkgsrc/commit/?id=c2bc3a6576ecbfae3116dbc00b1eba277f388969'/>
<id>urn:sha1:c2bc3a6576ecbfae3116dbc00b1eba277f388969</id>
<content type='text'>
</content>
</entry>
<entry>
<title>Update to PostgreSQL 9.1.20 (2016-02-11)</title>
<updated>2016-02-25T01:06:31Z</updated>
<author>
<name>tnn</name>
<email>tnn@pkgsrc.org</email>
</author>
<published>2016-02-25T01:06:31Z</published>
<link rel='alternate' type='text/html' href='https://git.osdyson.ru/mirror/pkgsrc/commit/?id=aa6c43d7fe8a5e11a1ca6618bb420cd65db1d1bb'/>
<id>urn:sha1:aa6c43d7fe8a5e11a1ca6618bb420cd65db1d1bb</id>
<content type='text'>
This release fixes two security issues, as well as several bugs found
over the last four months.

CVE-2016-0773 Unicode regular expression buffer overflow
CVE-2016-0766 PL/Java privilege escalation</content>
</entry>
</feed>
