jbe@8: #!/bin/sh
jbe@8: 
jbe@8: if [ -z "$1" -o -z "$2" ]; then
jbe@8:   echo "Usage: $0 <dbname> <filename>.sql.gz"
jbe@8:   exit 1
jbe@8: fi
jbe@8: 
jbe@8: EXPORT_DBNAME=liquid_feedback_autoexport
jbe@8: retval=0
jbe@8: 
jbe@8: echo "Dropping database \"$EXPORT_DBNAME\" if existent..."
jbe@8: dropdb "$EXPORT_DBNAME" 2> /dev/null
jbe@8: echo "Copying database \"$1\" to new database \"$EXPORT_DBNAME\"..."
jbe@40: # TODO: use character encoding of original database
jbe@40: if (createdb "$EXPORT_DBNAME" && pg_dump "$1" | psql -f - "$EXPORT_DBNAME" > /dev/null)
jbe@8: then
jbe@8:   echo "Deleting private data in copied database..."
jbe@9:   if psql -v ON_ERROR_STOP=1 -c 'SELECT delete_private_data()' "$EXPORT_DBNAME" > /dev/null
jbe@8:   then
jbe@8:     echo "Dumping and compressing copied database to \"$2\"..."
jbe@8:     if pg_dump --no-owner --no-privileges "$EXPORT_DBNAME" | gzip -9 > "$2"
jbe@8:     then
jbe@11:       true
jbe@8:     else
jbe@8:       retval=4
jbe@8:     fi
jbe@8:   else
jbe@8:     retval=3
jbe@8:   fi
jbe@8: else
jbe@8:   retval=2
jbe@8: fi
jbe@8: echo "Dropping database \"$EXPORT_DBNAME\"..."
jbe@8: dropdb "$EXPORT_DBNAME"
jbe@8: echo "DONE."
jbe@8: exit $retval