Difference between revisions of "SAC:Migration Commands"
Jump to navigation
Jump to search
(Created page with 'stash of commands I'm using in the migration. osgeo1: $ time for trac in `cat tracs`; do pg_dump -f $trac.dump $trac; done $ cd .. $ zip -9r db.zip trac-db $ scp db.zip tracsvn…') |
|||
| Line 2: | Line 2: | ||
osgeo1: | osgeo1: | ||
| − | + | {{{ | |
$ time for trac in `cat tracs`; do pg_dump -f $trac.dump $trac; done | $ time for trac in `cat tracs`; do pg_dump -f $trac.dump $trac; done | ||
$ cd .. | $ cd .. | ||
$ zip -9r db.zip trac-db | $ zip -9r db.zip trac-db | ||
$ scp db.zip tracsvn.osgeo.osuosl.org | $ scp db.zip tracsvn.osgeo.osuosl.org | ||
| − | + | }}} | |
tracsvn: | tracsvn: | ||
| − | + | {{{ | |
$ unzip db.zip | $ unzip db.zip | ||
$ cd trac-db | $ cd trac-db | ||
$ time for i in `cat tracs`; do dropdb $i; createdb $i; psql -f $i.dump $i; done | $ time for i in `cat tracs`; do dropdb $i; createdb $i; psql -f $i.dump $i; done | ||
| − | + | }}} | |
$ rsync -rav trac root@tracsvn.osgeo.osuosl.org:/var/www/ | $ rsync -rav trac root@tracsvn.osgeo.osuosl.org:/var/www/ | ||
Revision as of 11:34, 7 June 2010
stash of commands I'm using in the migration.
osgeo1: {{{ $ time for trac in `cat tracs`; do pg_dump -f $trac.dump $trac; done $ cd .. $ zip -9r db.zip trac-db $ scp db.zip tracsvn.osgeo.osuosl.org }}} tracsvn: {{{ $ unzip db.zip $ cd trac-db $ time for i in `cat tracs`; do dropdb $i; createdb $i; psql -f $i.dump $i; done }}}
$ rsync -rav trac root@tracsvn.osgeo.osuosl.org:/var/www/