http://hg.code.sf.net:8000/p/roundup/code/atom-log/tip/doc/postgresql.txt 2024-05-13T13:32:02-04:00 http://hg.code.sf.net:8000/p/roundup/code/#changeset-32ead43b829920d5779dd868292ac31051dbeb21 John Rouillard rouilj@ieee.org 2024-05-13T13:32:02-04:00 2024-05-13T13:32:02-04:00

changeset	32ead43b8299
branch
bookmark
tag
user	John Rouillard <rouilj@ieee.org>
description	docs: postgres user; wsgi default mode update; diff for task.index.html Update docs for creating postgresql roundup user for database and schema cases. Reword wsgi performance improvement disabling doc and add request for email if it needs to be disabled. Add link to diff for changes to task.index.html.
files

http://hg.code.sf.net:8000/p/roundup/code/#changeset-3071db43bfb6d957b2dab43ae0f9df0e98f86002 John Rouillard rouilj@ieee.org 2023-12-27T22:52:14-05:00 2023-12-27T22:52:14-05:00

changeset	3071db43bfb6
branch
bookmark
tag
user	John Rouillard <rouilj@ieee.org>
description	feat: issue2550852 - support using a specified PostgreSQL db schema Finally after 7 years this is closed. roundup/backends/back_postgresql.py: Support use of schema when specified in RDBMS_NAME. Stuart McGraws code is finally merged 8-). test/test_postgresql.py, test/conftest.py: Run all postgresql tests in the schema db as well. Also make sure that db_nuke raises an error when trying to delete the schema test database. Conftest defines pg_schema mark that can be used to exclude schema tests with pytest -m "not pg_schema". roundup/configuration.py: change doc on RDBMS_NAME to include db.schema form. .travis.yml, .github/workflows/ci-test.yml: create schema test db; add user for testing with schema; grant new user create privs for schema. doc/installation.txt: Reference to roundup-admin init deleting schema added. doc/mysql.txt doc/postgresql.txt: New documentation on psql/mysql commands to set up a production db. doc/upgrading.txt: mention schema support, also document service setting for selecting connection from pg_service.conf. doc/reference.txt: update config.ini documentation for RDBMS_NAME.
files

http://hg.code.sf.net:8000/p/roundup/code/#changeset-b21ebabeb2ef4484c00285974f85e9589482a7b8 John Rouillard rouilj@ieee.org 2023-05-25T15:11:04-04:00 2023-05-25T15:11:04-04:00

changeset	b21ebabeb2ef
branch
bookmark
tag
user	John Rouillard <rouilj@ieee.org>
description	Add warning rounduptest user: pg;mysql; add db account creation pg
files

http://hg.code.sf.net:8000/p/roundup/code/#changeset-a0a100453eb9c8ee053ea1b41b00da0f53957d6a Ralf Schlatterbeck rsc@runtux.com 2022-05-03T17:20:23+02:00 2022-05-03T17:20:23+02:00

changeset	a0a100453eb9
branch
bookmark
tag
user	Ralf Schlatterbeck <rsc@runtux.com>
description	Document minimum psycopg version Suggest to use a virtual environment if distribution has an older version. See issue2551201.
files

http://hg.code.sf.net:8000/p/roundup/code/#changeset-ba82fb74f8064525a0a6c46bfda78d7404b75aec John Rouillard rouilj@ieee.org 2020-09-08T23:30:21-04:00 2020-09-08T23:30:21-04:00

changeset	ba82fb74f806
branch
bookmark
tag
user	John Rouillard <rouilj@ieee.org>
description	Update psycopg link to: https://www.psycopg.org/
files

http://hg.code.sf.net:8000/p/roundup/code/#changeset-81ae33038ec58bd7a2c6f846ee04941a8aa642af John Rouillard rouilj@ieee.org 2020-05-13T13:01:08-04:00 2020-05-13T13:01:08-04:00

changeset	81ae33038ec5
branch
bookmark
tag
user	John Rouillard <rouilj@ieee.org>
description	more index entries.
files

