PostgreSQL 10.4, 9.6.9, 9.5.13, 9.4.18 和 9.3.23 发布

内容简介：PostgreSQL 10.4, 9.6.9, 9.5.13, 9.4.18 和 9.3.23 全系列更新发布！ 本次更新修复了一个安全问题以及过去三个月报告的一些错误。 安全问题 该版本修复了一个安全漏洞 CVE-2018-1115: 函数 pg_logfile_rotate() ...

PostgreSQL 10.4, 9.6.9, 9.5.13, 9.4.18 和 9.3.23 全系列更新发布！

本次更新修复了一个安全问题以及过去三个月报告的一些错误。

安全问题

该版本修复了一个安全漏洞

• CVE-2018-1115: 函数 pg_logfile_rotate() 权限过高，使得可允许访问控制列表

其他 Bug 修复和改进

本次更新还修复了过去几个月报告的 50 多个错误。其中一些问题仅影响版本 10，但更多的是影响所有受支持的版本。

• Fix incorrect volatility and parallel-safety markings on several built-in functions to ensure correct query planning optimizations

• Several fixes for partitioning, including potential crashes as well as allowing TRUE and FALSE to be used as partition bounds

• Fix where a new TOAST value could be assigned to a dead-but-not-yet-vacuumed TOAST OID, which would result in an error similar to "unexpected chunk number 0 (expected 1) for toast value nnnnn"

• Fix "CREATE TABLE ... LIKE" with bigint identity columns on 32-bit platforms

• Fix memory leak within the runtime of a query that repeatedly executes hash joins

• Several crash fixes around queries using GROUPING SET

• Avoid failure if a query-cancel or session-termination interrupt occurs while committing a prepared transaction

• Reduce locking during autovacuum worker scheduling, which prevents loss of potential worker concurrency

• Fix possible slow execution of REFRESH MATERIALIZED VIEW CONCURRENTLY

• Several fixes around query plans that use "index-only" scans

• Avoid deadlocks in concurrent CREATE INDEX CONCURRENTLY commands that are run under SERIALIZABLE or REPEATABLE READ transaction isolation

• Several fixes for SP-GiST indexes, including one collation-aware searches on text columns

• Fixes related to counting the number of tuples in partial GiST, SP-GiST, and Bloom indexes

• Several fixes for logical decoding and replication

• Fix misquoting of values for list-valued GUC variables (e.g. local_preload_libraries, session_preload_libraries, shared_preload_libraries, temp_tablespaces) in dumps

• Several fixes for pg_stat_activity

• Several fixes for ecpg

• Fix for pg_recvlogical to ensure compatibility with PostgreSQL versions released before 10

• Several fixes for pg_rewind

官方公告：https://www.postgresql.org/about/news/1851/  
下载地址：https://www.postgresql.org/download/  
发布说明：https://www.postgresql.org/docs/current/static/release.html

【声明】文章转载自：开源中国社区 [http://www.oschina.net]

以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持 码农网

查看所有标签

猜你喜欢:

• NPM包（模块）发布、更新、撤销发布
• 有赞灰度发布与蓝绿发布实践
• 【重磅发布】Linkis 0.10.0 版本发布
• BeetlSQL 3.0.9 发布，Idea 插件发布
• 贝密游戏 0.7.0 发布，发布斗地主
• 【重磅发布】DataSphere Studio 0.9.0 版本发布

本站部分资源来源于网络，本站转载出于传递更多信息之目的，版权归原作者或者来源机构所有，如转载稿涉及版权问题，请联系我们。