PostgreSQL 9.2.4

PostgreSQL Global Development Group - (Freeware)

PostgreSQL is a good choice when it comes to object-relational database management system, being one of the strongest competitors for Microsoft SQL Server, Firebird, Oracle, Sybase.

PostgreSQL for Windows is a software for managing relational database and Ordbms objects that will run on your operating system. It is recognized worldwide for its stability and its programming possibilities particularly extensive in the engine of your database using the PL / pgSQL.

PostgreSQL is the main competitor for MySQL, Firebird, Oracle, Sybase or Microsoft SQL Server and it is fully ACID compliant and has support for foreign keys, joins, views, triggers, and stored procedures. It also includes the windowing functions, common table expressions and recursive joins a parallel restore, consolidated hash indexes, support for SSL certificates for user authentication, routines statistics function, etc.It allows to manage tables, libraries for many languages to access records from programs written in Java (JDBC), C + + / C, Perl or Tcl / Tk.ODBC API allows any application that supports this type of interface to access PostgreSQL databases.

PostgreSQL is highly customizable running stored procedures in more than a dozen programming languages, including Java, Perl, Python, Ruby, Tcl, C/C++,and its own PL/pgSQL, which is similar to Oracle's PL/SQL.

Title:: PostgreSQL 9.2.4
File Size:: 49.7 MB
Requirements:: Windows (All Versions)
Language:: en-us
License:: Freeware
Date Added:: 07 May 2013
Publisher:: PostgreSQL Global Development Group
Homepage:: http://www.postgresql.org
MD5 Checksum:: D62C019854EC3401138CF379B818EBEF

# Changes
* Fix insecure parsing of server command-line switches
* Reset OpenSSL randomness state in each postmaster child process
* Make REPLICATION privilege checks test current user not authenticated user
* Fix GiST indexes to not use "fuzzy" geometric comparisons when it's not appropriate to do so (Alexander Korotkov)
* Fix erroneous range-union and penalty logic in GiST indexes that use contrib/btree_gist for variable-width data types, that is text, bytea, bit, and numeric columns
* Fix bugs in GiST page splitting code for multi-column indexes
* Fix gist_point_consistent to handle fuzziness consistently
* Fix buffer leak in WAL replay
* Ensure we do crash recovery before entering archive recovery, if the database was not stopped cleanly and a recovery.conf file is present
* Avoid deleting not-yet-archived WAL files during crash recovery
* Fix race condition in DELETE RETURNING
* Fix infinite-loop risk in regular expression compilation
* Fix potential null-pointer dereference in regular expression compilation
* Fix to_char() to use ASCII-only case-folding rules where appropriate
* Fix unwanted rejection of timestamp 1999-12-31 24:00:00
* Fix SQL-language functions to be safely usable as support functions for range types
* Fix logic error when a single transaction does UNLISTEN then LISTEN
* Fix possible planner crash after columns have been added to a view that's depended on by another view
* Fix performance issue in EXPLAIN (ANALYZE, TIMING OFF)
* Remove useless "picksplit doesn't support secondary split" log messages
* Remove vestigial secondary-split support in gist_box_picksplit()
* Fix possible failure to send a session's last few transaction commit/abort counts to the statistics collector
* Eliminate memory leaks in PL/Perl's spi_prepare() function
* Fix pg_dumpall to handle database names containing "=" correctly
* Avoid crash in pg_dump when an incorrect connection string is given
* Ignore invalid indexes in pg_dump and pg_upgrade
* In pg_basebackup, include only the current server version's subdirectory when backing up a tablespace
* Add a server version check in pg_basebackup and pg_receivexlog, so they fail cleanly with version combinations that won't work
* Fix contrib/dblink to handle inconsistent settings of DateStyle or IntervalStyle safely
* Fix contrib/pg_trgm's similarity() function to return zero for trigram-less strings
* Enable building PostgreSQL with Microsoft Visual Studio 2012
* Update time zone data files to tzdata release 2013b for DST law changes in Chile, Haiti, Morocco, Paraguay, and some Russian areas. Also, historical zone data corrections for numerous places.