1 /mit/moiradev/db/README: $Header$
3 This directory contains stuff necessary to create and initialize a
4 Moira database. Note that some other directories rely on files here
5 (notably newdb), and that the newmoira program relies on other files.
7 STEPS TO CREATE A DATABASE (Ingres-specific instructions):
9 -1.Make sure there is enough disk space on the partition which is to
10 hold the database. Building the indexes for Athena takes something
11 like 50 Meg of free disk space, *after* the ~100 Meg for the base DB.
12 0. If necessary, run "destroydb moira" from the shell. [a few seconds]
13 1. Run "createdb moira" from the shell. [a minute or so]
14 2. Run the sql commands in src/db/schema to create the tables. [a few seconds]
15 3. Run mrrestore. [10-20 hours on a decstation]
16 4. If you want any queries to be publically executable, change their
17 capacls entries from list_id 2 to 1.
18 5. Run the sql commands in src/db/dbopt to create indices on the data.
19 Any failures are probably due to insufficient disk space. (Check
20 /ingres/files/errlog.log to make sure.) [ <= 1 hour on a decstation]
30 /moira/bin/mrrestore moira
33 <path prefix with trailing '/'>
42 automate generation of stub procs in newmoira.qc