Postgres Pro
Downloads
Home   >   mailing lists

BUG #16550: Problem with pg_service.conf - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #16550: Problem with pg_service.conf
Date
Msg-id 16550-f4d3c9b483d4d5a2@postgresql.org
Whole thread Raw
Responses Re: BUG #16550: Problem with pg_service.conf
Re: BUG #16550: Problem with pg_service.conf
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: BUG #16549: "CASE" not work properly , the function works properly on PostgreSQL 9.6.8
Next
From: "David G. Johnston"
Date:
Subject: Re: pg_dump's "--exclude-table" and "--exclude-table-data" options are ignored and/or cause the dump to fail entirely unless both the schema and table name use 1950s-era identifiers.