PostgreSQL is a robust relational database system with over 25 years of active development that runs on all major operating systems. It is fully ACID compliant, and has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It includes most SQL92 and SQL99 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP. It also supports storage of binary large objects, including pictures, sounds, or video. It has native programming interfaces for C/C++, Java, .Net, Perl, Python, Ruby, Tcl, and ODBC, among others, and exceptional documentation.
Information regarding Project Releases and Project Resources. Note that the information here is a quote from Freecode.com page, and the downloads themselves may not be hosted on OSDN.
There are several major new features in this release, including synchronous replication and other replication features, per-column collations, unlogged tables, extensions, K-Nearest-Neighbor indexing, Serializable Snapshot Isolation, Writeable Common Table Expressions, SE-Postgres (Military-grade security), the PostgreSQL Extension Network, and SQL/MED (Management of External Data), with foreign data wrappers for Oracle, MySQL, CouchDB, Redis, CSV, Twitter, and more. There have also been improvements in performance and database administration, and several SQL and PL/PgSQL features.
This is a bugfix release that fixes issues with pg_upgrade, non-hot-standby recovery, deadlock issues with catalog cache initialization, updates to time zone data files, and several other minor bugs.
Built-in replication based on log shipping. Easier database object permissions management. pg_upgrade to support in-place upgrades. Multiple performance enhancements for specific types of queries. Full support for 64-bit Windows.
This is a security release, plus 48 minor bugfixes.
This is a bugfix release.