Re: Connecting to PostgreSQL database using pg_service.conf

Hello Ivanov:

In message <[email protected]>,
"John P. Rouillard" writes:
>In message <[email protected]>,
>[email protected] writes:
>>On 2023-11-06 23:13, John P. Rouillard wrote: 
>>> If you want to move forward with Roundup and run multiple trackers
>>> with one Roundup server instance, we can work on getting support for
>>> specifying the 'service' in config.ini. You would need to test using
>>> the current development code.
>>
>>Thank you. At the moment I plan to install only one tracker, but I think
>>it would be nice to have such an option. When you implement this, I will
>>be happy to test it.
>
>Since it only took a couple of hours, I implemented it in: 
>
>    changeset:   7696:4af0d235b570
>    tag:         tip
>    user:        John Rouillard <[email protected]>
>    date:        Tue Nov 07 12:11:37 2023 -0500
>    files:       CHANGES.txt doc/reference.txt
>                 roundup/backends/back_postgresql.py
>                 roundup/backends/rdbms_common.py roundup/configuration.py
>
>    description:
>    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.
>
>You can pull the code from the repo using mercurial:
>
>  hg clone http://hg.code.sf.net/p/roundup/code roundup
>
>The issue is tracked at: https://issues.roundup-tracker.org/issue2551299
>
>You can send email to the [email protected] with the subject:
>
>  [issue2551299] Connecting to PostgreSQL database using pg_service.conf
>
>to followup with any issues or just reply here.

Have you had a chance to test this?

Have a great week.

--
				-- rouilj
John Rouillard
===========================================================================
My employers don't acknowledge my existence much less my opinions.