Archive for the ‘PostgreSQL’ Tag

PostgreSQL 8.4 on Ubuntu 10.04

I’ve been struggling to install PostgreSQL Server 8.4 on Ubuntu 10.04.

I created a new user “postgres” using the Users Settings Tool (System > Administration > Users and Groups) and tried to install the PostgreSQL database server and pgAdmin III tool using the “Software Update Center”. Although the server seems to have been installed, I was unable to start it.
I tried the instructions mentioned at – to no avail.

Finally found the cause to be a bug –

Anyway, since I had to create a small Proof-Of-Concept for a project I’m working on, I really wanted to install PostgreSQL as the database.

So I went to the PostgreSQL site and downloaded the one-click installer from – I downloaded – postgresql-8.4.3-1-linux-x64.bin and followed the instructions at –

This was much simpler and I was able to install the server and all the necessary tools in less than 10 minutes. I now have a nice PostgreSQL 8.4 Menu under the Application Menu with a number of options viz. start server, stop server etc. These menu items along with the pgAdmin III tool definitely make working with PostgreSQL lot easier.

PostgreSQL 8.4 on Ubuntu 10.04