PostgreSQL (64-bit)

最新版本 PostgreSQL 11.12 (64-bit)

PostgreSQL 11.12 (64-bit)

PostgreSQL 11.12 (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 11.12 (64-bit)

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

What's new in this version:

Security Issues:
CVE-2021-32027: Buffer overrun from integer overflow in array subscripting calculations:
- Versions Affected: 9.6 - 13. The security team typically does not test unsupported versions, but this problem is quite old
- While modifying certain SQL array values, missing bounds checks let authenticated database users write arbitrary bytes to a wide area of server memory
- The PostgreSQL project thanks Tom Lane for reporting this problem

CVE-2021-32028: Memory disclosure in INSERT ... ON CONFLICT ... DO UPDATE:
- Versions Affected: 9.6 - 13. The security team typically does not test unsupported versions. The feature first appeared in 9.5
- Using an INSERT ... ON CONFLICT ... DO UPDATE command on a purpose-crafted table, an attacker can read arbitrary bytes of server memory. In the default configuration, any authenticated database user can create prerequisite objects and complete this attack at will. A user lacking the CREATE and TEMPORARY privileges on all databases and the CREATE privilege on all schemas cannot use this attack at will.
- The PostgreSQL project thanks Andres Freund for reporting this problem

CVE-2021-32029: Memory disclosure in partitioned-table UPDATE ... RETURNING:
- Versions Affected: 11 - 13
- Using an UPDATE ... RETURNING on a purpose-crafted partitioned table, an attacker can read arbitrary bytes of server memory. In the default configuration, any authenticated database user can create prerequisite objects and complete this attack at will. A user lacking the CREATE and TEMPORARY privileges on all databases and the CREATE privilege on all schemas typically cannot use this attack at will.

Bug Fixes and Improvements:
- This update fixes over 45 bugs that were reported in the last several months. Some of these issues only affect version 13, but could also apply to other supported versions.

Some of these fixes include:
- Fix potential incorrect computation of UPDATE ... RETURNING outputs for joined, cross-partition updates
- Fix ALTER TABLE ... ALTER CONSTRAINT when used on foreign-key constraints on partitioned tables. The command would fail to adjust the DEFERRABLE and/or INITIALLY DEFERRED properties of the constraints and triggers of leaf partitions, leading to unexpected behavior. After updating to this version, you can execute the ALTER TABLE ... ALTER CONSTRAINT command to fix any misbehaving partitioned tables.
- Ensure that when a child table is attached with ALTER TABLE ... INHERIT that generated columns in the parent are generated in the same way in the child
- Forbid marking an identity column as NULL
- Allow ALTER ROLE ... SET/ALTER DATABASE ... SET to set the role, session_authorization, and temp_buffers parameters
- Ensure that REINDEX CONCURRENTLY preserves any statistics target set for the index
- Fix an issue where, in some cases, saving records within AFTER triggers could cause crashes
- Fix how to_char() handles Roman-numeral month format codes with negative intervals
- Fix use of uninitialized value while parsing an {m,n} quantifier in a BRE-mode regular expression
- Fix "could not find pathkey item to sort" planner errors that occur in some situations when the sort key involves an aggregate or window function
- Fix issue with BRIN index bitmap scans that could lead to "could not open file" errors
- Fix potentially wrong answers from GIN tsvector index searches when there are many matching records
- Fixes for COMMIT AND CHAIN functionality on both the server and psql
- Avoid incorrect timeline change while recovering uncommitted two-phase transactions from WAL, which could lead to consistency issues and the inability to restart the server.
- Ensure thatwal_sync_method is set to fdatasync by default on newer FreeBSD releases
- Disable the vacuum_cleanup_index_scale_factor parameter and storage option
- Fix several memory leaks in the server, including one with SSL/TLS parameter initialization
- Restore the previous behavior of connect service=XYZ to psql, i.e. disallow environmental variables (e.g. PGPORT) from overriding entries in the service file
- Fix how pg_dump handles generated columns in partitioned tables
- Add additional checks to pg_upgrade for user tables containing non-upgradable data types
- On Windows, initdb now prints instructions about how to start the server with pg_ctl using backslash separators
- Fix pg_waldump to count XACT records correctly when generating per-record statistics

PostgreSQL 11.12 (64-bit) 相關參考資料
Documentation: 11: 1.4. Accessing a Database - PostgreSQL

psql (11.12) Type "help" for help. mydb=> ... PostgreSQL 11.12 on x86_64-pc-linux-gnu, compiled by gcc (Debian 4.9.2-10) 4.9.2, 64-bit (1 row) mydb=> ...

https://www.postgresql.org

Documentation: 11: E.13. Release 11 - PostgreSQL

2018年10月18日 — 13th May 2021: PostgreSQL 13.3, 12.7, 11.12, 10.17, & 9.6.22 Released! ... SQL stored procedures that support embedded transactions ... Add support for 64-bit non-cryptographic hash...

https://www.postgresql.org

Download PostgreSQL Database for Windows, Linux and ...

Download PostgreSQL packages or installers free from EDB. Get PostgreSQL for Windows, Linux and MacOS platforms. Download 32-bit or 64-bit versions.

https://www.enterprisedb.com

Downloads - PostgreSQL

13th May 2021: PostgreSQL 13.3, 12.7, 11.12, 10.17, & 9.6.22 Released! Quick Links. Downloads · Packages · Source · Software Catalogue · File Browser ...

https://www.postgresql.org

PostgreSQL (64-bit) Download (2021 Latest) for Windows 10 ...

Download PostgreSQL (64-bit) for Windows PC from FileHorse. 100% Safe and Secure ✓ Free Download 64-bit Latest Version 2021.

https://www.filehorse.com

PostgreSQL 11.5, 10.10, 9.6.15, 9.5.19, 9.4.24, and 12 Beta 3 ...

2019年8月8日 — 13th May 2021: PostgreSQL 13.3, 12.7, 11.12, 10.17, & 9.6.22 Released! Quick Links. About · Policies · Feature Matrix · Donate · History ...

https://www.postgresql.org

PostgreSQL 12 Released! - PostgreSQL

2019年10月3日 — 13th May 2021: PostgreSQL 13.3, 12.7, 11.12, 10.17, & 9.6.22 Released! ... PostgreSQL is known for its conformance to the SQL standard - one ...

https://www.postgresql.org

PostgreSQL 12.2, 11.7, 10.12, 9.6.17, 9.5.21, and 9.4.26 ...

2020年2月13日 — The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 12.2, 11.7, ...

https://www.postgresql.org

PostgreSQL 13.3 12.7 11.12 10.17 9.6.22 9.5 ... - Softpedia

Download PostgreSQL - Manage multiple databases, run SQL scripts, as well as ... What's new in PostgreSQL 13.3 / 12.7 / 11.12 / 10.17 / 9.6.22: ... Windows 7 32/64 bit; file size: 262 MB; filename...

https://www.softpedia.com

Windows installers - PostgreSQL

13th May 2021: PostgreSQL 13.3, 12.7, 11.12, 10.17, & 9.6.22 Released! ... PostgreSQL Version, 64 Bit Windows Platforms, 32 Bit Windows Platforms ...

https://www.postgresql.org