liquid_feedback_core
diff README @ 251:5ee7eed2f5b0
Updated README file, noting that data import after updating has to be done as database superuser
author | jbe |
---|---|
date | Tue May 15 22:59:34 2012 +0200 (2012-05-15) |
parents | fa394b8a0157 |
children | 9ef1765082a7 |
line diff
1.1 --- a/README Tue May 15 12:46:30 2012 +0200 1.2 +++ b/README Tue May 15 22:59:34 2012 +0200 1.3 @@ -33,11 +33,14 @@ 1.4 $ dropdb liquid_feedback 1.5 1.6 Updating is done using the update scripts in the update/ directory. 1.7 -After updating it is recommended to recreate the schema as follows: 1.8 +After updating it is recommended to recreate the schema as follows 1.9 +(assuming the database superuser is named "postgres"): 1.10 $ pg_dump --disable-triggers --data-only DATABASE_NAME > tmp.sql 1.11 $ dropdb DATABASE_NAME 1.12 $ createdb DATABASE_NAME 1.13 $ psql -v ON_ERROR_STOP=1 -f core.sql DATABASE_NAME 1.14 +$ su postgres # (execute following command as database superuser) 1.15 $ psql -v ON_ERROR_STOP=1 -f tmp.sql DATABASE_NAME 1.16 +$ exit # leave "su" command 1.17 $ rm tmp.sql 1.18