#! /bin/sh ODDB_HOME='/home/masa/ywesee/de.oddb.org' yyyy=`date -d '1 days ago' +"%Y"` mm=`date -d '1 days ago' +"%m"` dd=`date -d '1 days ago' +"%d"` m=(dummy January February March April May June July August September October November December) nm=`expr $mm + 0` sudo -u postgres dropdb oddb sudo -u postgres createdb -E UTF8 -T template0 oddb cd $ODDB_HOME mkdir data/sql scp ywesee@server:/var/backup/thinpower/db/postgresql/${m[nm]}-$yyyy/$yyyy-$mm-$dd/22\:00-postgresql_database-oddb-backup.gz data/sql/oddb.$yyyy$mm$dd.sql.gz cd data/sql zcat oddb.$yyyy$mm$dd.sql.gz | psql -U postgres oddb