Install Postgresql 9.1 in Ubuntu 9.04

first install python-software-properties:
sudo apt-get install python-software-properties

now add repository and update apt.
sudo add-apt-repository ppa:pitti/postgresql
sudo apt-get update

now instal postgresql
sudo apt-get install postgresql-9.1 libpq-dev

Now change the postgres user password (still running as root):
su postgres
psql -d postgres -U postgres
alter user postgres with password 'a';
\q

To install GUI client pgsql
sudo apt-get install pgadmin3

original article: http://bit.ly/sUFCgb

How to Accomplish More by Doing Less - Tony Schwartz - Harvard Business Review

How to Accomplish More by Doing Less - Tony Schwartz - Harvard Business Review.

Enable AutoComplete commands in Pinguy OS 11.04

To enable bash completion in interactive shells do following steps:

$ sudo vi /etc/bash.bashrc

uncomment following line in it

# enable bash completion in interactive shells
if [ -f /etc/bash_completion ]; then
. /etc/bash_completion
fi


Restart your terminal and its done!!!

Fix GPG error:....NO_PUBKEY

In Ubuntu, when we try to update the system we sometimes get error for GPG No_PUBKEY as follows:


W: An error occurred during the signature verification. The repository is not updated and the previous index files will be used. GPG error: http://ppa.launchpad.net lucid Release: The following signatures couldn't be verified because the public key is not available: NO_PUBKEY C1622487AAA521A8

This does no harm as its not a security issue but its very annoying everytime getting the same error. It happens because you don't have a suitable public key for a repository. Follow this steps to get rid of the error:


gpg --keyserver keyserver.ubuntu.com --recv 9BDB3D89CE49EC21

Which retrieves the key from ubuntu key server and then this:


gpg --export --armor 9BDB3D89CE49EC21 | sudo apt-key add -

Which adds the key to apt trusted keys. This will solve you problem.

The solution can be found here & here.