Blog Post RSS ?

Blogs » Open Source » PostgreSQL 8 Officially Released
« Logs, Damn Logs, and Browser Statistics
Are you a flake? »
 

PostgreSQL 8 Officially Released

by Blane Warrene

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.

This entry was posted on Thursday, January 20th, 2005 at 1:41 pm, contains 130 words, and is filed under Open Source. You can follow any responses to this entry through the RSS 2.0 feed. You can skip to the end and leave a response. Pinging is currently not allowed. The views and opinions in this blog post are those of its author.

This post has 6 responses so far

  1. z0s0 Says:
    January 20th, 2005 at 5:45 pm

    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!

     
  2. AlexW Says:
    January 20th, 2005 at 8:15 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.

     
  3. Darren884 Says:
    January 21st, 2005 at 1:08 pm

    Cool.

     
  4. PC_Freak Says:
    January 21st, 2005 at 9:16 pm

    I like their new website too.

     
  5. Vlad Alexa Mancini Says:
    April 7th, 2005 at 9:40 am

    I added postgresql in apache2triad in just weeks after 8.0 was released , this windows version was eagerly awaited.

     
  6. mancini Says:
    April 7th, 2005 at 5:02 pm

    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

     

Sponsored Links

Leave a response

You are not logged in, log in with your SitePoint Forum username and password.

-OR- Post Anonymously

* Make sure any code samples are escaped (i.e. ‘<b>’ becomes ‘&lt;b&gt;’).

If not logged in, your comments will be placed in a moderation queue. This means your comment may not appear until one of our moderators approves it.

Your Blogmaster is...

Blane Warrene

Blane Warrene

Blane is a writer and researcher focusing on Apple and Open Source technologies. Prior to this, he helped found a commercial software and consulting venture, and worked in the financial services sector as a director of technology and in varying technical roles. Blane maintains Open Sourcery: SitePoint's Open Source Blog.

Subscribe

SitePoint Newsletters

Get all the latest tips by signing up to all of SitePoint’s informative newsletters.

HTML   Plain

SitePoint Blogs

SitePoint Marketplace

Buy, Sell, Trade

Buy and sell Websites, templates, domain names, hosting, graphics and more.

Posting Code Snippets

Feel free to enter code snippets into your comments in the following format.

Marking Up Your Code
<pre>
<code class='html'> 
code snippet 
</code>
</pre>

Be sure to escape any HTML snippets (i.e. '<' becomes '&lt;' ).

Supported language classes include:

  • XML, HTML, XSLT and any other XML style code
  • CSS
  • C#
  • VB & VB.NET
  • Delphi, Pascal
  • JavaScript
  • PHP
  • Python
  • SQL