Very easy, just add a repository and run apt-get install postresql-9.0 
Dctr Watson explains how:
Category: PostgreSQL
Back in December 
of 2007, Andrew E. Bruno wrote an excellent article on how to use the open source program Dia to design databases. He used the resultant design to create a MySQL database but the same principles could be used to create just about any relational database from the design. Dia is available for Linux, *nix, and Windows.
Database Design with Dia
In this post I’m going to give a quick how-to on creating database schemas with a wonderful tool called Dia. I’ve often found having a nice visual representation of a database to be quite helpful but can’t stand keeping it up to date. As soon as you add a new column or change the design around you end up having to sync your visual diagram with your SQL files. It’s tedious having to manage the various SQL for building the database and this can be a larger pain when trying to support different database platforms each with their own SQL syntax. So before you create your next database read on and see how Dia can make your life a bit easier.
Dia is a program for creating diagrams and for this exercise we’ll be creating UML diagrams from within Dia. We’re also going to use a perl script called tedia2sql which will transform our Dia files directly to SQL for our target database. What’s also nice about creating database schemas this way is that you can generate SQL for multiple target databases without the maintenance overhead.
Adrian Bridgwater
Migration migraines: the top seven DBA data headaches
Once or twice a year I get to work with an excellent DBA pal from Illinois called Jason Froebe who describes himself as a, “Perlmonger capable of speaking fluent munchkin.” His personal blog is called Ramblings of a Geek, but I keep telling him he should rename it “Froebe’s Frontal Lobe”.
The work that Adrian mentions is a last minute article for the International Sybase User’s Group that I wrote and he edited. The benchmarking article that many people are waiting for is being held up by several groups giving their approval for the release of the material.
As always, it is a real pleasure to work with Adrian
The latest craze from software vendors to companies is to charge for each and every core a machine has regardless of whether or not you’re going to use it.
Get this, if you want to buy a production license for your database/middleware/web server, the vendor (starts with an “S”) wants you to send them the hardware specs of the box. If you tell them it is a Dell superduper server with 8 quad core CPUs and 96GBytes of RAM but you only will be using a single core for the database and devoting the rest to the middleware/webserver, you STILL have to pay the vendor for all 32 cores (8 CPUs X 4 cores). Your software license costs is now 32 times MORE what you should have to pay IMHO.
Lots of software companies are now doing this anti-customer practice just to beef up their short term revenues.
What makes them think that you won’t go to another vendor?
- Their competitors are probably doing the same sales tactic
- They have you by the family jewels, vendor lock in, and it will cost you far too much $$$ to migrate
- They think that you’re too stupid and/or timid to call their bluff
- FUD that is spread by well meaning and well known folk that don’t know jack about the open source alternatives
Who the hell do they think they are?
MyDatabases Volume 1 Issue 1 (July 2008)
Geek Spotlight: Michael Peppler
Sybase ASE on Ubuntu 8.04
Multicore Processors
VMware Virtualization
Logical Process Manager
