# HG changeset patch # User jbe # Date 1337115574 -7200 # Node ID 5ee7eed2f5b09e6a45fda0ede32a7af96f5f6cd1 # Parent 7b8966b801e53ffdc7ddf8dec1343997a0a87200 Updated README file, noting that data import after updating has to be done as database superuser diff -r 7b8966b801e5 -r 5ee7eed2f5b0 README --- a/README Tue May 15 12:46:30 2012 +0200 +++ b/README Tue May 15 22:59:34 2012 +0200 @@ -33,11 +33,14 @@ $ dropdb liquid_feedback Updating is done using the update scripts in the update/ directory. -After updating it is recommended to recreate the schema as follows: +After updating it is recommended to recreate the schema as follows +(assuming the database superuser is named "postgres"): $ pg_dump --disable-triggers --data-only DATABASE_NAME > tmp.sql $ dropdb DATABASE_NAME $ createdb DATABASE_NAME $ psql -v ON_ERROR_STOP=1 -f core.sql DATABASE_NAME +$ su postgres # (execute following command as database superuser) $ psql -v ON_ERROR_STOP=1 -f tmp.sql DATABASE_NAME +$ exit # leave "su" command $ rm tmp.sql