> On Jul 22, 2020, at 10:02, Michał Lis <fcs1@poczta.onet.pl> wrote:
>
> Copping the pg_service.conf to the client and setting the system variable to this file, rather has no sense.
Well, that's how the pg_service.conf file works; it is read by the client, not by the server:
https://www.postgresql.org/docs/12/libpq-pgservice.html
If you want the client to be able to log into the server without manually specifying credentials, you'll need to store
thosecredentials (password, private key, etc.) somewhere on the client that the client program can access them. The
servicefile is one way of doing that, as is the .pgpasswd file.
--
-- Christophe Pettus
xof@thebuild.com