view README @ 252:878718ffa8f7

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

Impressum / About Us