From: Dobrica Pavlinusic Date: Tue, 22 Jan 2013 19:02:34 +0000 (+0100) Subject: restart import if last run produced errors X-Git-Url: http://git.rot13.org/?p=pgsql-fix-value-too-long;a=commitdiff_plain;h=73559514f564de7166dbd2b45e350e04731d96dd;ds=sidebyside restart import if last run produced errors --- diff --git a/import-pgsql-dump.sh b/import-pgsql-dump.sh index f7b7dcf..5c97175 100755 --- a/import-pgsql-dump.sh +++ b/import-pgsql-dump.sh @@ -1,9 +1,12 @@ #!/bin/sh -xe +echo started on `date` touch errors ( psql -l | grep ibatisti | awk '{ print $1 }' | xargs -i dropdb {} ./pgsql-fix-value-too-long.pl errors $1 | \ ( psql --echo-queries template1 2>&1 ) 2>&1 ) | tee log -grep -A 1 'value too long' log | tee -a errors +grep -A 1 'value too long' log | tee -a errors +mv log log.last +grep 'value too long' log.last && exec $0 $*