SAC:Migration Commands

From OSGeo
Jump to navigation Jump to search

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/