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/