<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>3.6.2. PostgreSQL — Bugzilla 5.0.4 documentation</title> <link rel="stylesheet" href="../_static/bugzilla.css" type="text/css" /> <link rel="stylesheet" href="../_static/pygments.css" type="text/css" /> <script type="text/javascript"> var DOCUMENTATION_OPTIONS = { URL_ROOT: '../', VERSION: '5.0.4', COLLAPSE_INDEX: false, FILE_SUFFIX: '.html', HAS_SOURCE: true, SOURCELINK_SUFFIX: '.txt' }; </script> <script type="text/javascript" src="../_static/jquery.js"></script> <script type="text/javascript" src="../_static/underscore.js"></script> <script type="text/javascript" src="../_static/doctools.js"></script> <link rel="shortcut icon" href="../_static/favicon.ico"/> <link rel="search" title="Search" href="../search.html" /> <link rel="next" title="3.6.3. Oracle" href="oracle.html" /> <link rel="prev" title="3.6.1. MySQL" href="mysql.html" /> </head> <body> <div class="related" role="navigation" aria-label="related navigation"> <h3>Navigation</h3> <ul> <li class="right" style="margin-right: 10px"> <a href="oracle.html" title="3.6.3. Oracle" accesskey="N">next</a></li> <li class="right" > <a href="mysql.html" title="3.6.1. MySQL" accesskey="P">previous</a> |</li> <li class="nav-item nav-item-0"><a href="../index.html">Bugzilla 5.0.4 documentation</a> »</li> <li class="nav-item nav-item-1"><a href="index.html" >3. Installation and Maintenance Guide</a> »</li> <li class="nav-item nav-item-2"><a href="db_server.html" accesskey="U">3.6. Database Server</a> »</li> </ul> </div> <div class="document"> <div class="documentwrapper"> <div class="bodywrapper"> <div class="body" role="main"> <div class="section" id="postgresql"> <span id="id1"></span><h1>3.6.2. PostgreSQL<a class="headerlink" href="#postgresql" title="Permalink to this headline">¶</a></h1> <p>Test which version of PostgreSQL you have installed with:</p> <p><strong class="command">psql -V</strong></p> <p>You need PostgreSQL version 8.03.0000 or higher.</p> <p>If you install PostgreSQL manually rather than from a package, make sure the server is started when the machine boots.</p> <div class="section" id="add-a-user"> <span id="posgresql-add-user"></span><h2>3.6.2.1. Add a User<a class="headerlink" href="#add-a-user" title="Permalink to this headline">¶</a></h2> <p>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 <code class="file docutils literal"><span class="pre">localconfig</span></code>; if you changed those, you need to modify the commands appropriately.</p> <p>On most systems, to create a user in PostgreSQL, login as the root user, and then switch to being the postgres (Unix) user:</p> <p><strong class="command">su - postgres</strong></p> <p>As the postgres user, you then need to create a new user:</p> <p><strong class="command">createuser -U postgres -dRSP bugs</strong></p> <p>When asked for a password, provide one and write it down for later reference.</p> <p>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).</p> </div> <div class="section" id="permit-access"> <span id="postgresql-access"></span><h2>3.6.2.2. Permit Access<a class="headerlink" href="#permit-access" title="Permalink to this headline">¶</a></h2> <p>Edit the file <code class="file docutils literal"><span class="pre">pg_hba.conf</span></code> which is usually located in <code class="file docutils literal"><span class="pre">/var/lib/pgsql/data/</span></code>. In this file, you will need to add a new line to it as follows:</p> <div class="highlight-default"><div class="highlight"><pre><span></span><span class="n">host</span> <span class="nb">all</span> <span class="n">bugs</span> <span class="mf">127.0</span><span class="o">.</span><span class="mf">0.1</span> <span class="mf">255.255</span><span class="o">.</span><span class="mf">255.255</span> <span class="n">md5</span> </pre></div> </div> <p>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.</p> <p>Now, you will need to stop and start PostgreSQL fully. (Do not use any 'restart' command, due to the possibility of a change to <code class="file docutils literal"><span class="pre">postgresql.conf</span></code>.)</p> <hr class="docutils" /> <p>This documentation undoubtedly has bugs; if you find some, please file them <a class="reference external" href="https://bugzilla.mozilla.org/enter_bug.cgi?product=Bugzilla&component=Documentation">here</a>.</p> </div> </div> </div> </div> </div> <div class="sphinxsidebar" role="navigation" aria-label="main navigation"> <div class="sphinxsidebarwrapper"> <p class="logo"><a href="../index.html"> <img class="logo" src="../_static/bugzilla.png" alt="Logo"/> </a></p> <h3><a href="../index.html">Table Of Contents</a></h3> <ul> <li><a class="reference internal" href="#">3.6.2. PostgreSQL</a><ul> <li><a class="reference internal" href="#add-a-user">3.6.2.1. Add a User</a></li> <li><a class="reference internal" href="#permit-access">3.6.2.2. Permit Access</a></li> </ul> </li> </ul> <h4>Previous topic</h4> <p class="topless"><a href="mysql.html" title="previous chapter">3.6.1. MySQL</a></p> <h4>Next topic</h4> <p class="topless"><a href="oracle.html" title="next chapter">3.6.3. Oracle</a></p> <div id="searchbox" style="display: none" role="search"> <h3>Quick search</h3> <form class="search" action="../search.html" method="get"> <div><input type="text" name="q" /></div> <div><input type="submit" value="Go" /></div> <input type="hidden" name="check_keywords" value="yes" /> <input type="hidden" name="area" value="default" /> </form> </div> <script type="text/javascript">$('#searchbox').show(0);</script> </div> </div> <div class="clearer"></div> </div> <div class="related" role="navigation" aria-label="related navigation"> <h3>Navigation</h3> <ul> <li class="right" style="margin-right: 10px"> <a href="oracle.html" title="3.6.3. Oracle" >next</a></li> <li class="right" > <a href="mysql.html" title="3.6.1. MySQL" >previous</a> |</li> <li class="nav-item nav-item-0"><a href="../index.html">Bugzilla 5.0.4 documentation</a> »</li> <li class="nav-item nav-item-1"><a href="index.html" >3. Installation and Maintenance Guide</a> »</li> <li class="nav-item nav-item-2"><a href="db_server.html" >3.6. Database Server</a> »</li> </ul> </div> <div class="footer" role="contentinfo"> Created using <a href="http://sphinx-doc.org/">Sphinx</a> 1.6.6. </div> </body> </html>