PostgreSQL (64-bit)

最新版本 PostgreSQL 9.6.2 (64-bit)

PostgreSQL 9.6.2 (64-bit)

PostgreSQL 9.6.2 (64-bit)
PostgreSQL 64 位是一個功能強大的開源對象關係數據庫系統。它擁有超過 15 年的積極開發和經過驗證的架構,在可靠性,數據完整性和正確性方面贏得了良好聲譽。它運行在所有主要的操作系統上,包括 Linux,UNIX(AIX,BSD,HP-UX,SGI IRIX,Mac OS X,Solaris,Tru64)和 Windows。  PostgreSQL 64 位是一個功能強大的對象關係數據庫管理系統!下載 PostgreSQL 脫機安裝程序安裝 64 位的 PC!

它完全符合 ACID,完全支持外鍵,連接,視圖,觸發器和存儲過程(多語言)。它包括大多數 SQL:2008 數據類型,包括 INTEGER,NUMERIC,BOOLEAN,CHAR,VARCHAR,DATE,INTERVAL 和 TIMESTAMP。它還支持存儲二進制大對象,包括圖片,聲音或視頻。它具有用於 C / C ++,Java,.Net,Perl,Python,Ruby,Tcl,ODBC 等的本地編程接口,以及特殊的文檔(表大小可以達到 32TB).

也可用:下載 PostgreSQL for Mac

ScreenShot

軟體資訊
檔案版本 PostgreSQL 9.6.2 (64-bit)

檔案名稱 postgresql-9.6.2-1-windows-x64.exe
檔案大小 167 MB
系統 Windows XP64 / Vista64 / Windows 7 64 / Windows 8 64 / Windows 10 64
軟體類型 開源軟體
作者 PostgreSQL Global Development Group
官網 http://www.postgresql.org/about/
更新日期 2017-02-10
更新日誌

What's new in this version:

BUILD CORRUPTION WITH CREATE INDEX CONCURRENTLY:
- There existed a race condition if CREATE INDEX CONCURRENTLY was called on a column that had not been indexed before, then rows that were updated by transactions running at the same time as the CREATE INDEX CONCURRENTLY command could have been indexed incorrectly.
- If you suspect this may have happened, the most reliable solution is to rebuild affected indexes after installing this update
- This issue is present in the 9.2, 9.3, 9.4, 9.5, and 9.6 series of PostgreSQL

FIXES FOR VISIBILITY AND WRITE-AHEAD-LOG STABILITY:
- These release contains several fixes to improve the stability of visible data and WAL logging that we wish to highlight here.
- Prior to this release, data could be prematurely pruned by a vacuum operation when a special snapshot used for catalog scans was presently available. Specifically, the vacuum operation would not be aware of the oldest xmin for this special snapshot. The error would surface with a message such as: "cache lookup failed for relation 1255"
- This release ensures that vacuum operations will account for the catalog scan snapshots.

Additionally, there are several fixes to improved the stability of write-ahead-logging, including:
- A fix for BRIN index WAL logging where a replay could make a portion of the BRIN index useless and require recomputing
- A fix for an unlogged table where a WAL-log would be created under the "wal_level = minimal" setting, and upon replay after crash, the table would not appear to be properly reset
- A fix in the WAL page header validation when re-reading segments that fixes the error of "out-of-sequence TLI" that could be reported during recovery
- Theses issues are present in the 9.6 series of PostgreSQL releases and may also be present in the 9.2, 9.3, 9.4, and 9.5 series.

BUG FIXES AND IMPROVEMENTS:
- This update also fixes a number of bugs reported in the last few months. Some of these issues affect only the 9.6 series, but many affect all supported versions.

