Re: Problem with pg_service.conf

On 7/21/20 4:35 PM, Michał Lis wrote:
> 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:\PostgreSQLx86\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:\PostgreSQLx86\9.6\etc\pg_service.conf.
>
> After that the connection to database via service began work, but only on
> local machine.
>
> To reproduce problem:
>
> 1. Create pg_service.conf file like this:
>
> [test4]
> host=192.168.1.2
> port=5433
> dbname=test
> user=postgres
> password=abcd
>
> 2. Save this file in a directory, in my case it was
> D:\PostgreSQLx86\9.6\etc\pg_service.conf
> (line ends in Linux style by NotePad++)
>
> 3. Set the global system variable:
> PGSERVICEFILE =D:\PostgreSQLx86\9.6\etc\pg_service.conf
>
> 4. Restart computer to take effects for setting PGSERVICEFILE

Are you sure that PGSERVICEFILE is being defined correctly?

>
> 5. Open PGAdmin 3 or 4 no matter which.
>
> 6. Add and Set database connection
> - Name: test
> - Host: 192.168.1.2
> - Port: 0
> - Service: test4
> - User: <empty>
> - Password: <empty>
>
> 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.
>
> PostgreSQL version: 9.6.11 and 9.4
> Operating system: Windows 7 x64 Pro/Ultimate
>
> Regards
> Michal
>
>
>
>
>

--
Angular momentum makes the world go 'round.