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 – https://help.ubuntu.com/community/PostgreSQL to no avail.
Finally found the cause to be a bug – https://bugs.launchpad.net/ubuntu/+source/postgresql-8.4/+bug/558319
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 – http://www.postgresql.org/download/linux. I downloaded – postgresql-8.4.3-1-linux-x64.bin and followed the instructions at – http://www.enterprisedb.com/learning/pginst_guide.do
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.