Mercurial > p > roundup > code
view doc/postgresql.txt @ 7268:91125d474c1e
doc updates, normalize roundup => Roundup, add links, typo fixes
In Tracker in a Nutshell section
Document interfaces.py in table
Add links for auditors/reactors to detectors section in table
Add links for actions in table
Also mark optional components
Change roundup to canonical Roundup.
Fix unordered lists that were indented causing a list inside a
blockquote. UL lists are not unindented.
Move internal hyperlink references above the section heading they
refer to. Links were jumping after the heading which disorients the
user.
Change reference to never deleting 'users' class to be 'user' class.
fix typos
Remove uneeded trailing whitespace.
| author | John Rouillard <rouilj@ieee.org> |
|---|---|
| date | Mon, 24 Apr 2023 00:21:25 -0400 |
| parents | a0a100453eb9 |
| children | b21ebabeb2ef |
line wrap: on
line source
.. index:: postgres; deployment notes ========================== PostgreSQL/psycopg Backend ========================== This are notes about PostqreSQL backend based on the psycopg adapter for Roundup issue tracker. Prerequisites ============= To use PostgreSQL as backend for storing roundup data, you should additionally install: 1. PostgreSQL_ 8.x or higher 2. The psycopg_ python interface to PostgreSQL_ Note that you currently need at least version 2.8 of psycopg_ -- the postgresql backend will work with 2.7 but if you're using the native postgresql indexer you need at least 2.8. Also if you want to run the tests, these also need 2.8. If your distribution has an older version we suggest that you install into a python virtual environment. .. _psycopg: https://www.psycopg.org/ .. _PostgreSQL: https://www.postgresql.org/ Running the PostgreSQL unit tests ================================= 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. See the config values in 'test/db_test_base.py' about which database connection, name and user will be used. Credit ====== The postgresql backend was originally submitted by Federico Di Gregorio <fog@initd.org>