PostgreSQL 8.4.4

Operating systemsOS : Windows / Linux / Mac OS / BSD / Solaris
Program licensingScript Licensing : Other Free / Open Source License - PostgreSQL License
CreatedCreated : Aug 5, 2010
Size downloadDownloads : 3
Program licensing
Thank you for voting...

It has more than 15 years of active development and a ...

It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness.
It runs on all major operating system, including Windows, Linux and other UNIX systmes like AIX, HP-UX, BSD, SGI IRIX, Mac OS X, Solaris and Tru64.
It is fully ACID compliant, has full support for foreign keys, views, triggers, joins and stored procedures (in multiple languages).
It includes most SQL:2008 data types, including INTEGER, NUMERIC, CHAR, VARCHAR, DATE, INTERVAL, BOOLEAN and TIMESTAMP.
postgresql by postgresql Global Development Group also supports storage of binary large objects, including pictures, sounds, or video. It has native programming interfaces for C/C++, Ruby, Java, . Net, Perl, Python, Tcl, ODBC, among others, and exceptional documentation.
PostgreSQL 8.4.4 runs stored procedures in more than a dozen programming languages, including Java, Ruby, Perl, Python, C/C++, Tcl, and its own PL/pgSQL, which is similar to Oracle's PL/SQL.
The SQL implementation in PostgreSQL [postgresql8.4.4.exe] strongly conforms to the ANSI-SQL:2008 standard.
And while PostgreSQL - 0MB has a fully relational system catalog which itself supports multiple schemas per database, its catalog is also accessible through the Information Schema as defined in the SQL standard.
It has full support for subqueries (including subselects in the FROM clause), read-committed and serializable transaction isolation levels.
Being an enterprise class database, PostgreSQL 8.4.4 boasts sophisticated features such as Multi-Version Concurrency Control (MVCC), tablespaces, point in time recovery, asynchronous replication, nested transactions (savepoints), online/hot backups, a sophisticated query planner/optimizer, and write ahead logging for fault tolerance.
It natively supports international character sets, Unicode, multibyte character encodings, and it is locale-aware for sorting, case-sensitivity, and formatting.
PostgreSQL is very scalable both in the sheer quantity of data it can manage and in the number of concurrent users it can accommodate.
There are active PostgreSQL systems in production environments that manage in excess of 4 terabytes of data.
Included in the standard function library are built-in functions that range from basic math and string operations to cryptography and Oracle compatibility.
Triggers and stored procedures can be written in C and loaded into the database as a library, allowing great flexibility in extending its capabilities. Similarly, PostgreSQL includes a framework that allows developers to define and create their own custom data types along with supporting functions and operators that define their behavior.
As a result, a host of advanced data types have been created that range from geometric and spatial primitives to network addresses to even ISBN/ISSN (International Standard Book Number/International Standard Serial Number) data types, all of which can be optionally added to the system.
As there are many procedure languages supported by PostgreSQL, there are also many library interfaces as well, allowing various languages both compiled and interpreted to interface with PostgreSQL: Java (JDBC), ODBC, Perl, Python, Ruby, C, C++, Lisp, Scheme, Qt, PHP, etc.
The PostgreSQL License is very similar to BSD or MIT's free licenses.
This page contains links only to the source code of PostgreSQL. For binary relases go here for the Windows version, here for the Linux version and here for the Mac version.
Most important functions of PostgreSQL:
Technical Features:
maximum Database Size - Unlimited
• Maximum Table Size - 32 TB
• Maximum Row Size - 1. 6 TB
• Maximum Field Size - 1 GB
• Maximum Rows per Table - Unlimited
• Maximum Columns per Table - 250 to 1600 depending on column types
• Maximum Indexes per Table - Unlimited
News in the current PostgreSQL version:
fix possible deadlock during backend startup.
• Fix possible crashes due to not handling errors during relcache reload cleanly.
• Fix possible crash due to use of dangling pointer to a cached plan.
• Fix possible crash due to overenthusiastic invalidation of cached plan for ROLLBACK.
• Fix possible crashes when trying to recover from a failure in subtransaction start.
• Fix server memory leak associated with use of savepoints and a client encoding different from server's encoding.
• Fix incorrect WAL data emitted during end-of-recovery cleanup of a GIST index page split.
• Disallow GSSAPI authentication on local connections, since it requires a hostname to function correctly.
• Protect ecpg against applications freeing strings unexpectedly.
• Make ecpg report the proper SQLSTATE if the connection disappears.
• Fix translation of cell contents in psql \ d output.
• Fix psql's numericlocale option to not format strings it shouldn't in latex and troff output formats.
• Fix a small per-query memory leak in psql.
• Make psql return the correct exit status (3) when ON_ERROR_STOP and --single-transaction are both specified and an error occurs during the implied COMMIT.
• Fix pg_dump's output of permissions for foreign servers.
• Fix possible crash in parallel pg_restore due to out-of-range dependency IDs.
• Fix plpgsql failure in one case where a composite column is set to NULL.
• Fix possible failure when calling PL/Perl functions from PL/PerlU or vice versa.
• Add volatile markings in PL/Python to avoid possible compiler-specific misbehavior.
• Ensure PL/Tcl initializes the Tcl interpreter fully.

PostgreSQL 8.4.4 scripting tags: database, postgresql, system, storage, data storage, object-relational database, database application, maximum, fix. What is new in PostgreSQL 8.4.4 software script? - Unable to find PostgreSQL 8.4.4 news. What is improvements are expecting? Newly-made PostgreSQL 8.5 will be downloaded from here. You may download directly. Please write the reviews of the PostgreSQL. License limitations are unspecified.