PostgreSQL 8.0 Released

Christopher Cashell writes "The PostgreSQL project has released version 8.0 of their well known Object-Relational Database. New features include: Win32 Native Server, Savepoints, Point-In-Time Recovery, Tablespaces, and lots more. Downloads are available via bittorrent for Unix/Linux, and the much anticipated Win32 version, or via ftp (use a mirror!)." (Here's the official announcement.)

Comments

Comment removed

[account_deleted]

Comment removed based on user account deletion

Vital Data

[_Hellfire_]

I wrote a PHP program that tracks my gf's and I's finances with a Postgresql database backend.

It's up to about 600 records now and although I wouldn't say it's mission critical it certainly is vital.

I have to say I'm extremely impressed with pgsql. It's easy to use and consistent in what it does. I have no complaints whatsoever. What I like most (although I'm not sure this is exclusive to pgsql) is the fact that I can at any time get a plain text dump of everything in the database in a format that makes sense. If the worst comes to the absolute worst, I can always mess around with awk and write a script which can convert a pg dump to another format. It gives me piece of mind that my data can always be read.

I've heard that ms sql users are not so fortunate - ie no plain text dumps. Correct me if I'm wrong.

Kudos to the pgsql team for such a fine product and keep up the good work!

Postgres-R

[SuperBanana]

There are a number of independent projects that want to create replication add-ons, like pgreplication [postgresql.org] and the older, more academic Postgres-R, but that's not really production quality so far.

Well, the gig was up after everyone figured out that Postgres-R was just Postgres with a big muffler and wing.

Re:Finally

[kpharmer]

>> I still believe that MySQL is the Access of the OSS dtabases

> Perhaps, except that it is n* times better. I've run some pretty intense, badly-written db-abusive
> e-commerce sites (we are talking $5 million per year in cash flow) using MySQL without problems.

Hmmm, but wouldn't it be better to use a database that doesn't silently truncate numbers so that you could be a $50 million per year company instead?

Re:PGSQL has its own gotchas

[Sxooter]

But the autovacuum daemon isn't enabled or even compiled by default. You have to go into contrib, compile and install it, and then turn it loose.

Soon, 8.1 or so, it will be integrated into the backend. It almost made it into 8.0, but missed it by "" - that much.