aboutsummaryrefslogtreecommitdiffstats
path: root/docs/installing/macos.md
diff options
context:
space:
mode:
authorDave Whiteland <dave@mysociety.org>2014-07-03 14:22:58 +0100
committerDave Whiteland <dave@mysociety.org>2014-07-03 14:22:58 +0100
commit5c7ca961e3b647ead4f1aa6722caad780cfe22f2 (patch)
tree92164dcd1aa356166c986975da2bf9935f53db6e /docs/installing/macos.md
parent230b2fee5ddf656344bfac53dea7f2a10c6c0a4b (diff)
parent359582ff3d981680cc6a9997e1a96381d7341866 (diff)
Merge branch 'gh-pages' into gh-pages-i18n
Diffstat (limited to 'docs/installing/macos.md')
-rw-r--r--docs/installing/macos.md32
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