andersk Git - moira.git/blame_incremental

... / ...

Commit	Line	Data
	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
	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]
	21
	22
	23	Example:
	24
	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
	38
	39
	40	THINGS TO DO:
	41
	42	automate generation of stub procs in newmoira.qc