At the CPT we found that loading ontologies was an unpleasant and extremely slow process. In order to combat that, we automatically generate “Precompiled Chado Schemas“, which are blank chado schemas with all of the ontologies compiled in, and then exported.
You should be able to just restore from the SQL file as the ACLs and User have already been stripped.
psql -U [user] -h [database host] -d [database] < csb.sql
You can find the downloads here: https://cpt.tamu.edu/jenkins/job/Chado-Prebuilt-Schemas/19/
Update: Originally we had a Jenkins job which regularly compiled the schema. Then one of the ontologies broke was made inaccessible, and it still has not been fixed upstream. We will resume automated compilation when possible, but for now job 19’s outputs have been used effectively by multiple groups.