PostgreSQL
Old Version of PostgreSQL 8.4.8
Selected Version
PostgreSQL 8.4.8
Supported Systems
Legacy OS support
Windows XP, Vista, 7, 2003, 2008
License
Open Source
Release Date
18 April, 2011 (3 years ago )

Sponsored Links

Download PostgreSQL 8.4.8
PostgreSQL 8.4.8

PostgreSQL 8.4.8 (42.04 MB)

Sponsored Links

System Requirements of PostgreSQL 8.4.8
  • Windows XP
  • Windows Vista
  • Windows 7
Program Information of PostgreSQL 8.4.8
Version Name:
PostgreSQL 8.4.8

File Size:
42.04 MB

Released Date:
18 April, 2011 (3 years ago)

MD5 Checksum:
cf57793fead8a65ca4796f76f949cde4

SHA1 Checksum:
162E8FA41C2398394C921F1FEE4A03A7EDACFD6C

Version History of PostgreSQL 8.4.8
  • Fix pg_upgrade's handling of TOAST tables (Bruce Momjian)
  • The pg_class.relfrozenxid value for TOAST tables was not correctly copied into the new installation during pg_upgrade. This could later result in pg_clog files being discarded…

View More...

PostgreSQL Screenshots
The release of PostgreSQL 8.4 has a slew of built-in features that allow you to improve both performance and systems administration. PostgreSQL is a powerful,… More
That’s the main interface of Postgres which supports features like Data integrity include (compound) primary keys, foreign keys with restricting and… More
Make a Connection to make use of PostgreSQL which runs stored procedures in more than a dozen programming languages, including Java, Perl, Python, Ruby,… More
About PostgreSQL

PostgreSQL is a powerful, open source object-relational database system. 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 systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows. It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It includes most SQL:2008 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, ODBC, among others, and exceptional documentation.

An enterprise class database, PostgreSQL boasts sophisticated features such as Multi-Version Concurrency Control (MVCC), point in time recovery, tablespaces, asynchronous replication, nested transactions (savepoints), online/hot backups, a sophisticated query planner/optimizer, and write ahead logging for fault tolerance. It supports international character sets, multibyte character encodings, Unicode, and it is locale-aware for sorting, case-sensitivity, and formatting. It is highly 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. Some general PostgreSQL limits are included in the table below.

 

LimitValue
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 - 1600 depending on column types
Maximum Indexes per Table Unlimited

More information could be found at http://www.postgresql.org/about/


Updates : PostgreSQL Updates

Did You Know?

In version 8.3 PostgreSQL added Full text search, SQL/XML, ENUM types, UUID types.