Search Postgresql Archives

Re: Problem with pg_service.conf

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux