No alive nodes found in your cluster 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.12, 9.3.17 和 9.2.21 发布

栏目: 数据库 · PostgreSQL · 软件资讯 · 发布时间: 2年前

来源: 开源中国社区


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


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





【美】Alex R. Young、【美】Marc Harter / 承竹、慕陶、邱娟、达峰 / 电子工业出版社 / 2017-1 / 109.9

《Node.js 硬实战:115 个核心技巧》是一本面向实战的Node.js 开发进阶指南。作为资深专家,《Node.js 硬实战:115 个核心技巧》作者独辟蹊径,将着眼点放在Node.js 的核心模块和网络应用,通过精心组织的丰富实例,向读者充分展示了Node.js 强大的并发处理能力,读者从中可真正掌握Node 的核心基础与高级技巧。《Node.js 硬实战:115 个核心技巧》总共有三部分......一起来看看 《Node.js硬实战:115个核心技巧》 这本书的介绍吧!

HTML 压缩/解压工具
HTML 压缩/解压工具

在线压缩/解压 HTML 代码


RGB HEX 互转工具