| #!/bin/sh |
| |
| # This script assumes the Gerrit1 import has already been |
| # renamed to 'gerrit1' schema: |
| # |
| # psql -c 'ALTER SCHEMA public RENAME TO gerrit1' $src |
| # |
| |
| src=android_codereview |
| tmp=safedump |
| N="N.$$.sql" |
| |
| dropdb $tmp |
| createdb -E UTF-8 $tmp && |
| pg_dump -O -Fc $src >$N && |
| pg_restore -d $tmp $N && |
| psql -c 'UPDATE gerrit1.accounts SET |
| mailing_address = NULL |
| ,mailing_address_country = NULL |
| ,phone_number = NULL |
| ,fax_number = NULL |
| ,cla_comments = NULL' $tmp && |
| pg_dump -O -Fc $tmp | bzip2 -9 >gerrit1.dump.bz2 |
| dropdb $tmp |
| rm -f $N |
