Forum OpenACS Q&A: Response to Errors when loading data-model

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.