发布于 2017-05-14 10:21:27 | 190 次阅读 | 评论: 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/