Re: BUG #16550: Problem with pg_service.conf - Mailing list pgsql-bugs

From Jeff Janes
Subject Re: BUG #16550: Problem with pg_service.conf
Date
Msg-id CAMkU=1y5_k-M4diUWPJ95mzdZc0vSoPcu=s1DQ2r_4_neb-LYg@mail.gmail.com
Whole thread Raw
In response to Re: BUG #16550: Problem with pg_service.conf  (Jeff Janes <jeff.janes@gmail.com>)
Responses Re: BUG #16550: Problem with pg_service.conf
List pgsql-bugs
On Thu, Jul 23, 2020 at 4:50 PM Jeff Janes <jeff.janes@gmail.com> wrote:
So the bug is that the pg_service.conf file is not read from this location.

I can reproduce this after using the EDB installer to install.  

I create the directory indicated by `pg_config --sysconfdir`, put the pg_service.conf in it, and psql and pg_dump work without setting either PGSERVICEFILE or PGSYSCONFDIR. But pgbench and PgAdmin4 do not work with the service file this way, but do work if I define PGSERVICEFILE, so there does seem to be something buggy going on.

This was on Windows 2019, Windows_Server-2019-English-Full-Base-2020.07.15 (ami-066a1a3fa81bfbd00).  With both 9.6 and 12 (the only ones I tested), and I installed both to the default location and a custom location (on a fresh machine each time), makes no difference.
 

pgsql-bugs by date:

Previous
From: Jeff Janes
Date:
Subject: Re: BUG #16550: Problem with pg_service.conf
Next
From: "David G. Johnston"
Date:
Subject: Re: BUG #16550: Problem with pg_service.conf