PostgreSQL 9.6.3, 9.5.7, 9.4.12, 9.3.17 和 9.2.21 发布

栏目: 数据库 · PostgreSQL · 发布时间: 8年前

内容简介:PostgreSQL 9.6.3, 9.5.7, 9.4.12, 9.3.17 和 9.2.21 发布

PostgreSQL 开发组发布了对数据库系统的所有支持版本的更新,包括 9.6.3、9.5.7、9.4.13、9.3.17 和 9.2.21。 此版本修复了三个重要安全问题,以及过去三个月报告的其他一些错误。

已关闭的三个安全漏洞:

  • CVE-2017-7484 : selectivity estimators bypass SELECT privilege checks

  • CVE-2017-7485 : libpq ignores PGREQUIRESSL environment variable

  • CVE-2017-7486 : pg_user_mappings view discloses foreign server passwords

其他更新和修复:

  • Fix to ensure consistent behavior for RLS policies

  • Fix ALTER TABLE ... VALIDATE CONSTRAINT to not recurse to child tables when the constraint is marked NO INHERIT

  • Fix incorrect support for certain box operators in SP-GiST which could yield incorrect results

  • Fixes for handling query cancellation

  • Skip tablespace privilege checks when ALTER TABLE ... ALTER COLUMN TYPE rebuilds an existing index

  • Fix possibly-invalid initial snapshot during logical decoding

  • Fix possible corruption of init forks of unlogged indexes

  • Several fixes to postmaster, including checks for when running as a Windows service

  • Several planner fixes, among others assorted minor fixes in planning of parallel queries

  • Avoid possible crashes in walsender and some index-only scans on GiST index

  • Fix cancelling of pg_stop_backup() when attempting to stop a non-exclusive backup

  • Updates to ecpg to support COMMIT PREPARED and ROLLBACK PREPARED

  • Several fixes for pg_dump/pg_restore, among others to handle privileges for procedural languages and when using --clean option

  • Several fixes for contrib modules, such as dblink, pg_trgm and postgres_fdw

  • Fixes to MSVC builds, such as using correct daylight-savings rules for POSIX-style time zone names and supporting Tcl 8.6

  • Several performance improvements

  • Fix cursor_to_xml() to produce valid output with tableforest = false

  • Fix roundoff problems in float8_timestamptz() and make_interval()

  • Fix pgbench to handle the combination of --connect and --rate options correctly

  • Fixes to commandline tools such as pg_upgrade and pg_basebackup

  • Several fixes to VACUUM and CLUSTER

下载地址:

https://www.postgresql.org/download/


以上所述就是小编给大家介绍的《PostgreSQL 9.6.3, 9.5.7, 9.4.12, 9.3.17 和 9.2.21 发布》,希望对大家有所帮助,如果大家有任何疑问请给我留言,小编会及时回复大家的。在此也非常感谢大家对 码农网 的支持!

查看所有标签

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

图灵的秘密

图灵的秘密

Charles Petzold / 杨卫东 / 人民邮电出版社 / 2012-11 / 69.00元

图灵机是英国数学家阿兰•图灵提出的一种抽象计算模型,本书深入剖析了图灵这篇描述图灵机和可计算性的原始论文《论可计算数及其在判定性问题上的应用》。书中在详解论文的同时,也附带了大量的历史背景资料、图灵的个人经历,以及图灵机对于人们理解计算机、人类意识和宇宙所产生的影响。 本书适合所有计算机科学专业的学生、程序员或其他技术人员,同时也适合欲了解图灵生平及其构建图灵机的思维的读者阅读。一起来看看 《图灵的秘密》 这本书的介绍吧!

图片转BASE64编码
图片转BASE64编码

在线图片转Base64编码工具

随机密码生成器
随机密码生成器

多种字符组合密码

Base64 编码/解码
Base64 编码/解码

Base64 编码/解码