Installing Postgresql on ubuntu box on 32-bit machines is pretty easy, you will just type in:
$ sudo apt-get install postgresql
It will prompt for password and you’re all set. It will do all the initialization, creation of db roles/users.
But on 64-bit machines, after doing that ‘apt-get’ thing, you need to do some initial configuration.
Ok , the command:
$ pg_createcluster <version> <name>
$ pg_createcluster 8.4 main
The 8.4 is the version of the postgresql you installed and ‘main’ is the name of the cluster, you can change it in any name you want.
And that’s it!Share on Facebook