diff options
author | Gareth Rees <gareth@mysociety.org> | 2014-05-14 15:03:07 +0100 |
---|---|---|
committer | Gareth Rees <gareth@mysociety.org> | 2014-05-14 15:03:07 +0100 |
commit | 8a31a6192302c1c23286f50c97c9c7c041c3a536 (patch) | |
tree | 78658c7283b53bc812e756eb3be73f1c418073d9 /installing/manual_install.md | |
parent | 5ab4263fce092a13a05ef40b2891c225b347a7d6 (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.md | 33 |
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 |