liquid_feedback_core

annotate README @ 215:49d470425fc5

Added tag v2.0.2 for changeset 919d16c8e8e3
author jbe
date Fri Feb 17 18:27:38 2012 +0100 (2012-02-17)
parents fa394b8a0157
children 5ee7eed2f5b0
rev   line source
jbe@0 1
jbe@0 2 Setup the database:
jbe@0 3 $ createdb liquid_feedback
jbe@0 4 $ psql -v ON_ERROR_STOP=1 -f core.sql liquid_feedback
jbe@0 5
jbe@0 6 Optionally insert demo data:
jbe@0 7 $ psql -v ON_ERROR_STOP=1 -f demo.sql liquid_feedback
jbe@0 8
jbe@0 9 Compile lf_update binary:
jbe@0 10 $ make
jbe@0 11
jbe@202 12 Ensure that "lf_update dbname=liquid_feedback" is called regularly!
jbe@202 13
jbe@202 14 It is required that lf_update is executed regulary (i.e. every
jbe@202 15 5 minutes via cron) to update cached supporter counts, to change
jbe@202 16 the state of issues when neccessary, and to calculate the result
jbe@202 17 of votings. If you wish, copy the created lf_update file to
jbe@202 18 /usr/local/bin or a similar directory.
jbe@202 19
jbe@202 20 On successful run, lf_update will not produce any output
jbe@202 21 and exit with code 0.
jbe@0 22
jbe@0 23 NOTE: When writing to the database, some INSERTs must be executed
jbe@0 24 within the same transaction, e.g. issues can't exist without
jbe@0 25 an initiative and vice versa.
jbe@0 26
jbe@8 27 To create an export file, which is containing all but private data,
jbe@8 28 you may use the lf_export shell-script:
jbe@8 29 $ lf_export liquid_feedback export.sql.gz
jbe@8 30
jbe@0 31 To uninstall the software, delete the lf_update binary
jbe@0 32 and drop the database by entering the following command:
jbe@0 33 $ dropdb liquid_feedback
jbe@0 34
jbe@120 35 Updating is done using the update scripts in the update/ directory.
jbe@120 36 After updating it is recommended to recreate the schema as follows:
jbe@120 37 $ pg_dump --disable-triggers --data-only DATABASE_NAME > tmp.sql
jbe@120 38 $ dropdb DATABASE_NAME
jbe@120 39 $ createdb DATABASE_NAME
jbe@120 40 $ psql -v ON_ERROR_STOP=1 -f core.sql DATABASE_NAME
jbe@120 41 $ psql -v ON_ERROR_STOP=1 -f tmp.sql DATABASE_NAME
jbe@120 42 $ rm tmp.sql
jbe@120 43

Impressum / About Us