PostgreSQL 8 Beta Released

By Blane Warrene
We teamed up with SiteGround
To bring you the latest from the web and tried-and-true hosting, recommended for designers and developers. SitePoint Readers Get Up To 65% OFF Now

PostgreSQL has made the leap from 7.4 to 8 Beta with several new features of interest. Front and center to many will be the native Windows support. Prior to this release the database platform only ran on Windows within Unix emulation under Cygwin. PostgreSQL can run as a service and supports Windows NT 4, Windows 2000, XP and 2003.

Additional features include the ability to control what filesystems hold databases, indexes and more. This feature, known as tablespaces, can improve system performance.

A utility called Point-In-Time recovery has expanded backup capabilities to provide ongoing restore points for easier recovery from hardware failure.

A complete list of new features and functions, as well as interoperability issues for those migrating to the new release can be found at

We teamed up with SiteGround
To bring you the latest from the web and tried-and-true hosting, recommended for designers and developers. SitePoint Readers Get Up To 65% OFF Now
  • As far as I’m concerned, the most exciting feature in version 8.0 is the ability to change a column’s data type using ALTER TABLE! This is my greatest biggest annoyance with PostgreSQL at the moment and it will be great to see it finally fixed.

  • Wow :D

    If this database can now run on a Win OS then this is going to be well smart :)

    Installed one hybrid of Postgre before on Win2000 but it never felt ‘right’, but now without cygwin on Windows, this is going to make a lot of folks (myself for example) think about supporting this database now.

    Going to have a look see, thanks for the info btw.

  • I ran into a ton of trouble trying to get v7 running under cygwin. I may just give 8 a go now that it supports Win natively.

    Mind you, I’ve become pretty loyal to MySQL over the years, so it would take a fair bit for me to move.

  • andre

    too bad i’m using FAT32 on my WinXP instead of NTFS (for compatibility with my old Win98). PgSQL 8.0 beta 1 on win32 aborts when you attempt to install it on a non-NTFS partition :(

    hmm…i’ll just try to convert it to NTFS, then retry the installation and see…some people in other forums have said that the win32 beta is very stable

  • Brendan

    This rocks! Even having used MySQL more than PostgreSQL, I far prefer PostgreSQL. It’s suprising how many PHP tutorials still use MySQL – I presume that lack of a good Windows port has been the main thing stopping many newbie developers from using it…?

  • Curious

    Its great that PostgreSQL will be becoming available natively for Windows (at least on NTFS partitions, it seems).

    But I’m surprised and curious about the commenters that seem to think MySQL has been the only other open source option. Firebird already natively supports several operating systems including Windows and Linux, and has done so for a long time. Along with PostgreSQL, it is in the category of a full featured, ACID compliant RDBMS, in contrast to MySQL.

  • cmtk

    Finally! i’ve been waiting for this for a while. postgres is a far better database compared to mysql (except while retrieving small records where mysql excels). i think this could possibly be the end of mysql if the postgres installation and usage can be made a little easier for the newbie..

  • Kan

    !!! C’est de la bombe de balle !!!
    — Viva el NetDataGeneration —

    I just install my lovely PostgreSQL 8.0.0 beta4… Hum… I’m actually swimming between the brightly clouds of the data universe.
    It works fine for me (except the codepage in psql. – but I’m too lazy to check how to change it – Having some fun characters is not so bad :o)
    I’m now ready to code some udf, triggers, integrity, and other pretty animals.
    I had just past 4 hours trying to get Postgre 7.4 work on Windows, and then i discover the 8.0

    God Bless the FreeWares Coders