| From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Cc: | fcs1(at)poczta(dot)onet(dot)pl |
| Subject: | BUG #16550: Problem with pg_service.conf |
| Date: | 2020-07-21 16:20:27 |
| Message-ID: | 16550-f4d3c9b483d4d5a2@postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 16550
Logged by: Michal L
Email address: fcs1(at)poczta(dot)onet(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2020-07-21 17:53:35 | 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. |
| Previous Message | Pavel Stehule | 2020-07-21 15:35:16 | Re: BUG #16549: "CASE" not work properly , the function works properly on PostgreSQL 9.6.8 |