PostgreSQL 8.4 Proves Feature-Rich
The free database system PostgreSQL is available in version 8.4 with numerous new features and enhancements.
The PostgreSQL Group counts 293 enhancements for its 8.4 release over its predecessor. Among the most important is Parallel Restore, with up to eight times faster backup file restoration, which can apply to 8.2 and 8.3 backups as well. As far as database security, column-level permissions can now be set along with the table itself.
The sorting methods (character collations) can be set by database apart from at installation, a welcome feature for multilingual environments. A few new monitoring features will also be helpful for large enterprise environments.
The query language was enhanced through advanced features of the SQL 2003 ANSI standard, such as aggregate operations through windowing. Common table expressions allowing named subqueries and recursive joins also reduce queries to far fewer than previously required.
An overview of the PostgreSQL 8.4 feature enhancements is available as a list or a matrix comparing it to the previous five releases.
PostgreSQL is ready for download under a BSD license. Apart from the source code, there are binary packages for 32-bit and 64-bit Intel CPUs, with specific distro packages also in the offering.
Subscribe to our Linux Newsletters
Find Linux and Open Source Jobs
Subscribe to our ADMIN Newsletters
Digital Autonomy
• The Answer Was Already on the Shelf
• Changing the Chip Industry: How Public Investment Has Grown Open Silicon
• United Nations Open Source Portal Goes Live
• EU Open Source Strategy Plays Key Role in Tech Sovereignty Package
• France Says “Au Revoir” to Microsoft
Support Our Work
Linux Magazine content is made possible with support from readers like you. Please consider contributing when you’ve found an article to be beneficial.
News
-
Pine64 Halts Production of Linux Devices
With continued DRAM and eMMC shortages, Pine64 has decided to discontinue production of Linux devices.
-
The Bullet-Proof KDE Software Initiative Is Coming
KDE, Techpaladin, and Kubuntu Focus have announced a new initiative that will provide at least three years of support for KDE Plasma 6.6 LTS and related software.
-
Linux Mint Shares a Possible Kernel Cleanup Solution
For those on Linux Mint who like to keep multiple kernels around but don't want them to take up too much space, you might be getting a new automated tool.
-
CachyOS Gets an Update
CachyOS August 2026 release is now available with the latest version of KDE, some new features, and plenty of improvements.
-
The Linux Kernel Dev Staging Area Now Rejects AI-Generated Patches
Unless a kernel patch is a valid security fix, it will be rejected if it was created using AI.
-
Linux Surpasses Double-Digit Market Share
According to two sources, the Linux operating system has hit a major milestone in market share that naysayers thought would never happen.
-
AI Helped Develop a Linux Exploit
A use-after-free race exploit was discovered and exploited on CentOS Stream 9.
-
Yet Another Linux Kernel Vulnerability Discovered
Affecting millions of systems, a kernel flaw discovered by Qualys could allow users to gain root privileges.
-
Ubuntu 26.10 to Include Ubuntu Certified Hardware Check
If you've ever wondered if your laptop or PC is officially certified to run Ubuntu, that curiosity will soon be met.
-
Substantial Update to IPFire Now Available
The lastest version of IPFire features a fundamental change to how the system handles DNS.