helper script to run dump and extract errors

[pgsql-fix-value-too-long] / import-pgsql-dump.sh

diff --git a/import-pgsql-dump.sh b/import-pgsql-dump.sh
new file mode 100755 (executable)
index 0000000..f7b7dcf
--- /dev/null
+++ b/import-pgsql-dump.sh
@@ -0,0 +1,9 @@
+#!/bin/sh -xe
+
+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