<!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>PostgreSQL/psycopg Backend &mdash; Roundup v1.4 documentation</title> <link rel="stylesheet" href="_static/style.css" type="text/css" /> <link rel="stylesheet" href="_static/pygments.css" type="text/css" /> <script type="text/javascript"> var DOCUMENTATION_OPTIONS = { URL_ROOT: '#', VERSION: '1.4', COLLAPSE_MODINDEX: false, FILE_SUFFIX: '.html' }; </script> <script type="text/javascript" src="_static/jquery.js"></script> <script type="text/javascript" src="_static/doctools.js"></script> <link rel="index" title="Index" href="genindex.html" /> <link rel="search" title="Search" href="search.html" /> <link rel="top" title="Roundup v1.4 documentation" href="index.html" /> </head> <body> <div class="header"><h1>Roundup</h1> <div id="searchbox" style="display: none"> <form class="search" action="search.html" method="get"> <input type="text" name="q" size="18" /> <input type="submit" value="Search" /> <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 class="navigation"> <div class="menu"> <h3><a href="index.html">Table Of Contents</a></h3> <ul> <li><a class="reference external" href="#">PostgreSQL/psycopg Backend</a><ul> <li><a class="reference external" href="#prerequisites">Prerequisites</a></li> <li><a class="reference external" href="#running-the-postgresql-unit-tests">Running the PostgreSQL unit tests</a></li> <li><a class="reference external" href="#credit">Credit</a></li> </ul> </li> </ul> <h3>This Page</h3> <ul class="this-page-menu"> <li><a href="_sources/postgresql.txt" rel="nofollow">Show Source</a></li> </ul> <div id="searchbox" style="display: none"> <h3>Quick search</h3> <form class="search" action="search.html" method="get"> <input type="text" name="q" size="18" /> <input type="submit" value="Go" /> <input type="hidden" name="check_keywords" value="yes" /> <input type="hidden" name="area" value="default" /> </form> <p style="font-size: 90%">Enter search terms or a module, class or function name.</p> </div> <script type="text/javascript">$('#searchbox').show(0);</script> </div> </div> <div class="content"> <div class="related related-top"> <ul> <li class="right" style="margin-right: 10px"> <a href="genindex.html" title="General Index" accesskey="I">index</a></li> <li><a href="index.html">Roundup v1.4 documentation</a></li> </ul> </div> <div class="section" id="postgresql-psycopg-backend"> <h1>PostgreSQL/psycopg Backend</h1> <p>This are notes about PostqreSQL backend based on the psycopg adapter for Roundup issue tracker.</p> <div class="section" id="prerequisites"> <h2>Prerequisites</h2> <p>To use PostgreSQL as backend for storing roundup data, you should additionally install:</p> <ol class="arabic"> <li><p class="first">PostgreSQL 7.x - <a class="reference external" href="http://www.postgresql.org/">http://www.postgresql.org/</a></p> </li> <li><p class="first">The psycopg python interface to PostgreSQL:</p> <blockquote> <p><a class="reference external" href="http://initd.org/software/initd/psycopg">http://initd.org/software/initd/psycopg</a></p> </blockquote> <p>It is recommended that you use at least version 1.1.21</p> </li> </ol> <p>Some advice on setting up the postgresql backend may be found at:</p> <blockquote> <a class="reference external" href="http://www.magma.com.ni/wiki/index.cgi?TipsRoundupPostgres">http://www.magma.com.ni/wiki/index.cgi?TipsRoundupPostgres</a></blockquote> </div> <div class="section" id="running-the-postgresql-unit-tests"> <h2>Running the PostgreSQL unit tests</h2> <p>The user that you’re running the tests as will need to be able to access the postgresql database on the local machine and create and drop databases. Edit the <tt class="docutils literal"><span class="pre">test/test_postgresql.py</span></tt> database connection info if you wish to test against a different database.</p> <p>The test database will be called “rounduptest”.</p> </div> <div class="section" id="credit"> <h2>Credit</h2> <p>The postgresql backend was originally submitted by Federico Di Gregorio <<a class="reference external" href="mailto:fog%40initd.org">fog<span>@</span>initd<span>.</span>org</a>></p> </div> </div> <div class="related related-bottom"> <ul> <li class="right" style="margin-right: 10px"> <a href="genindex.html" title="General Index" accesskey="I">index</a></li> <li><a href="index.html">Roundup v1.4 documentation</a></li> </ul> </div> </div> <div class="footer"> © Copyright 2009, Richard Jones. <p class="source"><a href="_sources/postgresql.txt" rel="nofollow">source</a></p> </div> </body> </html>