zhm · March 2, 2012 06:32
diff --git a/gistfile1.txt b/gistfile1.txt
 for file in ~/postgres_backups/*
 do
  dbname=$(basename $file | sed s/\.gz//g)
  createdb $dbname
  gunzip -c $file | sed 's/Library\/PostgreSQL\/9.0\/lib\/postgis-1.5/usr\/local\/Cellar\/postgresql\/9.1.3\/lib\/postgis-1.5/g' | psql $dbname
 done
	for file in ~/postgres_backups/*
	do
	dbname=$(basename $file \| sed s/\.gz//g)
	createdb $dbname
	gunzip -c $file \| sed 's/Library\/PostgreSQL\/9.0\/lib\/postgis-1.5/usr\/local\/Cellar\/postgresql\/9.1.3\/lib\/postgis-1.5/g' \| psql $dbname
	done