Your Daily Source for Apache News and Information  
Breaking News Preferences Contribute Triggers Link Us Search About
Apache Today [Your Apache News Source] To internet.com

Apache HTTPD Links
Apache Module Registry
The Java Apache Project
Apache-Perl Integration Project
PHP Server Side Scripting
Apache-Related Projects
The Apache Software Foundation
Apache XML Project
ApacheCon
Apache Project
The Jakarta Project
The Apache FAQ
The Linux Channel at internet.com
Linux Planet
Just Linux
Linux Apps
BSD Today
Enterprise Linux Today
All Linux Devices
Linux Today
Linuxnewbie.org
Linux Start
Linux Central
PHPBuilder
Linux Programming
Apache Today
BSD Central
SITE DESCRIPTIONS
PostgreSQL v7.2 Final Release
Feb 6, 2002, 22 :06 UTC (4 Talkback[s]) (27315 reads) (Other stories by Marc G. Fournier)

After almost a full year of development since PostgreSQL v7.1 was released, the PostgreSQL Global Development Group is proud to announce the availability of our latest development milestone ... PostgreSQL v7.2, another step forward for the project.

A full list of changes to v7.2 can be found in the HISTORY file, included with the release, as well as under all ftp mirrors as:

                /pub/README.v7_2

Highlights of this release are as follows:

VACUUM

Vacuuming no longer locks tables, thus allowing normal user access during the vacuum. A new "VACUUM FULL" command does old-style vacuum by locking the table and shrinking the on-disk copy of the table.

Transactions

There is no longer a problem with installations that exceed four billion transactions.

OID's

OID's are now optional. Users can now create tables without OID's for cases where OID usage is excessive.

Optimizer

The system now computes histogram column statistics during "ANALYZE", allowing much better optimizer choices.

Security

A new MD5 encryption option allows more secure storage and transfer of passwords. A new Unix-domain socket authentication option is available on Linux and BSD systems.

Statistics

Administrators can use the new table access statistics module to get fine-grained information about table and index usage.

Internationalization

Program and library messages can now be displayed in several languages.

.. with many many more bug fixes, enhancements and performance related changes ...

Source for this release is available on all mirrors under:

                /pub/source/v7.2

As always, any bugs with this release should be reported to [email protected] ... and, as with all point releases, this release requires a complete dump and reload from previous releases, due to internal structure changes ...


Marc G. Fournier
Co-ordinator
PostgreSQL Global Development Group

Related Stories:
LinuxWorld: How to save an Apache log file in a PostgreSQL database(Oct 09, 2001)
ComputerWorld: Open source databases bloom(Sep 13, 2001)
Great Bridge PostgreSQL 7.1 package announced(Jul 09, 2001)
PostgreSQL v7.1 Release(Apr 14, 2001)

  Current Newswire:
Apache 2.0.32 beta is available

Everything Solaris: Apache: The Basics

Apache Jakarta James Mailserver v2.0a2 Released

PostgreSQL v7.2 Final Release

Daemon News: Multiple webservers behind one IP address

Zend Technologies launches Zend Studio 2.0

NuSphere first to enable development of PHP web services

Covalent Technologies raises $18 million in venture capital

Apache 1.3.23 released

wdvl: Build Your Own Database Driven Website Using PHP and MySQL: Part 4

 Talkback(s) Name  Date
They finally got rid of the table locking VACUUM!That "feature" was the last maj ...   Excellent!   
  Feb 6, 2002, 22:50:34
YAY!!!!!!I may need to get a life . . . . butYAY !!!!!Eric ...   Thre New Postgres is Here !!   
  Feb 6, 2002, 23:04:04
I think I'll be busy in a few days...cheers,--Xunil Ung ...   brilliant!...and thank you...   
  Feb 7, 2002, 00:14:29
It is great to check how Open Source Databases keep improving ...You can check w ...   Open source Databases keep improving   
  Feb 7, 2002, 15:43:51
Enter your comments below.
Your Name: Your Email Address:


Subject: CC: [will also send this talkback to an E-Mail address]
Comments:

See our talkback-policy for or guidelines on talkback content.

About Triggers Media Kit Security Triggers Login


All times are recorded in UTC.
Linux is a trademark of Linus Torvalds.
Powered by Linux 2.4, Apache 1.3, and PHP 4
Copyright 2002 INT Media Group, Incorporated All Rights Reserved.
Legal Notices,  Licensing, Reprints, & Permissions,  Privacy Policy.
http://www.internet.com/