PostgreSQL

PostgreSQL 9.5.3

PostgreSQL Global Development Group
免費軟體

在mysql開始針對特定功能開始收費之後,postgresql立即被免費軟體開發解決方案,樹立免費資料庫軟體優秀領導品牌之一。

  • 短小的檔案與不佔系統記憶體,適合中小企業自行架設網站。
  • 開放原始碼解決方案。
  • 雖然免費,但功能強大。
  • 屬於關聯式資料庫系統,超過十五年的發展歷史。
  • 系統架構經過驗證符合可靠度與正確性的嚴格要求。
  • 可以在大部分主要的作業系統上運行。如Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), 與Windows。
  • 支援大部分的SQL資料型別,包含INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, 與TIMESTAMP。
  • 支援大部分的SQL二進位資料型別,包含圖片、聲音與影像。
  • 具原生程式設計介面,如C/C++, Java, .Net, Perl, Python, Ruby, Tcl, ODBC等等。

軟體資訊
檔案版本 PostgreSQL 9.5.3
檔案名稱 postgresql-9.5.3-1-windows.exe
檔案大小 58.64MB
系統 Windows (All Versions)
支援語系 Multiple languages
軟體類型 免費軟體
更新日期 2016-05-18
更新日誌

# Changes
- Clear the OpenSSL error queue before OpenSSL calls, rather than assuming it's clear already; and make sure we leave it clear afterwards
- This change prevents problems when there are multiple connections using OpenSSL within a single process and not all the code involved follows the same rules for when to clear the error queue. Failures have been reported specifically when a client application uses SSL connections in libpq concurrently with SSL connections using the PHP, Python, or Ruby wrappers for OpenSSL. It's possible for similar problems to arise within the server as well, if an extension module establishes an outgoing SSL connection.
- Fix "failed to build any N-way joins" planner error with a full join enclosed in the right-hand side of a left join
- Fix incorrect handling of equivalence-class tests in multilevel nestloop plans
- Given a three-or-more-way equivalence class of variables, such as X.X = Y.Y = Z.Z, it was possible for the planner to omit some of the tests needed to enforce that all the variables are actually equal, leading to join rows being output that didn't satisfy the WHERE clauses. For various reasons, erroneous plans were seldom selected in practice, so that this bug has gone undetected for a long time.
- Fix corner-case parser failures occurring when operator_precedence_warning is turned on
- An example is that SELECT (ARRAY[])::text[] gave an error, though it worked without the parentheses.
- Fix query-lifespan memory leak in GIN index scans
- Fix query-lifespan memory leak and potential index corruption hazard in GIN index insertion
- The memory leak would typically not amount to much in simple queries, but it could be very substantial during a large GIN index build with high maintenance_work_mem.
- Fix possible misbehavior of TH, th, and Y,YYY format codes in to_timestamp()
- These could advance off the end of the input string, causing subsequent format codes to read garbage.
- Fix dumping of rules and views in which the array argument of a value operator ANY (array) construct is a sub-SELECT
- Disallow newlines in ALTER SYSTEM parameter values
- The configuration-file parser doesn't support embedded newlines in string literals, so we mustn't allow them in values to be inserted by ALTER SYSTEM.
- Fix ALTER TABLE ... REPLICA IDENTITY USING INDEX to work properly if an index on OID is selected
- Avoid possible misbehavior after failing to remove a tablespace symlink
- Fix crash in logical decoding on alignment-picky platforms
- The failure occurred only with a transaction large enough to spill to disk and a primary-key change within that transaction.
- Avoid repeated requests for feedback from receiver while shutting down walsender
- Make pg_regress use a startup timeout from the PGCTLTIMEOUT environment variable, if that's set
- This is for consistency with a behavior recently added to pg_ctl; it eases automated testing on slow machines.
- Fix pg_upgrade to correctly restore extension membership for operator families containing only one operator class
- In such a case, the operator family was restored into the new database, but it was no longer marked as part of the extension. This had no immediate ill effects, but would cause later pg_dump runs to emit output that would cause (harmless) errors on restore.
- Fix pg_upgrade to not fail when new-cluster TOAST rules differ from old
- pg_upgrade had special-case code to handle the situation where the new PostgreSQL version thinks that a table should have a TOAST table while the old version did not. That code was broken, so remove it, and instead do nothing in such cases; there seems no reason to believe that we can't get along fine without a TOAST table if that was okay according to the old version's rules.
- Fix atomic operations for PPC when using IBM's XLC compiler
- Reduce the number of SysV semaphores used by a build configured with --disable-spinlocks
- Rename internal function strtoi() to strtoint() to avoid conflict with a NetBSD library function
- Fix reporting of errors from bind() and listen() system calls on Windows
- Reduce verbosity of compiler output when building with Microsoft Visual Studio
- Support building with Visual Studio 2015
- Note that builds made with VS2015 will not run on Windows versions before Windows Vista.
- Fix putenv() to work properly with Visual Studio 2013
- Avoid possibly-unsafe use of Windows' FormatMessage() function
- Use the FORMAT_MESSAGE_IGNORE_INSERTS flag where appropriate. No live bug is known to exist here, but it seems like a good idea to be careful.
- Update time zone data files to tzdata release 2016d for DST law changes in Russia and Venezuela. There are new zone names Europe/Kirov and Asia/Tomsk to reflect the fact that these regions now have different time zone histories from adjacent regions.

