I'm pretty sure this error indicates that you do not have the plpgsql language installed on your database. Assuming your host provides you with some tool for managing the db, you can run a script to install the plpgsql language. You can get the script here.
After installing the plpgsql language just visit the mojoportal setup page again.
Hope it helps,