![PostgreSQL 9.6.3, 9.5.7, 9.4.12, 9.3.17 和 9.2.21 发布](http://www.linuxeden.com/wp-content/uploads/2017/05/postgresql.png)
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/
转自 http://www.oschina.net/news/84796/postgresql-9-6-3-and-9-2-21