Re: Problem with pg_service.conf

2020-07-23 Thread David G. Johnston
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, only

Re: Problem with pg_service.conf

2020-07-23 Thread Michał Lis
nt 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

Re: Problem with pg_service.conf

2020-07-22 Thread Adrian Klaver
On 7/21/20 2: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 localizati

Re: Problem with pg_service.conf

2020-07-22 Thread Ron
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 localizati

Problem with pg_service.conf

2020-07-22 Thread Michał Lis
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. Readi