diff options
| author | Dylan William Hardison <dylan@hardison.net> | 2016-07-08 18:59:29 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2016-07-08 18:59:29 +0200 |
| commit | 5880669daea07f078e2bd9deb6e1a0793f6a929f (patch) | |
| tree | b6fb7b30521c69af82f25626ad05f5d35643c8e7 /docs | |
| parent | c0cf9b11fb4a21387126069ff8cd7e3400a8de39 (diff) | |
| download | bugzilla-5880669daea07f078e2bd9deb6e1a0793f6a929f.tar.gz bugzilla-5880669daea07f078e2bd9deb6e1a0793f6a929f.tar.xz | |
Bug 542507 - [PostgreSQL] The db_user sometimes cannot connect to the "template1" database
Diffstat (limited to 'docs')
| -rw-r--r-- | docs/en/rst/installing/postgresql.rst | 14 |
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: |