Re: BUG #16550: Problem with pg_service.conf

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: BUG #16550: Problem with pg_service.conf
Дата
Msg-id CAKFQuwbGxYPZ7woMR53226TU7a4DNqAECSRrU+1J_86b+k_diA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #16550: Problem with pg_service.conf  (Jeff Janes <jeff.janes@gmail.com>)
Ответы Re: BUG #16550: Problem with pg_service.conf  (Michał Lis <fcs1@poczta.onet.pl>)
Список pgsql-bugs
Дерево обсуждения
On Thu, Jul 23, 2020 at 2:16 PM Jeff Janes <jeff.janes@gmail.com> wrote:
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.


pgbench works just fine on Linux when I execute (no environment variables) [1] with an appropriate service entry in /usr/local/pgsql/etc.  I find it odd that it wouldn't work on Windows, especially since other programs do and the connection code for pgbench looks the same as for the others and doesn't seem to be influenced by conditional compilation.

pgAdmin4 is out-of-scope for this list.

David J.

1. /usr/local/pgsql/bin/pgbench -i "service=postgres"

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: BUG #16550: Problem with pg_service.conf
Следующее
От: tutiluren@tutanota.com
Дата:
Сообщение: pg_dump seems to be broken in regards to the "--exclude-table-data" option on Windows.