Anonymous avatar Anonymous committed 2b03946

lf_export: Use pg_dump and psql instead of createdb to copy database

Comments (0)

Files changed (1)

 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
Tip: Filter by directory path e.g. /media app.js to search for public/media/app.js.
Tip: Use camelCasing e.g. ProjME to search for ProjectModifiedEvent.java.
Tip: Filter by extension type e.g. /repo .js to search for all .js files in the /repo directory.
Tip: Separate your search with spaces e.g. /ssh pom.xml to search for src/ssh/pom.xml.
Tip: Use ↑ and ↓ arrow keys to navigate and return to view the file.
Tip: You can also navigate files with Ctrl+j (next) and Ctrl+k (previous) and view the file with Ctrl+o.
Tip: You can also navigate files with Alt+j (next) and Alt+k (previous) and view the file with Alt+o.