comparison doc/reference.txt @ 7719:3071db43bfb6

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.
author John Rouillard <rouilj@ieee.org>
date Wed, 27 Dec 2023 22:52:14 -0500
parents 4af0d235b570
children f14409a760e3
comparison
equal deleted inserted replaced
7718:3da452f4a3ac 7719:3071db43bfb6
275 275
276 backend -- set to value by init 276 backend -- set to value by init
277 The database backend such as anydbm, sqlite, mysql or postgres. 277 The database backend such as anydbm, sqlite, mysql or postgres.
278 278
279 name -- ``roundup`` 279 name -- ``roundup``
280 Name of the database to use. 280 Name of the database to use. For Postgresql, this can
281 be database.schema to use a specific schema within
282 a Postgres database.
281 283
282 host -- ``localhost`` 284 host -- ``localhost``
283 Database server host. 285 Database server host.
284 286
285 port -- default *blank* 287 port -- default *blank*

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