WireWorld » Hacks » Wirehead on Hacking
Upgrading major versions of PostgreSQL with Debian or Ubuntu
One problem with PostgreSQL as compared to MySQL is that PostgreSQL is a *real* database, whereas MySQL is a bunch of hacks. This means that PostgreSQL doesn't let you just drop a new version of the executable on an old database file. Which is pretty much the way that real databases prefer to work.