PostGreSQL 8.2

PostgreSQL is an object-relational database management system (ORDBMS). It is released under a BSD-style license and is thus free software. As with many other open-source programs, PostgreSQL is not controlled by any single company, but relies on a global community of developers and companies to develop it.

PostgreSQL's unusual-looking name makes some readers pause when trying to pronounce it, especially those who pronounce SQL as "sequel". PostgreSQL's developers pronounce it /poːst ɡɹɛs kjuː ɛl/; (Audio sample, 5.6k MP3). It is also common to hear it abbreviated as simply "postgres", which was its original name. Indeed, since support for the SQL standard is now ubiquitous amongst all relational databases, the community is considering changing the name back to Postgres. The name refers to the project's origins as a "post-Ingres" database, the original authors having also developed the Ingres database.

This release adds many functionality and performance improvements that were requested by users, including:

• Query language enhancements including INSERT/UPDATE/DELETE RETURNING, multirow VALUESUPDATE/DELETE
• Index creation without blocking concurrent INSERT/UPDATE/DELETE operations
• Many query optimization improvements, including support for reordering outer joins
• Improved sorting performance with lower memory usage
• More efficient locking with better concurrency
• More efficient vacuuming
• Easier administration of warm standby servers
• New FILLFACTOR support for tables and indexes
• Monitoring, logging, and performance tuning additions
• More control over creating and dropping objects
• Table inheritance relationships can be defined for and removed from pre-existing tables
• COPY TO can copy the output of an arbitrary SELECT statement
• Array improvements, including nulls in arrays
• Aggregate-function improvements, including multiple-input aggregates and SQL:2003 statistical functions
• Many contrib/ improvements, lists, and optional target-table alias in
  

Download:

http://wwwmaster.postgresql.org/download/mirrors-ftp?file=%2Fbinary%2Fv8.2.5%2Fwin32%2Fpostgresql-8.2.5-1.zip

How do i install PostGre SQL on Windows Vista ?

1. Start/All Programs/Accessories
2. Right-click on Command Prompt
3. Select "Run as Administrator"
4. Click OK on the dialog that appears
5. Type cd\and hit enter [The directory where you put the install files]
6. If you've copied the postgresql-8.2.msi installer file on drive c:\, Type run postgresql-8.2.msi and hit enter.

How do i install + create a local server ?

1. Double-click on postgresql-8.2.msi
2. Click on next 3 times
3. When you come to the service configuration window
- Check the Install as a service box
- Fill the fields, click next
4. Fill the fields in the intialiase database cluster window
- Remember the superuser name * and password ** you have entered, hit next.

Creating a server on Localhost

Once installed, open PGAdmin III, Click on Add a connection to a server button

Fill in the fields as follows:



Host: localhost
Port: 5432
Maintenance DB: template1
Username: Enter the username you've inserted previously *
Password: Enter the password you've inserted previously **



Hit Ok



Credits: Mau