Project

General

Profile

« Previous | Next » 

Revision 13009

Added by Aaron Marcuse-Kubitza almost 11 years ago

/README.TXT: Full database import: documented that env vars set before invoking `screen` will be inherited by it, so these steps will work even if they come before `screen`

View differences:

trunk/README.TXT
56 56 
		make backups/vegbien.<version>.backup/remove
57 57 
		To keep a previous import other than the public schema:
58 58 
			export dump_opts='--exclude-schema=public --exclude-schema=<version>'
59 
			# env var will be inherited by `screen` shell
59 60 
	Make sure there is at least 350GB of disk space on /: df -h
60 61 
		The import schema is 315GB, and may use additional space for temp tables
61 62 
		To free up space, remove backups that have been archived on jupiter:
62 63 
			List backups/ to view older backups
63 64 
			Check their MD5 sums using the steps under On jupiter below
64 65 
			Remove these backups
65 
	screen
66 
	Press ENTER
67 
	unset TMOUT # TMOUT causes screen to exit even with background processes
68 
	set -o ignoreeof #prevent Ctrl+D from exiting `screen` to keep attached jobs
69 
	unset version # it may have been set in the outer shell
66 
	unset version # clear any version from last import, etc.
70 67 
	if no commits have been made since the last import (eg. if retrying an
71 68 
		import), set a custom version that differs from the auto-assigned one
72 69 
		(would otherwise cause a collision with the last import):
73 70 
		svn info
74 71 
		extract the svn revision after "Revision:"
75 72 
		export version=r[revision]_2 # +suffix to distinguish from last import
73 
			# env var will be inherited by `screen` shell
74 
	screen
75 
	Press ENTER
76 
	unset TMOUT # TMOUT causes screen to exit even with background processes
77 
	set -o ignoreeof #prevent Ctrl+D from exiting `screen` to keep attached jobs
76 78 
	Start column-based import: . bin/import_all
77 79 
		To use row-based import: . bin/import_all by_col=
78 80 
		To stop all running imports: . bin/stop_imports

Also available in: Unified diff