[moira.git] / db / README

/mit/moiradev/db/README: $Header$

This directory contains stuff necessary to create and initialize a
Moira database.  Note that some other directories rely on files here
(notably newdb), and that the newmoira program relies on other files.

STEPS TO CREATE A DATABASE (Ingres-specific instructions):

-1.Make sure there is enough disk space on the partition which is to
   hold the database.  Building the indexes for Athena takes something
   like 50 Meg of free disk space, *after* the ~100 Meg for the base DB.
0. If necessary, run "destroydb moira" from the shell. [a few seconds]
1. Run "createdb moira" from the shell. [a minute or so]
2. Run the sql commands in src/db/schema to create the tables. [a few seconds]
3. Run mrrestore. [10-20 hours on a decstation]
4. If you want any queries to be publically executable, change their
   capacls entries from list_id 2 to 1.
5. Run the sql commands in src/db/dbopt to create indices on the data.
   Any failures are probably due to insufficient disk space.  (Check
   /ingres/files/errlog.log to make sure.) [ <= 1 hour on a decstation]  
  

Example:

    createdb moira
    sql moira
	\include schema
	\go
	\quit
    /moira/bin/mrrestore moira
	yes
	yes
	<path prefix with trailing '/'>
	yes
    sql moira
	\include dbopt
	\quit


THINGS TO DO:

automate generation of stub procs in newmoira.qc
Commit	Line	Data
af793a86	1	/mit/moiradev/db/README: $Header$
	2
	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.
	6
	7	STEPS TO CREATE A DATABASE (Ingres-specific instructions):
	8
	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
51e7c423	17	capacls entries from list_id 2 to 1.
af793a86	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]
	21
51e7c423	22
	23	Example:
	24
af793a86	25	createdb moira
	26	sql moira
	27	\include schema
	28	\go
	29	\quit
	30	/moira/bin/mrrestore moira
	31	yes
	32	yes
	33	<path prefix with trailing '/'>
	34	yes
	35	sql moira
	36	\include dbopt
	37	\quit
51e7c423	38
	39
	40	THINGS TO DO:
	41
68566efb	42	automate generation of stub procs in newmoira.qc