Re: BUG #16550: Problem with pg_service.conf

PGSERVICEFILE

5. Open PGAdmin 3 or 4 no matter which.

6. Add and Set database connection


On the local machine the connection will be established but on remote machine the error:

definition of service "test4" not found

will be raised

Connection from remote machine to server by host, port, user and password works fine.


Regards
Michal

The following bug has been logged on the website:

Bug reference:      16550
Logged by:          Michal L
Email address:      fcs1@poczta.onet.pl
PostgreSQL version: 9.6.11
Operating system:   Windows 7 x64 Pro/Ultimate
Description:        

Hello,

I can't connect to a database via service defined in pg_service.conf file
from remote machine. 

Connection from local machine using this service definition works fine.

I tested it on PostgreSQL 9.4 and 9.6.

The other problem is with the localization of the pg_service.conf file.
Reading internet solutions, I found, that this file may be placed in global
configuration folder. In my case it is D:\PostgrSQLx86\9.6\etc (the 
SYSCONFDIR variable displayed by pg_config.exe).
Placing the file into this folder does not work.

I had to define the global system variable PGSERVICEFILE =
D:\PostgrSQLx86\9.6\etc\pg_service.conf. 
After that the connection to database via service began work, but only on
local machine.

Regards
Michal