It's better to use the "createlang" script. 'createlang plpgsql mydb'. If you use that against the 'template1' database, then all your databases will have it by default.