Confirmed users
90
edits
IT/Community/WG/Discourse/Setup: Difference between revisions
IT/Community/WG/Discourse/Setup (view source)
Revision as of 20:09, 7 December 2014
, 7 December 2014no edit summary
(add infra setup) |
No edit summary |
||
| Line 16: | Line 16: | ||
=== Create Database === | === Create Database === | ||
psql -h pgshared-db.mofostaging.net --user=root template1 | ubuntu@ec2instance:~$ psql -h pgshared-db.mofostaging.net --user=root template1 | ||
CREATE USER csa<app> WITH PASSWORD 'aStrongPasswordHere'; | template1> CREATE USER csa<app> WITH PASSWORD 'aStrongPasswordHere'; | ||
CREATE DATABASE csa<app>db; | template1> CREATE DATABASE csa<app>db; | ||
GRANT ALL PRIVILEGES ON DATABASE csa<app>db to csa<app>; | template1> GRANT ALL PRIVILEGES ON DATABASE csa<app>db to csa<app>; | ||
CREATE EXTENSION IF NOT EXISTS hstore; | template1> \q | ||
CREATE EXTENSION IF NOT EXISTS pg_trgm; | ubuntu@ec2instance:~$ psql -h pgshared-db.mofostaging.net --user=root csa<app>db | ||
template1> CREATE EXTENSION IF NOT EXISTS hstore; | |||
template1> CREATE EXTENSION IF NOT EXISTS pg_trgm; | |||
== Discourse set-up == | == Discourse set-up == | ||