Well, it really does look like your datamodel isn't there. How did you load the datamodel? You did use load-data-model.sql, didn't you? Did you follow the doc's recommendation and direct output to datamodel.txt? Try the following:
- bring up psql (where mydb is the name of the database that you created in the installation process for OpenACS)
<blockquote>psql mydb
</blockquote>
-- Check to see if the users table exists
# select 1 from users;
If this doesn't work, you've got major problems.
HTH