http://hg.code.sf.net:8000/p/roundup/code/#changeset-c2fd254c9257f513a0de7446e549487ed4d51fe3 John Rouillard rouilj@ieee.org 2020-05-13T00:40:14-04:00 2020-05-13T00:40:14-04:00

changeset	c2fd254c9257
branch
bookmark
tag
user	John Rouillard <rouilj@ieee.org>
description	Doc updates/indexing. doc/admin_guide.txt, doc/customizing.txt, doc/features.txt, doc/installation.txt, doc/mysql.txt, doc/postgresql.txt: adding index entries doc/customizing.txt: reference schema changes later in document in addition to wiki. website/www/contents.txt: make wiki url https:.... Remove indices/tables as they don't show up in web interface. Put docs/announcement.txt into hidden toctree to silence warning from sphinx. Announcement.txt is referenced from index.txt so can't silence by adding to conf.py exclude_patern. website/www/index.txt: mention security and other improvements in jinja2 templates. website/www/conf.py: get rid of all warning by using exclude_patterns to ignore docs that aren't included. Remove exclude_trees using exclude_pattern instead. Make html_add_permalinks value acceptable so no warning reported. website/www/_static/style.css, website/www/_templtes/layout.html: add prev/next/index links for all doc pages.
files

http://hg.code.sf.net:8000/p/roundup/code/#changeset-e48b039b0ec030a3e9dd3b9568fe3ed844e1945f John Rouillard rouilj@ieee.org 2019-06-01T21:39:17-04:00 2019-06-01T21:39:17-04:00

changeset	e48b039b0ec0
branch
bookmark
tag
user	John Rouillard <rouilj@ieee.org>
description	issue2550966: fix suboptimal links in docs. I think I got the majority of them. Some links still don't resolve because they are gone and there is no replacement afaict. Also the check is picking up example links like: https://.../rest and http://localhost:8017/... which should not be checked but are.
files

http://hg.code.sf.net:8000/p/roundup/code/#changeset-76b71c9bd50db0911a70e2bc043c05b8eb203f6c Bernhard Reiter bernhard@intevation.de 2013-01-04T21:17:17+01:00 2013-01-04T21:17:17+01:00

changeset	76b71c9bd50d
branch
bookmark
tag
user	Bernhard Reiter <bernhard@intevation.de>
description	Updated recommended version infos for psycopg and PostgreSQL.
files

http://hg.code.sf.net:8000/p/roundup/code/#changeset-6a32a2fb95b41cc28006b12aa27a606ba87aa60b Bernhard Reiter Bernhard.Reiter@intevation.de 2011-07-01T14:11:06+00:00 2011-07-01T14:11:06+00:00

changeset	6a32a2fb95b4
branch
bookmark
tag
user	Bernhard Reiter <Bernhard.Reiter@intevation.de>
description	Docs update for mysql and postgresl: Mentioned test/db_test_base.py because that is the place where the default database parameters comes from.
files

http://hg.code.sf.net:8000/p/roundup/code/#changeset-7551dd0b7cbbc88188a6d5631dfc134c801434e2 Bernhard Reiter Bernhard.Reiter@intevation.de 2011-07-01T13:53:37+00:00 2011-07-01T13:53:37+00:00

changeset	7551dd0b7cbb
branch
bookmark
tag
user	Bernhard Reiter <Bernhard.Reiter@intevation.de>
description	www.magma.com.ni/wiki/index.cgi?TipsRoundupPostgres does not exist anymore... ...so I've removed the link.
files

http://hg.code.sf.net:8000/p/roundup/code/#changeset-8304a1c1cc9806f5d37e22c6296a1d8e50225fcf Richard Jones richard@users.sourceforge.net 2006-08-11T01:33:59+00:00 2006-08-11T01:33:59+00:00

changeset	8304a1c1cc98
branch
bookmark
tag
user	Richard Jones <richard@users.sourceforge.net>
description	encourage use of latest psycopg
files

