Download List

Project Description

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.

System Requirements

System requirement is not defined
Information regarding Project Releases and Project Resources. Note that the information here is a quote from page, and the downloads themselves may not be hosted on OSDN.

2009-07-02 04:49

Parallel Database Restore, speeding up recovery from backup up to 8 times. Per-Column Permissions, allowing more granular control of sensitive data. Per-database Collation Support, making PostgreSQL more useful in multi-lingual environments. In-place Upgrades through pg_migrator (beta), enabling upgrades from 8.3 to 8.4 without extensive downtime. New Query Monitoring Tools, giving administrators more insight into query activity. Greatly reduced VACUUM overhead through the Visibility Map. New monitoring tools for current queries, query load, and deadlocks.

2009-04-04 03:32

This release prevents error recursion crashes when encoding conversion
fails, disallows CREATE CONVERSION with the wrong encodings for the
specified conversion function, and fixes xpath() to not modify the path
expression unless necessary, and to make a saner attempt at it when
Tags: stable 8.3

2008-06-16 13:06

pg_get_ruledef() now parenthesizes negative
constants. ALTER AGGREGATE ... OWNER TO was made
to update pg_shdepend.
Tags: Minor bugfixes, Stable

2007-04-30 16:30

A privilege escalation exploit in SECURITY DEFINER
functions was patched.
Tags: Major security fixes, Stable

2006-06-29 22:18

The server has been changed to reject invalidly-encoded multi-byte characters in all cases. This release rejects unsafe uses of \' in string literals. libpq's string-escaping routines have been modified to be aware of encoding considerations and standard_conforming_strings.
Tags: Major security fixes, Stable

Project Resources