There are many scripts, but they should get run automatically as part of the install process that happens when the web server receives its first request. It's not clear exactly what the problem is from this error… either your "cpas" database got created, but the core module scripts did not run successfully OR there's a problem in server startup that is preventing all access to the database.

Again, you should post your full cpas.log so we can diagnose the problem.

Attached, thanks.

Looking at the first error in the log, the issue is that the CPAS database is there but the core schema isn't. This means the bootstrap SQL script didn't run (or didn't run successfully).

Shut down Tomcat, drop your cpas database using pgAdmin III or dropdb, then restart Tomcat. CPAS should create the database and run the bootstrap script at CPAS init time. The first request you make to your CPAS site should result pages asking you to enter an email address, choose a password, and login for the first time. This bootstraps the first administrator. You should now see a module install screen listing 10 or so modules that need to be installed. Choose "Express Install" and all the SQL scripts associated with these modules should run.

If you see anything different than this or encounter errors along the way then save your log file and post it here.

Ok, I killed tomcat, dropped the db, restarted tomcat and got this error after clicking 'express install': The following error occurred while running SQL script(s) in module Core:

prop-0.00-1.00.sql: ERROR: language "plpgsql" does not exist

After creating the database, then drawing the error, I ran this command as the postrgres user

createlang --dbname=cpas -W plpgsql

Now all seems ok.

Yes… from the manual install instructions:

"Install PostgreSQL with the following standard PostgreSQL modules at a minimum: server, psql, plpgsql, jdbc, binfiles."