Thread: pg_service.conf file on Windows
I seem to be unable to find a way to get PGAdmin to use a service configuration file on my windows system.
I have tried using the PGSERVICEFILE environment variable to specify one, as well as multiple attempts to guess at where it might be looking for a file named either .pg_service.conf or pg_service.conf.
I haven't had any issues doing this on Linux, just windows.
Bob Fazio
email: dbabob@hotmail.com
email: dbabob@hotmail.com
Hi,
You need to provide your service name in Service field which is located under the connection tab.
--
Regards,
On Mon, Jan 13, 2020 at 8:34 PM Robert Fazio <dbabob@hotmail.com> wrote:
I seem to be unable to find a way to get PGAdmin to use a service configuration file on my windows system.I have tried using the PGSERVICEFILE environment variable to specify one, as well as multiple attempts to guess at where it might be looking for a file named either .pg_service.conf or pg_service.conf.I haven't had any issues doing this on Linux, just windows.Bob Fazio
email: dbabob@hotmail.com
Yes, that part I understood. The issue I was having was that it wasn't finding my actual file that defined the services. Not sure, but I suspect that the issue was that I hadn't fully stopped the service after I defined the environment variable specifying where my pg_service.conf file was located. It seems to working now with a system environment variable and after a reboot.
On Mon, Jan 13, 2020 at 10:09 AM Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.com> wrote:
Hi,You need to provide your service name in Service field which is located under the connection tab.--Regards,On Mon, Jan 13, 2020 at 8:34 PM Robert Fazio <dbabob@hotmail.com> wrote:I seem to be unable to find a way to get PGAdmin to use a service configuration file on my windows system.I have tried using the PGSERVICEFILE environment variable to specify one, as well as multiple attempts to guess at where it might be looking for a file named either .pg_service.conf or pg_service.conf.I haven't had any issues doing this on Linux, just windows.Bob Fazio
email: dbabob@hotmail.com
Bob Fazio email: dbabob@gmail.com