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 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