Mercurial > p > roundup > code
diff 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 |
line wrap: on
line diff
--- a/doc/reference.txt Sun Nov 05 23:01:29 2023 -0500 +++ b/doc/reference.txt Tue Nov 07 12:11:37 2023 -0500 @@ -293,6 +293,19 @@ password -- ``roundup`` Database user password. + service -- default *blank* + Use to define the Connection Service for your PostgreSQL connection + when using a system-wide pg_service.conf or ~/.pg_service.conf as + discussed in + https://www.postgresql.org/docs/current/libpq-pgservice.html. + + Setting this to the name of the service allows different trackers to + connect to different services when running multiple trackers under + one Roundup server. If you are only running one tracker, you can set + the PGSERVICE environment variable. Note that other settings + specified in this file (rdbms: user, password, port, host, (db)name) + will override the corresponding connection service setting. + read_default_file -- ``~/.my.cnf`` Name of the MySQL defaults file. Only used in MySQL connections.