diff options
author | Dave Whiteland <dave@mysociety.org> | 2014-07-03 14:22:58 +0100 |
---|---|---|
committer | Dave Whiteland <dave@mysociety.org> | 2014-07-03 14:22:58 +0100 |
commit | 5c7ca961e3b647ead4f1aa6722caad780cfe22f2 (patch) | |
tree | 92164dcd1aa356166c986975da2bf9935f53db6e /docs/installing/macos.md | |
parent | 230b2fee5ddf656344bfac53dea7f2a10c6c0a4b (diff) | |
parent | 359582ff3d981680cc6a9997e1a96381d7341866 (diff) |
Merge branch 'gh-pages' into gh-pages-i18n
Diffstat (limited to 'docs/installing/macos.md')
-rw-r--r-- | docs/installing/macos.md | 32 |
1 files changed, 21 insertions, 11 deletions
diff --git a/docs/installing/macos.md b/docs/installing/macos.md index c46bdf4ba..e93ea452f 100644 --- a/docs/installing/macos.md +++ b/docs/installing/macos.md @@ -88,17 +88,27 @@ The following is mostly from [the manual installation process]({{ site.baseurl}} ### Configure database -Creates Alaveteli databases and an `foi` user with password `foi`. - - echo "CREATE DATABASE foi_development encoding = 'UTF8'; - CREATE DATABASE foi_test encoding = 'UTF8'; - CREATE USER foi WITH CREATEUSER; - ALTER USER foi WITH PASSWORD 'foi'; - ALTER USER foi WITH CREATEDB; - GRANT ALL PRIVILEGES ON DATABASE foi_development TO foi; - GRANT ALL PRIVILEGES ON DATABASE foi_test TO foi; - ALTER DATABASE foi_development OWNER TO foi; - ALTER DATABASE foi_test OWNER TO foi;" | psql -h localhost template1 +Create a database for your Mac user as homebrew doesn't create one by default: + + createdb + +Create a `foi` user from the command line, like this: + + createuser -s -P foi + +_Note:_ Leaving the password blank will cause great confusion if you're new to +PostgreSQL. + +We'll create a template for our Alaveteli databases: + + createdb -T template0 -E UTF-8 template_utf8 + echo "update pg_database set datistemplate=true where datname='template_utf8';" | psql + +Then create the databases: + + createdb -T template_utf8 -O foi alaveteli_production + createdb -T template_utf8 -O foi alaveteli_test + createdb -T template_utf8 -O foi alaveteli_development ### Clone Alaveteli |