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。 此版本修复了三个重要安全问题,以及过去三个月报告的其他一些错误。

已关闭的三个安全漏洞:

  1. CVE-2017-7484: selectivity estimators bypass SELECT privilege checks
  2. CVE-2017-7485: libpq ignores PGREQUIRESSL environment variable
  3. 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/



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

为你推荐:

查看所有标签

码农书籍
FlashActionScript3.0从入门到精通

FlashActionScript3.0从入门到精通

章精设、胡登涛 / 清华大学出版社 / 2008-10-1 / 69.00元

FlashActionScript3.0的出现,不仅从形式上改变了ActionScript,而且从本质上改变了ActionScript,使ActionScript3.0成为了真正的面向对象编程语言。本书从最简单的编程知识出发,带领读者走进编程的大门,是一本不可多得的ActionScript3.0入门书。本书在注重基础的同时,从更高的层次来介绍ActionScript3.0的面向对象特性,使读者在不知不觉巾掌握面向对象编程。本书还介绍了许多数学、物理、设计模式等知识,并从这些知识出发,结合ActionScript3.0的特性,介绍了大量编程经验和技巧,使读者看完本书就能开发较大型的应用程序。本书适合初、中级读者,游戏、网站开发人员,网络应用程序开发人员等,也适合广大的ActionScript3.0编程爱好者。第1章 了解Action...

XML 在线格式化
XML 在线格式化

在线 XML 格式化压缩工具

正则表达式在线测试
正则表达式在线测试

正则表达式在线测试

HEX CMYK 转换工具
HEX CMYK 转换工具

HEX CMYK 互转工具