summaryrefslogtreecommitdiffstats
path: root/docs/en/rst
diff options
context:
space:
mode:
authorDylan William Hardison <dylan@hardison.net>2016-07-08 18:59:29 +0200
committerGitHub <noreply@github.com>2016-07-08 18:59:29 +0200
commit5880669daea07f078e2bd9deb6e1a0793f6a929f (patch)
treeb6fb7b30521c69af82f25626ad05f5d35643c8e7 /docs/en/rst
parentc0cf9b11fb4a21387126069ff8cd7e3400a8de39 (diff)
downloadbugzilla-5880669daea07f078e2bd9deb6e1a0793f6a929f.tar.gz
bugzilla-5880669daea07f078e2bd9deb6e1a0793f6a929f.tar.xz
Bug 542507 - [PostgreSQL] The db_user sometimes cannot connect to the "template1" database
Diffstat (limited to 'docs/en/rst')
-rw-r--r--docs/en/rst/installing/postgresql.rst14
1 files changed, 10 insertions, 4 deletions
diff --git a/docs/en/rst/installing/postgresql.rst b/docs/en/rst/installing/postgresql.rst
index 8e8c4a08b..10455488c 100644
--- a/docs/en/rst/installing/postgresql.rst
+++ b/docs/en/rst/installing/postgresql.rst
@@ -14,8 +14,8 @@ server is started when the machine boots.
.. _posgresql-add-user:
-Add a User
-==========
+Add a User and Create a DB
+==========================
You need to add a new user to PostgreSQL for the Bugzilla
application to use when accessing the database. The following instructions
@@ -29,12 +29,18 @@ then switch to being the postgres (Unix) user:
As the postgres user, you then need to create a new user:
-:command:`createuser -U postgres -dRSP bugs`
+:command:`createuser -U postgres -DRSP bugs`
When asked for a password, provide one and write it down for later reference.
The created user will not be a superuser (-S) and will not be able to create
-new users (-R). He will only have the ability to create databases (-d).
+new users (-R) or create databases (-D).
+
+Next we will create a database for bugzilla to use
+
+:command:`createdb -U postgress -O bugs bugs`
+
+This will create a database named `bugs` that is owned (-O) by the `bugs` user.
.. _postgresql-access: