comparison doc/reference.txt @ 7696:4af0d235b570

feat(db): support using postgresql service connection file Add new service rdbms config option to set the service name to be used with a postgresql service connection file. This can be done using the PGSERVICE environment variable for a single instance tracker server. For a multi-instance server this per-tracker config option is needed. Note that settings (host, user, (db)name...) in config.ini file will override the service connection file setting. Also setting PGSERVICE and service will use the service setting.
author John Rouillard <rouilj@ieee.org>
date Tue, 07 Nov 2023 12:11:37 -0500
parents c09192e21faa
children 3071db43bfb6
comparison
equal deleted inserted replaced
7695:2be7a8f66ea7 7696:4af0d235b570
290 user -- ``roundup`` 290 user -- ``roundup``
291 Database user name that Roundup should use. 291 Database user name that Roundup should use.
292 292
293 password -- ``roundup`` 293 password -- ``roundup``
294 Database user password. 294 Database user password.
295
296 service -- default *blank*
297 Use to define the Connection Service for your PostgreSQL connection
298 when using a system-wide pg_service.conf or ~/.pg_service.conf as
299 discussed in
300 https://www.postgresql.org/docs/current/libpq-pgservice.html.
301
302 Setting this to the name of the service allows different trackers to
303 connect to different services when running multiple trackers under
304 one Roundup server. If you are only running one tracker, you can set
305 the PGSERVICE environment variable. Note that other settings
306 specified in this file (rdbms: user, password, port, host, (db)name)
307 will override the corresponding connection service setting.
295 308
296 read_default_file -- ``~/.my.cnf`` 309 read_default_file -- ``~/.my.cnf``
297 Name of the MySQL defaults file. Only used in MySQL connections. 310 Name of the MySQL defaults file. Only used in MySQL connections.
298 311
299 read_default_group -- ``roundup`` 312 read_default_group -- ``roundup``

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