Forum OpenACS Q&A: Response to Unable to get ACS working

I would suggest that some (if not all) of your problems are related to permissions after seeing this:

ERROR: Only users with Postgres superuser privilege are permitted to create procedural language

Are you logged on as a user with Postgres superuser privileges?  The other errors look like they are related to not having psql available, and from already having created some of the data model.

Try logging on as a Postgres superuser, dropping the database, and rerunning the data model.