Re: BUG #16550: Problem with pg_service.conf

Hello,

No, the file is only on the server side.

I expected the client will ask the server using the service name.
If the service will be found on the server, the server should accept the
connection from the client.

In pg_service.conf file can be stored user name and password.

I want to use login of service type, because I won't to store any login
information (ie password) on the client side.

Copping the pg_service.conf to the client and setting the system
variable to this file, rather has no sense.

Regards
Michal

W dniu 2020-07-22 o 17:29, Jeff Janes pisze:
> On Wed, Jul 22, 2020 at 4:05 AM Michał Lis <fcs1(at)poczta(dot)onet(dot)pl
> <mailto:fcs1(at)poczta(dot)onet(dot)pl>> wrote:
>
> On the local machine the connection will be established but on
> remote machine the error:
>
> definition of service "test4" not found
>
>
> The service file is read by the client, not the server. So the remote
> machine will use the service file local to it.  Did you copy your
> pg_service.conf to the proper directory on the remote machine?
> Cheers,
>
> Jeff