1 #!/bin/sh

2

3 if [ -z "$1" -o -z "$2" ]; then

4 echo "Usage: $0 <dbname> <filename>.sql.gz"

5 exit 1

6 fi

7

8 EXPORT_DBNAME=liquid_feedback_autoexport

9 retval=0

10

11 echo "Dropping database \"$EXPORT_DBNAME\" if existent..."

12 dropdb "$EXPORT_DBNAME" 2> /dev/null

13 echo "Copying database \"$1\" to new database \"$EXPORT_DBNAME\"..."

14 if createdb -T "$1" "$EXPORT_DBNAME"

15 then

16 echo "Deleting private data in copied database..."

17 if psql -v ON_ERROR_STOP=1 -c 'SELECT delete_private_data()' "$EXPORT_DBNAME" > /dev/null

18 then

19 echo "Dumping and compressing copied database to \"$2\"..."

20 if pg_dump --no-owner --no-privileges "$EXPORT_DBNAME" | gzip -9 > "$2"

21 then

22 true

23 else

24 retval=4

25 fi

26 else

27 retval=3

28 fi

29 else

30 retval=2

31 fi

32 echo "Dropping database \"$EXPORT_DBNAME\"..."

33 dropdb "$EXPORT_DBNAME"

34 echo "DONE."

35 exit $retval