# HG changeset patch
# User jbe
# Date 1268070398 -3600
# Node ID 2b03946cb0c2c556f4623de8ffccc1fbeb48f3c8
# Parent  0e429def4e8dac13bd0197cf87618631af42e32c
lf_export: Use pg_dump and psql instead of createdb to copy database

diff -r 0e429def4e8d -r 2b03946cb0c2 lf_export
--- a/lf_export	Mon Mar 08 14:29:26 2010 +0100
+++ b/lf_export	Mon Mar 08 18:46:38 2010 +0100
@@ -11,7 +11,8 @@
 echo "Dropping database \"$EXPORT_DBNAME\" if existent..."
 dropdb "$EXPORT_DBNAME" 2> /dev/null
 echo "Copying database \"$1\" to new database \"$EXPORT_DBNAME\"..."
-if createdb -T "$1" "$EXPORT_DBNAME"
+# TODO: use character encoding of original database
+if (createdb "$EXPORT_DBNAME" && pg_dump "$1" | psql -f - "$EXPORT_DBNAME" > /dev/null)
 then
   echo "Deleting private data in copied database..."
   if psql -v ON_ERROR_STOP=1 -c 'SELECT delete_private_data()' "$EXPORT_DBNAME" > /dev/null