aboutsummaryrefslogtreecommitdiffstats
path: root/installing/manual_install.md
diff options
context:
space:
mode:
authorGareth Rees <gareth@mysociety.org>2014-05-14 15:03:07 +0100
committerGareth Rees <gareth@mysociety.org>2014-05-14 15:03:07 +0100
commit8a31a6192302c1c23286f50c97c9c7c041c3a536 (patch)
tree78658c7283b53bc812e756eb3be73f1c418073d9 /installing/manual_install.md
parent5ab4263fce092a13a05ef40b2891c225b347a7d6 (diff)
Shuffle Configure Database docs
Do all the postgres setup then configure database.yml
Diffstat (limited to 'installing/manual_install.md')
-rw-r--r--installing/manual_install.md33
1 files changed, 16 insertions, 17 deletions
diff --git a/installing/manual_install.md b/installing/manual_install.md
index c9f67936f..e6794881a 100644
--- a/installing/manual_install.md
+++ b/installing/manual_install.md
@@ -152,28 +152,12 @@ If you don't have postgres installed:
apt-get install postgresql postgresql-client
-Now you need to set up the database config file to contain the name, username
-and password of your postgres database.
-
-* copy `database.yml-example` to `database.yml` in `alaveteli/config`
-* edit it to point to your local postgresql database in the development
- and test sections and create the databases:
-
-Make sure that the user specified in `database.yml` exists, and has full
-permissions on these databases. As they need the ability to turn off
-constraints whilst running the tests they also need to be a superuser. If you
-don't want your database user to be a superuser, you can add this line
-to the test config in `database.yml` (as seen in `database.yml-example`)
-
- disable_constraints: false
-
-
Create a `foi` user from the command line, like this:
# su - postgres
$ createuser -s -P foi
-Then create a database:
+Then create the databases:
$ createdb -T template0 -E SQL_ASCII -O foi foi_production
$ createdb -T template0 -E SQL_ASCII -O foi foi_test
@@ -185,6 +169,21 @@ be valid UTF (for example, data originating from various broken email clients
that's not 8-bit clean), it's safer to be able to store *anything*, than reject
data at runtime.
+Now you need to set up the database config file to contain the name, username
+and password of your postgres database.
+
+* Copy `database.yml-example` to `database.yml` in `alaveteli/config`
+* Edit it to point to your local postgresql database in the development
+ and test sections.
+
+Make sure that the user specified in `database.yml` exists, and has full
+permissions on these databases. As they need the ability to turn off
+constraints whilst running the tests they also need to be a superuser. If you
+don't want your database user to be a superuser, you can add this line
+to the test config in `database.yml` (as seen in `database.yml-example`)
+
+ disable_constraints: false
+
## Configure email
You will need to set up an email server (MTA) to send and receive emails. Full