There are more than 75 fixes provided in this release, including:
- Several fixes for operating in hot standby mode
- Disallow setting the num_sync field to zero in synchronous_standby_names
- Don't count background worker processes against a user's connection limit
- Fix check for when an extension member object can be dropped
- Fix tracking of initial privileges for extension member objects so that it works correctly with ALTER EXTENSION ... ADD/DROP
- Several vacuum and autovacuum fixes
- Fix CREATE OR REPLACE VIEW to update the view query before attempting to apply the new view options
- Make sure ALTER TABLE preserves index tablespace assignments when rebuilding indexes
- Several fixes to the query planner, including fixes for foreign tables and CTEs
- Several fixes around the full-text search feature to improve accuracy and performance of the search
- Several fixes and performance improvements in several array functions
- Several fixes around the interaction of foreign-key constraints with trigger functions around specific ALTER TABLE operations
- Remove optimizations for date/time data types that returned incorrect data
- Fix incorrect use of view reloptions as regular table reloptions
- Fix incorrect "target lists can have at most N entries" complaint when using ON CONFLICT with wide tables
- Fix spurious "query provides a value for a dropped column" errors during INSERT or UPDATE on a table with a dropped column
- Prevent multicolumn expansion of foo.* in an UPDATE source expression
- Ensure that column typmods are determined accurately for multi-row VALUES constructs
- Several fixes for the psql command-line tool
- Prevent multiple calls of pg_start_backup() and pg_stop_backup() from running concurrently
- Several fixes for pg_dump, pg_restore, and pg_basebackup, including a possible pg_basebackup failure on standby server when including WAL files
- Several fixes for parallel workers and plans for parallel queries including fixing a crash if the number of workers available to a parallel query decreases during a rescan
- Several fixes to PL/pgSQL, PL/Python, and PL/Tcl
- Several fixes for contrib modules
- Allow DOS-style line endings in ~/.pgpass files, even on Unix

PostgreSQL 9.6.2 (64-bit) 相關參考資料
Download PostgreSQL

PostgreSQL Version, Linux x86-64, Linux x86-32, Mac OS X, Windows x86-64, Windows x86-32. 16.3, postgresql.org · postgresql.org, Not supported. 15.7, postgresql ...

https://www.enterprisedb.com

Download PostgreSQL (64bit) 9.6.2 for windows

2017年2月12日 — PostgreSQL is a powerful open-source relational database management system that is widely used in modern software development.

https://www.filepuma.com

Downloading PostgreSQL 9.6.2 (64-bit) from FileHorse.com

A powerful, open source relational database system · PostgreSQL 9.6.2 (64-bit) · Key details about this download. The file will be downloaded ...

https://www.filehorse.com

Downloads

PostgreSQL is available for download as ready-to-use packages or installers for various platforms, as well as a source code archive if you want to build it ...

https://www.postgresql.org

pg_upgrade | 16 | PostgreSQL 正體中文使用手冊

pg_upgrade(以前稱為pg_migrator)可以將儲存在PostgreSQL 資料檔案中的內容升級到更高主版本的PostgreSQL,而毋需進行資料的匯出匯入,例如從9.5.8 到9.6.4 或從10.7 ...

https://docs.postgresql.tw

PostgreSQL 9.6.2 Documentation

2016年1月7日 — Page 1. PostgreSQL 9.6.2 Documentation. The PostgreSQL Global Development Group. Page 2. PostgreSQL ... Bit-string Constants ... 64. 5.7. Row ...

https://www.postgresql.fastwar

PostgreSQL 9.6.2, 9.5.6, 9.4.11, 9.3.16 and 9.2.20 released!

2017年2月9日 — The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 9.6.2, 9.5.6, ...

https://www.postgresql.org

PostgreSQL: File Browser

If you install the 64bit package, these files will install in subdirectories bin/64 and lib/64 rather than bin and lib; adjust your PATH accordingly. This also ...

https://www.postgresql.org

The link to download PostgreSQL 9.6 Beta 2 for Windows X64 ...

Thread: The link to download PostgreSQL 9.6 Beta 2 for Windows X64 is broken (The link downloads Beta 1). The link to download PostgreSQL 9.6 Beta 2 for ...

https://postgrespro.com

如何在w7-64上安装postgresql-9.6.2-1-windows-x64 - icuke

2017年6月17日 — 如何在w7-64上安装postgresql-9.6.2-1-windows-x64 · 1、开始安装: · 2、选择程序安装目录: · 3、选择数据存放目录: · 4、输入数据库超级用户和创建的 ...

https://www.cnblogs.com