On Thu, Jul 23, 2020 at 6:12 AM Michał Lis wrote:
> Hello,
>
> The server is located in the lan and runs on Windows 7x64 Ultimate.
> On this server I created pg_service.conf file and set the environment
> variable of PGSERVICEFILE.
>
The server software (postgres) doesn't use PGSERVICEFILE,
to
store any login information on the client side.
Yesterday I created a topic:
BUG #16550: Problem with pg_service.conf
on pgsql-bugs list
At this moment I have the information that the copy of pg_service.conf
file is necessary on the client side to establish connection by service
name.
I
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
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
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