作者 PostgreSQL Global Development Group
官網 暫無資訊

  • Please note: Cookies should be enabled for the download process to function properly. About Us · Careers · News · Events · Media Center · Legal. EnterpriseDB
    PostgreSQL
    Download PostgreSQL | EnterpriseDB
    https://www.enterprisedb.com
  • 9 th February 2017 PostgreSQL 9.6.2, 9.5.6, 9.4.11, 9.3.16 and 9.2.20 Released! The PostgreSQL Global Development Group is pleased to announce the availability of PostgreSQL 9.6.2, 9.5.6, 9.4.11, 9.3....
    PostgreSQL
    PostgreSQL - Official Site
    https://www.postgresql.org
  • 2016年5月12日 - PostgreSQL 9.6.2 (64-bit). Requirements: Windows XP64 / Vista64 / Windows 7 64 / Windows 8 64 / Windows 10 64. User Rating: Click to vote.
    PostgreSQL
    PostgreSQL 9.5.3 (64-bit) Download for Windows / FileHorse.com
    http://www.filehorse.com
  • 本手册是《PostgreSQL9.5.3中文手册》的翻译中版本。基于彭煜玮教授独自翻译的PostgreSQL 9.4.4中文手册和社区之前翻译的《PostgreSQL9.4.4中文手册》。 在翻译 ...
    PostgreSQL
    PostgreSQL 9.5.3 中文手册 - PostgreSQL中文社区
    http://www.postgres.cn
  • 2016年5月13日 - The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 9.5.3, 9.4.8, ...
    PostgreSQL
    PostgreSQL 9.5.3, 9.4.8, 9.3.13, 9.2.17 and 9.1.22 Released!
    https://www.postgresql.org
  • PostgreSQL 9.3.15 Documentation The PostgreSQL Global Development Group Copyright © 1996-2016 The PostgreSQL Global Development Group Table of Contents Preface What is PostgreSQL? ...
    PostgreSQL
    PostgreSQL: Documentation: 9.3: PostgreSQL 9.3.15 Documentation
    https://www.postgresql.org
  • This release contains a variety of fixes from 9.3.4. For information about new features in the 9.3 major release, see Section E.16. E.11.1. Migration to Version 9.3.5 A dump/restore is not required fo...
    PostgreSQL
    PostgreSQL: Documentation: 9.3: Release 9.3.5
    https://www.postgresql.org
  • This page in other versions: 9.2 / 9.3 / 9.4 / 9.5 / current () | Development versions: devel | Unsupported versions ... PostgreSQL 9.5.5 Documentation The PostgreSQL Global Development Group Copyrigh...
    PostgreSQL
    PostgreSQL: Documentation: 9.5: PostgreSQL 9.5.5 Documentation
    https://www.postgresql.org
  • E.6.2. Migration to Version 9.5 A dump/restore using pg_dumpall, or use of pg_upgrade, is required for those wishing to migrate data from any previous release. Version 9.5 contains a number of changes...
    PostgreSQL
    PostgreSQL: Documentation: 9.5: Release 9.5
    https://www.postgresql.org
  • This release contains a variety of fixes from 9.5.2. For information about new features in the 9.5 major release, see Section E.6. E.3.1. Migration to Version 9.5.3 A dump/restore is not required for ...
    PostgreSQL
    PostgreSQL: Documentation: 9.5: Release 9.5.3
    https://www.postgresql.org
  • This release contains a variety of fixes from 9.5.3. For information about new features in the 9.5 major release, see Section E.7. E.3.1. Migration to Version 9.5.4 A dump/restore is not required for ...
    PostgreSQL
    PostgreSQL: Documentation: 9.5: Release 9.5.4
    https://www.postgresql.org
  • This page in other versions: 9.2 / 9.3 / 9.4 / 9.5 / current (9.6) | Development versions: devel | Unsupported versions ... PostgreSQL 9.6.2 Documentation The PostgreSQL Global Development Group Copyr...
    PostgreSQL
    PostgreSQL: Documentation: 9.6: PostgreSQL 9.6.2 Documentation
    https://www.postgresql.org
  • Downloads PostgreSQL Core Distribution The core of the PostgreSQL object-relational database management system is available in several source and binary formats. Binary packages Pre-built binary packa...
    PostgreSQL
    PostgreSQL: Downloads
    https://www.postgresql.org
  • 2016-05-12 Cumulative Bug Fix Release The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 9.5.3, 9.4.8, 9.3.13, 9.2.17 and 9.1.22...
    PostgreSQL
    PostgreSQL: PostgreSQL 9.5.3, 9.4.8, 9.3.13, 9.2.17 and 9.1.22 Released!
    https://www.postgresql.org
  • Sophisticated open-source Object-Relational DBMS supporting almost all SQL constructs, including subselects, transactions, and user-defined types and ...
    PostgreSQL
    PostgreSQL: The world's most advanced open source database
    https://www.postgresql.org
  • 2016年5月12日 - It appears that only the source and i386 packages have been updated for 9.5 on precise amd64: postgresql-9.5 | 9.5.3-1.pgdg+1 | sid-pgdg ...
    PostgreSQL
    Re: postgresql-9.5 updated to version 9.5.3-1.pgdg+1
    https://www.postgresql.org
  • postgresql-9.5.3.tar.bz2, 2016-05-09 21:08:49, 17.6 MB. postgresql-9.5.3.tar.bz2.md5, 2016-05-09 21:08:49, 59 bytes. postgresql-9.5.3.tar.bz2.sha256 ...
    PostgreSQL
    v9.5.3 - PostgreSQL: File Browser
    https://www.postgresql.org
  • Release 9.5.3 ........................................................................................................ 2189. E.4.1. Migration to Version 9.5.3.............................................
    PostgreSQL
    [PDF] A4 PDF - PostgreSQL
    https://www.postgresql.org