view doc/postgresql.txt @ 5120:722394a48d7b

issue2550831: Make the classic template query.edit page work. R David Murray had a number of fixes. At least some of the fixes were already present in the devel and responsive templates. I touched up the html a bit and did what I hope aresome improvement for performance by shoving criteria into the filter rather than looping over all issues and filtering at the tal level. Also used R David's method to add a restore feature and work around an issue where a retired (deleted) query could still be in the active list. But because it was retired there was no way to manipulate it.
author John Rouillard <rouilj@ieee.org>
date Sun, 03 Jul 2016 12:23:36 -0400
parents 76b71c9bd50d
children e48b039b0ec0
line wrap: on
line source

==========================
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 - http://www.postgresql.org/

2. The psycopg python interface to PostgreSQL:

     http://initd.org/software/initd/psycopg


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>


Roundup Issue Tracker: http://roundup-tracker.org/