It looks like the pl/sql procedural language didn't get installed. Do a dropdb yourdb, createdb yourdb and then do psql -f postgres.sql yourdb >& error.log. Now look for errors in the error.log file. The postgres.sql file loads the pl/sql procedural language. Maybe the path in that file for plpgsql.so doesn't match the location of the library on your machine.