PostgreSQL 9.3.5

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.3.5
File Size:: 52.2 MB
Requirements:: Windows (All Versions)
Language:: en-us
License:: Freeware
Date Added:: 25 Jul 2014
Publisher:: PostgreSQL Global Development Group
Homepage:: http://www.postgresql.org
MD5 Checksum:: 7569A24123A16C5A0E132E9CBC541838

* Changes
- In pg_upgrade, remove pg_multixact files left behind by initdb
- Correctly initialize padding bytes in contrib/btree_gist indexes on bit columns
- Protect against torn pages when deleting GIN list pages
- Don't clear the right-link of a GiST index page while replaying updates from WAL
- Fix corner-case infinite loop during insertion into an SP-GiST text index
- Fix incorrect answers from SP-GiST index searches with -|- (range adjacency) operator
- Fix wraparound handling for pg_multixact/members
- Truncate pg_multixact during checkpoints, not during VACUUM
- Fix possible inconsistency of all-visible flags after WAL recovery
- Fix possibly-incorrect cache invalidation during nested calls to ReceiveSharedInvalidMessages
- Fix race condition when updating a tuple concurrently locked by another process
- Fix "could not find pathkey item to sort" planner failures with UNION ALL over subqueries reading from tables with inheritance children
- Don't assume a subquery's output is unique if there's a set-returning function in its targetlist
- Improve planner to drop constant-NULL inputs of AND/OR when possible
- Ensure that the planner sees equivalent VARIADIC and non-VARIADIC function calls as equivalent
- Fix handling of nested JSON objects in json_populate_recordset() and friends
- Fix identification of input type category in to_json() and friends
- Fix failure to detoast fields in composite elements of structured types
- Fix "record type has not been registered" failures with whole-row references to the output of Append plan nodes (Tom Lane)
- Fix possible crash when invoking a user-defined function while rewinding a cursor
- Fix query-lifespan memory leak while evaluating the arguments for a function in FROM
- Fix session-lifespan memory leaks in regular-expression processing
- Fix data encoding error in hungarian.stop
- Prevent foreign tables from being created with OIDS when default_with_oids is true
- Fix liveness checks for rows that were inserted in the current transaction and then deleted by a now-rolled-back subtransaction
- Clear pg_stat_activity.xact_start during PREPARE TRANSACTION
- Fix REASSIGN OWNED to not fail for text search objects
- Prevent pg_class.relminmxid values from going backwards during VACUUM FULL
- Reduce indentation in rule/view dumps to improve readability and avoid excessive whitespace
- Fix dumping of rules/views when subsequent addition of a column has resulted in multiple input columns matching a USING specification
- Repair view printing for some cases involving functions in FROM that return a composite type containing dropped columns
- Block signals during postmaster startup
- Fix client host name lookup when processing pg_hba.conf entries that specify host names instead of IP addresses
- Allow the root user to use postgres -C variable and postgres --describe-config
- Secure Unix-domain sockets of temporary postmasters started during make check
- Fix tablespace creation WAL replay to work on Windows
- Fix detection of socket creation failures on Windows
- On Windows, allow new sessions to absorb values of PGC_BACKEND parameters (such as log_connections) from the configuration file
- Properly quote executable path names on Windows
- Fix linking of libpython on OS X
- Avoid buffer bloat in libpq when the server consistently sends data faster than the client can absorb it
- Ensure that LDAP lookup attempts in libpq time out as intended
- Fix ecpg to do the right thing when an array of char * is the target for a FETCH statement returning more than one row, as well as some other array-handling fixes
- Fix pg_dump to cope with a materialized view that depends on a table's primary key
- Fix parsing of pg_dumpall's -i switch
- Fix pg_restore's processing of old-style large object comments
- Fix pg_upgrade for cases where the new server creates a TOAST table but the old version did not
- In pg_upgrade, preserve pg_database.datminmxid and pg_class.relminmxid values from the old cluster, or insert reasonable values when upgrading from pre-9.3; also defend against unreasonable values in the core server
- Prevent contrib/auto_explain from changing the output of a user's EXPLAIN
- Fix query-lifespan memory leak in contrib/dblink
- In contrib/pgcrypto functions, ensure sensitive information is cleared from stack variables before returning
- Prevent use of already-freed memory in contrib/pgstattuple's pgstat_heap()
- In contrib/uuid-ossp, cache the state of the OSSP UUID library across calls
- Update time zone data files to tzdata release 2014e for DST law changes in Crimea, Egypt, and Morocco.