Re: pg_service.conf file on Windows

--000000000000beaa8a059c0725af
Content-Type: text/plain; charset="UTF-8"

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 <
[email protected]> wrote:

> Hi,
>
> You need to provide your service name in *Service *field which is
> located under the connection tab.
> Please refer https://www.pgadmin.org/docs/pgadmin4/4.17/server_dialog.html
>
> --
> Regards,
> Murtuza Zabuawala
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>
>
>
> On Mon, Jan 13, 2020 at 8:34 PM Robert Fazio <[email protected]> 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: [email protected]
>>
>

-- 
Bob Fazio email: [email protected]

--000000000000beaa8a059c0725af
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Yes, that part I understood.=C2=A0 The issue I was having =
was that it wasn&#39;t finding my actual file that defined the services.=C2=
=A0 Not sure, but I suspect that the issue was that I hadn&#39;t fully stop=
ped the service after I defined the environment variable specifying where m=
y pg_service.conf file was located.=C2=A0 =C2=A0It seems to working now wit=
h a system environment variable and after a reboot.<div><br></div></div><br=
><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Mon, J=
an 13, 2020 at 10:09 AM Murtuza Zabuawala &lt;<a href=3D"mailto:murtuza.zab=
[email protected]">[email protected]</a>&gt; wrote:<=
br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8e=
x;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"=
><div dir=3D"ltr"><div dir=3D"ltr"><div class=3D"gmail_default" style=3D"fo=
nt-family:verdana,sans-serif"><font color=3D"#444444">Hi,</font></div><div =
class=3D"gmail_default" style=3D"font-family:verdana,sans-serif"><font colo=
r=3D"#444444"><br></font></div><div class=3D"gmail_default" style=3D"font-f=
amily:verdana,sans-serif"><font color=3D"#444444">You need to provide=C2=A0=
your service name in <i><b>Service </b></i>field which is located=C2=A0unde=
r the connection tab.</font></div><div class=3D"gmail_default" style=3D"fon=
t-family:verdana,sans-serif"><font color=3D"#444444">Please refer <a href=
=3D"https://www.pgadmin.org/docs/pgadmin4/4.17/server_dialog.html" target=
=3D"_blank">https://www.pgadmin.org/docs/pgadmin4/4.17/server_dialog.html</=
a></font></div><div class=3D"gmail_default" style=3D"font-family:verdana,sa=
ns-serif;color:rgb(68,68,68)"><br></div><div><div dir=3D"ltr"><div dir=3D"l=
tr"><div><div dir=3D"ltr"><div><div dir=3D"ltr"><div><div dir=3D"ltr"><div>=
<div dir=3D"ltr"><div><div dir=3D"ltr"><div><div dir=3D"ltr"><font size=3D"=
2" face=3D"verdana, sans-serif" color=3D"#444444">--</font><div><font size=
=3D"2" face=3D"verdana, sans-serif" color=3D"#444444">Regards,</font><div><=
font size=3D"2"><font face=3D"verdana, sans-serif" color=3D"#444444">Murtuz=
a Zabuawala<br>EnterpriseDB:=C2=A0<a href=3D"http://www.enterprisedb.com/" =
rel=3D"noreferrer" target=3D"_blank">http://www.enterprisedb.com</a><br>The=
 Enterprise PostgreSQL Company</font></font></div></div><div><font size=3D"=
2"><font face=3D"verdana, sans-serif" color=3D"#444444"><br></font></font><=
/div></div></div></div></div></div></div></div></div></div></div></div></di=
v></div></div></div><br></div></div></div><br><div class=3D"gmail_quote"><d=
iv dir=3D"ltr" class=3D"gmail_attr">On Mon, Jan 13, 2020 at 8:34 PM Robert =
Fazio &lt;<a href=3D"mailto:[email protected]" target=3D"_blank">dbabob@ho=
tmail.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=
=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding=
-left:1ex">




<div dir=3D"ltr">
<div style=3D"font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color=
:rgb(0,0,0)">
I seem to be unable to find a way to get PGAdmin to use a service configura=
tion file on my windows system.</div>
<div style=3D"font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color=
:rgb(0,0,0)">
I have tried using the PGSERVICEFILE environment variable to specify one, a=
s well as multiple attempts to guess at where it might be looking for a fil=
e named either .pg_service.conf or pg_service.conf.</div>
<div style=3D"font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color=
:rgb(0,0,0)">
<br>
</div>
<div style=3D"font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color=
:rgb(0,0,0)">
I haven&#39;t had any issues doing this on Linux, just windows.</div>
<div style=3D"font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color=
:rgb(0,0,0)">
<br>
</div>
<div id=3D"gmail-m_-1209281852572385324gmail-m_-324115558484774058Signature=
">
<div>Bob Fazio<br>
email: <a href=3D"mailto:[email protected]" target=3D"_blank">dbabob@hotma=
il.com</a></div>
</div>
</div>

</blockquote></div>
</blockquote></div><br clear=3D"all"><div><br></div>-- <br><div dir=3D"ltr"=
 class=3D"gmail_signature">Bob Fazio email: <a href=3D"mailto:dbabob@gmail.=
com" target=3D"_blank">[email protected]</a></div>

--000000000000beaa8a059c0725af--