发布于 2017-05-14 18:21:27 | 87 次阅读 | 评论: 0 | 来源: 网友投递

这里有新鲜出炉的PostgreSQL指南,程序狗速度看过来!

PostgreSQL关系型数据库管理系统

PostgreSQL是以加州大学伯克利分校计算机系开发的 POSTGRES,现在已经更名为PostgreSQL,版本 4.2为基础的对象关系型数据库管理系统(ORDBMS)。


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 六版齐发,修复 3 个安全漏洞
PostgreSQL 10 正式版发布,显著的性能提升!
PostgreSQL 10 首个候选版本 RC1 发布,修复部分 bug
PostgreSQL 10 Beta 4 发布,以及全系列更新
PostgreSQL 10 Beta 4 发布,多版本更新
PostgreSQL 10 Beta 3 发布,数据库管理系统
PostgreSQL 10 Beta 3 发布,以及对所有支持版本的更新
PostgreSQL 10 Beta 2 发布,Bug 修复
PostgreSQL 10 首个测试版发布,新增特性一览
PostgreSQL 9.6.3, 9.5.7, 9.4.12, 9.3.17 和 9.2.21 发布
PostgreSQL 10 新增特性
PostgreSQL 五版齐发,修复了超过 75个 bug
最新网友评论  共有(0)条评论 发布评论 返回顶部

Copyright © 2007-2017 PHPERZ.COM All Rights Reserved   冀ICP备14009818号  版权声明  广告服务