annotate README @ 176:b2d87fbb123b
Added constraint "eligible_at_first_rank_is_winner" to "initiative" table
author |
jbe |
date |
Wed Jun 08 14:03:16 2011 +0200 (2011-06-08) |
parents |
92fc60ed705d |
children |
fa394b8a0157 |
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@0
|
12 If you wish, copy the created lf_update file to /usr/local/bin or a
|
jbe@0
|
13 similar directory. Ensure that "lf_update dbname=liquid_feedback"
|
jbe@0
|
14 is called regularly. On successful run, lf_update will not produce
|
jbe@0
|
15 any output and exit with code 0.
|
jbe@0
|
16
|
jbe@0
|
17 NOTE: When writing to the database, some INSERTs must be executed
|
jbe@0
|
18 within the same transaction, e.g. issues can't exist without
|
jbe@0
|
19 an initiative and vice versa.
|
jbe@0
|
20
|
jbe@8
|
21 To create an export file, which is containing all but private data,
|
jbe@8
|
22 you may use the lf_export shell-script:
|
jbe@8
|
23 $ lf_export liquid_feedback export.sql.gz
|
jbe@8
|
24
|
jbe@0
|
25 To uninstall the software, delete the lf_update binary
|
jbe@0
|
26 and drop the database by entering the following command:
|
jbe@0
|
27 $ dropdb liquid_feedback
|
jbe@0
|
28
|
jbe@120
|
29 Updating is done using the update scripts in the update/ directory.
|
jbe@120
|
30 After updating it is recommended to recreate the schema as follows:
|
jbe@120
|
31 $ pg_dump --disable-triggers --data-only DATABASE_NAME > tmp.sql
|
jbe@120
|
32 $ dropdb DATABASE_NAME
|
jbe@120
|
33 $ createdb DATABASE_NAME
|
jbe@120
|
34 $ psql -v ON_ERROR_STOP=1 -f core.sql DATABASE_NAME
|
jbe@120
|
35 $ psql -v ON_ERROR_STOP=1 -f tmp.sql DATABASE_NAME
|
jbe@120
|
36 $ rm tmp.sql
|
jbe@120
|
37
|