liquid_feedback_core
changeset 40:2b03946cb0c2 beta25
lf_export: Use pg_dump and psql instead of createdb to copy database
author | jbe |
---|---|
date | Mon Mar 08 18:46:38 2010 +0100 (2010-03-08) |
parents | 0e429def4e8d |
children | d0c3390ed42b |
files | lf_export |
line diff
1.1 --- a/lf_export Mon Mar 08 14:29:26 2010 +0100 1.2 +++ b/lf_export Mon Mar 08 18:46:38 2010 +0100 1.3 @@ -11,7 +11,8 @@ 1.4 echo "Dropping database \"$EXPORT_DBNAME\" if existent..." 1.5 dropdb "$EXPORT_DBNAME" 2> /dev/null 1.6 echo "Copying database \"$1\" to new database \"$EXPORT_DBNAME\"..." 1.7 -if createdb -T "$1" "$EXPORT_DBNAME" 1.8 +# TODO: use character encoding of original database 1.9 +if (createdb "$EXPORT_DBNAME" && pg_dump "$1" | psql -f - "$EXPORT_DBNAME" > /dev/null) 1.10 then 1.11 echo "Deleting private data in copied database..." 1.12 if psql -v ON_ERROR_STOP=1 -c 'SELECT delete_private_data()' "$EXPORT_DBNAME" > /dev/null