Re: Connecting to PostgreSQL database using pg_service.conf

Hello Ivanov:

In message <[email protected]>,
[email protected] writes:
>On 2023-11-06 23:13, John P. Rouillard wrote: 
>> It might be a useful enhancement to support 'service' directly in
>> config.ini. It would be useful when running one roundup server serving
>> multiple trackers.
>> 
>> 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 a great week.

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