diff options
author | Gervase Markham <gerv@gerv.net> | 2014-12-05 22:52:48 +0100 |
---|---|---|
committer | Dylan William Hardison <dylan@hardison.net> | 2014-12-05 23:01:30 +0100 |
commit | d41a0a76217ebbfd18807128e8bd552d5276e87a (patch) | |
tree | d99e4d9f43a2e0ffb693da447d2061e8985680a6 /docs/en/rst/installing/postgresql.rst | |
parent | f9e9cf2597bb5e2780a16c0191400998a595fa2b (diff) | |
download | bugzilla-d41a0a76217ebbfd18807128e8bd552d5276e87a.tar.gz bugzilla-d41a0a76217ebbfd18807128e8bd552d5276e87a.tar.xz |
Bug 1067416 - reorganize and update Bugzilla docs
Diffstat (limited to 'docs/en/rst/installing/postgresql.rst')
-rw-r--r-- | docs/en/rst/installing/postgresql.rst | 58 |
1 files changed, 58 insertions, 0 deletions
diff --git a/docs/en/rst/installing/postgresql.rst b/docs/en/rst/installing/postgresql.rst new file mode 100644 index 000000000..1d0ec1d49 --- /dev/null +++ b/docs/en/rst/installing/postgresql.rst @@ -0,0 +1,58 @@ +.. _postgresql: + +PostgreSQL +########## + +Test which version of PostgreSQL you have installed with: + +:command:`psql -V` + +You need PostgreSQL version 8.03.0000 or higher. + +If you install PostgreSQL manually rather than from a package, make sure the +server is started when the machine boots. + +.. _posgresql-add-user: + +Add a User +========== + +You need to add a new user to PostgreSQL for the Bugzilla +application to use when accessing the database. The following instructions +assume the defaults in :file:`localconfig`; if you +changed those, you need to modify the commands appropriately. + +On most systems, to create a user in PostgreSQL, login as the root user, and +then switch to being the postgres (Unix) user: + +:command:`su - postgres` + +As the postgres user, you then need to create a new user: + +: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). + +.. _postgresql-access: + +Permit Access +============= + +Edit the file :file:`pg_hba.conf` which is +usually located in :file:`/var/lib/pgsql/data/`. In this file, +you will need to add a new line to it as follows: + +:: + + host all bugs 127.0.0.1 255.255.255.255 md5 + +This means that for TCP/IP (host) connections, allow connections from +'127.0.0.1' to 'all' databases on this server from the 'bugs' user, and use +password authentication ('md5') for that user. + +Now, you will need to stop and start PostgreSQL fully. (Do not use any +'restart' command, due to the possibility of a change to +:file:`postgresql.conf`.) |