Thanks for all the replies.. I understand the use of the templates and now the relevance of template0 and template1. I had never paid close attention to them before while using Linux. ...But when the error showed itself using pgAdmin II I had to learn more.