http://hg.code.sf.net:8000/p/roundup/code/#changeset-950ce3afa6d3957bed2ffd0a2883d8693ef54c3e Richard Jones richard@users.sourceforge.net 2006-01-25T03:18:34+00:00 2006-01-25T03:18:34+00:00

changeset	950ce3afa6d3
branch
bookmark
tag
user	Richard Jones <richard@users.sourceforge.net>
description	add link, remove TSearch2
files

http://hg.code.sf.net:8000/p/roundup/code/#changeset-15c03392019caa15fd26bcf3e90b3fde9e625210 Richard Jones richard@users.sourceforge.net 2005-05-05T00:17:19+00:00 2005-05-05T00:17:19+00:00

changeset	15c03392019c
branch	maint-0.8
bookmark
tag
user	Richard Jones <richard@users.sourceforge.net>
description	version note
files

http://hg.code.sf.net:8000/p/roundup/code/#changeset-213468d6e7c93e673b2729c008864ad86b671c8e Johannes Gijsbers jlgijsbers@users.sourceforge.net 2005-01-04T17:52:50+00:00 2005-01-04T17:52:50+00:00

changeset	213468d6e7c9
branch
bookmark
tag
user	Johannes Gijsbers <jlgijsbers@users.sourceforge.net>
description	Add installation documentation for tsearch2.
files

http://hg.code.sf.net:8000/p/roundup/code/#changeset-653c7ffce402c556826377bc076137c84dd75cab Alexander Smishlajev a1s@users.sourceforge.net 2004-11-03T09:23:50+00:00 2004-11-03T09:23:50+00:00

changeset	653c7ffce402
branch
bookmark
tag
user	Alexander Smishlajev <a1s@users.sourceforge.net>
description	remove obsolete configuration notes
files

http://hg.code.sf.net:8000/p/roundup/code/#changeset-c0d6d5004464b78ce04f2874adcc78632836a9fa Richard Jones richard@users.sourceforge.net 2004-07-20T04:38:54+00:00 2004-07-20T04:38:54+00:00

changeset	c0d6d5004464
branch
bookmark
tag
user	Richard Jones <richard@users.sourceforge.net>
description	rdbms doc updates
files

http://hg.code.sf.net:8000/p/roundup/code/#changeset-f255363e6d976d4a92190c19619fc47188c9d2f3 Richard Jones richard@users.sourceforge.net 2003-11-11T11:19:18+00:00 2003-11-11T11:19:18+00:00

changeset	f255363e6d97
branch
bookmark
tag
user	Richard Jones <richard@users.sourceforge.net>
description	PostgreSQL backend lands. - that's the postgresql backend in (cleaned up doc, unit testing harness and the backend module itself) - also cleaned up the index maintenance code (actual checks for existence rather than bare-except failure mode)
files

http://hg.code.sf.net:8000/p/roundup/code/#changeset-3ffb7b56172add9ddf0a07d334288b05d8ee8ac9 Richard Jones richard@users.sourceforge.net 2003-10-25T23:00:42+00:00 2003-10-25T23:00:42+00:00

changeset	3ffb7b56172a
branch
bookmark
tag
user	Richard Jones <richard@users.sourceforge.net>
description	*** empty log message ***
files

http://hg.code.sf.net:8000/p/roundup/code/#changeset-f63aa57386b0b2c50eb311d6b407a12e9b5e45db Richard Jones richard@users.sourceforge.net 2003-10-25T22:53:26+00:00 2003-10-25T22:53:26+00:00

changeset	f63aa57386b0
branch
bookmark
tag
user	Richard Jones <richard@users.sourceforge.net>
description	Backend improvements. - using Zope3's test runner now, allowing GC checks, nicer controls and coverage analysis - all RDMBS backends now have indexes on several columns - added testing of schema mutation, fixed rdbms backends handling of a couple of cases - !BETA! added postgresql backend, needs work !BETA!
files