# HG changeset patch # User jbe # Date 1299503753 -3600 # Node ID 92fc60ed705d233624d3b955aecf5f182c0be6a7 # Parent d6a145a5c9d3c9661d562d766aa94f997338bb37 Included update instructions in README file diff -r d6a145a5c9d3 -r 92fc60ed705d README --- a/README Mon Mar 07 14:10:25 2011 +0100 +++ b/README Mon Mar 07 14:15:53 2011 +0100 @@ -26,3 +26,12 @@ and drop the database by entering the following command: $ 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: +$ 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 +$ psql -v ON_ERROR_STOP=1 -f tmp.sql DATABASE_NAME +$ rm tmp.sql +