PostgreSQL 8 was officially released this week and has many new features to bring to the open source database table (so to speak).
Of course front and center would be the long awaited native Win32 binary that allows PostgreSQL to run natively on Windows 2000, XP and 2003 as a service. A separate project is underway to ease installation and can be found on the pgFoundry web site (recommended by Postgres).
Other features with an eye toward high performance and stability are point in time backup and restore, which allows for continuous backups and user’s choice for restore points, and tablespaces, which allow for tables and indexes to be stored on different (or the same) filesystems. This latter being an excellent option when tweaking for performance or managing drive space.
Related posts:
- Opera 10 Final Released Opera 10 is the latest and greatest browser from the...
- Google Officially Drops the Beta Tag GMail and most other Google applications have officially ended their...
- Photoshop Mobile Released Adobe have announced the release of Photoshop for iPhone and...
- Backing Up Your Online Life Recently, I've been in the market for an online backup...
And, finally, you can alter column types.
That has long been my biggest gripe with PostgreSQL; inflexible table metadata.
We’re working on a project currently which uses Postgres 7.2; a version where you cannot even delete a column from a table. Incredibly frustrating!
January 20th, 2005 at 5:45 pm
I think the no-brainer access to MySQL through it’s inclusion in the Windows ‘all-in-one’ PHP development install kit (XAMPP, Apache2Triad and EasyPHP) has had a fair bit to do with it’s popularity. It will be interesting to see if PostGres starts popping up in those kits now.
January 20th, 2005 at 8:15 pm
Cool.
January 21st, 2005 at 1:08 pm
I like their new website too.
January 21st, 2005 at 9:16 pm
I added postgresql in apache2triad in just weeks after 8.0 was released , this windows version was eagerly awaited.
April 7th, 2005 at 9:40 am
I have added postgresql to apache2triad within less than 2 weeks after 8.0 was released having eagerly awaited for this windows version for quite some time
April 7th, 2005 at 5:02 pm