PostgreSQL

PostgreSQL 9.2.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.2.3
檔案名稱 postgresql-9.2.3-1-windows.exe
檔案大小 49.62MB
系統 Windows (All Versions)
支援語系 Multiple languages
軟體類型 免費軟體
更新日期 2013-02-10
更新日誌

# changes-

- Prevent execution of enum_recv from SQL (Tom Lane)
The function was misdeclared, allowing a simple SQL command to crash the server. In principle an attacker might be able to use it to examine the contents of server memory. Our thanks to Sumit Soni (via Secunia SVCRP) for reporting this issue. (CVE-2013-0255)
- Fix multiple problems in detection of when a consistent database state has been reached during WAL replay (Fujii Masao, Heikki Linnakangas, Simon Riggs, Andres Freund)
- Fix detection of end-of-backup point when no actual redo work is required (Heikki Linnakangas)
This mistake could result in incorrect "WAL ends before end of online backup" errors.
- Update minimum recovery point when truncating a relation file (Heikki Linnakangas)
Once data has been discarded, it's no longer safe to stop recovery at an earlier point in the timeline.
- Fix recycling of WAL segments after changing recovery target timeline (Heikki Linnakangas)
Properly restore timeline history files from archive on cascading standby servers (Heikki Linnakangas)
- Fix lock conflict detection on hot-standby servers (Andres Freund, Robert Haas)
- Fix missing cancellations in hot standby mode (Noah Misch, Simon Riggs)
The need to cancel conflicting hot-standby queries would sometimes be missed, allowing those queries to see inconsistent data.
- Prevent recovery pause feature from pausing before users can connect (Tom Lane)
- Fix SQL grammar to allow subscripting or field selection from a sub-SELECT result (Tom Lane)
- Fix performance problems with autovacuum truncation in busy workloads (Jan Wieck)
Truncation of empty pages at the end of a table requires exclusive lock, but autovacuum was coded to fail (and release the table lock) when there are conflicting lock requests. Under load, it is easily possible that truncation would never occur, resulting in table bloat. Fix by performing a partial truncation, releasing the lock, then attempting to re-acquire the lock and continue. This fix also greatly reduces the average time before autovacuum releases the lock after a conflicting request arrives.
- Improve performance of SPI_execute and related functions, thereby improving PL/pgSQL's EXECUTE (Heikki Linnakangas, Tom Lane)
Remove some data-copying overhead that was added in 9.2 as a consequence of revisions in the plan caching mechanism. This eliminates a performance regression compared to 9.1, and also saves memory, especially when the query string to be executed contains many SQL statements.
A side benefit is that multi-statement query strings are now processed fully serially, that is we complete execution of earlier statements before running parse analysis and planning on the following ones. This eliminates a long-standing issue, in that DDL that should affect the behavior of a later statement will now behave as expected.
- Restore pre-9.2 cost estimates for index usage (Tom Lane)
An ill-considered change of a fudge factor led to undesirably high cost estimates for use of very large indexes.
- Fix intermittent crash in DROP INDEX CONCURRENTLY (Tom Lane)
- Fix potential corruption of shared-memory lock table during CREATE/DROP INDEX CONCURRENTLY (Tom Lane)
- Fix COPY's multiple-tuple-insertion code for the case of a tuple larger than page size minus fillfactor (Heikki Linnakangas)
The previous coding could get into an infinite loop.
- Protect against race conditions when scanning pg_tablespace (Stephen Frost, Tom Lane)
CREATE DATABASE and DROP DATABASE could misbehave if there were concurrent updates of pg_tablespace entries.
- Prevent DROP OWNED from trying to drop whole databases or tablespaces (Álvaro Herrera)
For safety, ownership of these objects must be reassigned, not dropped.
- Fix error in vacuum_freeze_table_age implementation (Andres Freund)
The main consequence of this mistake is that lowering vacuum_freeze_min_age would cause full-table vacuuming scans to occur much more frequently than intended.
- Prevent misbehavior when a RowExpr or XmlExpr is parse-analyzed twice (Andres Freund, Tom Lane)
This mistake could be user-visible in contexts such as CREATE TABLE LIKE INCLUDING INDEXES.
- Improve defenses against integer overflow in hashtable sizing calculations (Jeff Davis)
- Fix some bugs associated with privileges on datatypes (Tom Lane)
- There were some issues with default privileges for types, and pg_dump failed to dump such privileges at all.
- Fix failure to ignore leftover temporary tables after a server crash (Tom Lane)
- Fix failure to rotate postmaster log files for size reasons on Windows (Jeff Janes, Heikki Linnakangas)
Reject out-of-range dates in to_date() (Hitoshi Harada)
- Fix pg_extension_config_dump() to handle extension-update cases properly (Tom Lane)
This function will now replace any existing entry for the target table, making it usable in extension update scripts.
- Fix PL/pgSQL's reporting of plan-time errors in possibly-simple expressions (Tom Lane)
The previous coding resulted in sometimes omitting the first line in the CONTEXT traceback for the error.
- Fix PL/Python's handling of functions used as triggers on multiple tables (Andres Freund)
- Ensure that non-ASCII prompt strings are translated to the correct code page on Windows (Alexander Law, Noah Misch)
This bug affected psql and some other client programs.
- Fix possible crash in psql's ? command when not connected to a database (Meng Qingzhong)
- Fix possible error if a relation file is removed while pg_basebackup is running (Heikki Linnakangas)
- Tolerate timeline switches while pg_basebackup -X fetch is backing up a standby server (Heikki Linnakangas)
- Make pg_dump exclude data of unlogged tables when running on a hot-standby server (Magnus Hagander)
This would fail anyway because the data is not available on the standby server, so it seems most convenient to assume --no-unlogged-table-data automatically.
- Fix pg_upgrade to deal with invalid indexes safely (Bruce Momjian)
- Fix pg_upgrade's -O/-o options (Bruce Momjian)
- Fix one-byte buffer overrun in libpq's PQprintTuples (Xi Wang)
This ancient function is not used anywhere by PostgreSQL itself, but it might still be used by some client code.
- Make ecpglib use translated messages properly (Chen Huajun)
- Properly install ecpg_compat and pgtypes libraries on MSVC (Jiang Guiqing)
- Include our version of isinf() in libecpg if it's not provided by the system (Jiang Guiqing)
- Rearrange configure's tests for supplied functions so it is not fooled by bogus exports from libedit/libreadline (Christoph Berg)
- Ensure Windows build number increases over time (Magnus Hagander)
- Make pgxs build executables with the right .exe suffix when cross-compiling for Windows (Zoltan Boszormenyi)
- Add new timezone abbreviation FET (Tom Lane)

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

  • PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has ...
    PostgreSQL
    Download PostgreSQL 9.2.3 - FileHippo.com
    http://filehippo.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
  • 2013年2月10日 - PostgreSQL is a powerful object-relational database management system! It is fully ACID compliant, has full support for foreign keys, joins, ...
    PostgreSQL
    PostgreSQL 9.2.3 (32-bit) Download for Windows / FileHorse.com
    http://www.filehorse.com
  • 2013年2月10日 - PostgreSQL 9.6.2 (64-bit). Requirements: Windows XP64 / Vista64 / Windows 7 64 / Windows 8 64. User Rating: Click to vote. Author / Product:.
    PostgreSQL
    PostgreSQL 9.2.3 (64-bit) Download for Windows / FileHorse.com
    http://www.filehorse.com
  • 2013年2月7日 - The PostgreSQL Global Development Group has released a security update to all current versions of the PostgreSQL database system, ...
    PostgreSQL
    PostgreSQL 9.2.3, 9.1.8, 9.0.12, 8.4.16 and 8.3.23 released
    https://www.postgresql.org
  • versions: 9.2 / 9.3 / 9.4 / 9.5 / current () | Development versions: devel | Unsupported versions : 7.2 / 7.3 / 7.4 / 8.0 / 8.1 / 8.2 / 8.3 / 8.4 / ... PostgreSQL 9.2.20 Documentation The PostgreSQL G...
    PostgreSQL
    PostgreSQL: Documentation: 9.2: PostgreSQL 9.2.20 Documentation
    https://www.postgresql.org
  • Since PostgreSQL 9.0, a warning message has been emitted when an operator named => is created because the ... This change reverts an ill-considered change made in release 7.3. Measuring from UTC mi...
    PostgreSQL
    PostgreSQL: Documentation: 9.2: Release 9.2
    https://www.postgresql.org
  • This release contains a variety of fixes from 9.2.2. For information about new features in the 9.2 major release, see Section E.20. E.17.1. Migration to Version 9.2.3 A dump/restore is not required fo...
    PostgreSQL
    PostgreSQL: Documentation: 9.2: Release 9.2.3
    https://www.postgresql.org
  • versions: 9.2 / 9.3 / 9.4 / 9.5 / current ) | Development versions: devel | Unsupported versions: 7.2 / 7.3 / 7.4 / 8.0 / 8.1 / 8.2 / 8.3 / 8.4 / 9.0 / 9.1 PostgreSQL 9.3.15 Documentation ...
    PostgreSQL
    PostgreSQL: Documentation: 9.3: PostgreSQL 9.3.15 Documentation
    https://www.postgresql.org
  • Release 9.2.3. Release Date: 2013-02-07. This release contains a variety of fixes from 9.2.2. For information about new features in the 9.2 major release, see ...
    PostgreSQL
    PostgreSQL: Documentation: 9.5: Release 9.2.3
    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
  • The PostgreSQL Global Development Group has released a security update to all current versions of the PostgreSQL database system, including versions 9.2.3, 9.1.8, 9.0.12, 8.4.16, and 8.3.23. This upda...
    PostgreSQL
    PostgreSQL: PostgreSQL 9.2.3, 9.1.8, 9.0.12, 8.4.16 and 8.3.23 released
    https://www.postgresql.org
  • The PostgreSQL Global Development Group announces the release of PostgreSQL 9.3, the latest version of the world's leading open source relational database system. This release expands PostgreSQL&#...
    PostgreSQL
    PostgreSQL: PostgreSQL 9.3 released!
    https://www.postgresql.org
  • The PostgreSQL Global Development Group has released an important update to all supported versions of the PostgreSQL database system, which includes minor versions 9.3.3, 9.2.7, 9.1.12, 9.0.16, and 8....
    PostgreSQL
    PostgreSQL: PostgreSQL 9.3.3, 9.2.7, 9.1.12, 9.0.16 and 8.4.20 released!
    https://www.postgresql.org
  • PostgreSQL 9.4.4, 9.3.9, 9.2.13, 9.1.18 & 9.0.22 Released! Posted on 2015-06-12 2015-06-12 Update Release ... Servers previously upgraded to PostgreSQL 9.3 using pg_upgrade, even those servers now...
    PostgreSQL
    PostgreSQL: PostgreSQL 9.4.4, 9.3.9, 9.2.13, 9.1.18 & 9.0.22 Released!
    https://www.postgresql.org
  • 2013年3月14日 - Like Christian Hammers already mentioned, you need to grant access to each and every object in that schema to user1 for having access to it.
    PostgreSQL
    Re: [postgresql 9.2.3] schema and privileges
    https://www.postgresql.org
  • postgresql-9.2.3.tar.bz2, 2013-02-07 10:25:10, 15.6 MB. postgresql-9.2.3.tar.bz2.md5, 2013-02-07 10:25:10, 59 bytes. postgresql-9.2.3.tar.gz, 2013-02-07 10:25: ...
    PostgreSQL
    v9.2.3 - PostgreSQL: File Browser
    https://www.postgresql.org
  • 2013年3月13日 - Hi , I'm new in postgresql but have been using mysql for years , I planning to migrate to postgresql, I currently playing around with the schema ...
    PostgreSQL
    [postgresql 9.2.3] schema and privileges
    https://www.postgresql.org