MIME-Version: 1.0
References: 
 <CAO+oWtDcnBcAP+xNyvJ3z2MydKaGGZTZTXbucuU5_J6u+-yEcQ@mail.gmail.com>
 <CA+OCxozfcxstPaX8pLKUtFAiYT8z30EKnRs0OmLn+x7Yc7CzhQ@mail.gmail.com>
 <CAO+oWtAFUkU100ATF0eK7bVK0-RWfPmV4qHZk+J5euSHTy+M3g@mail.gmail.com>
 <CA+OCxoztMFO24ZYSsNnX98zTnxst4uLpaN4qK+2jEwyyJwnAKQ@mail.gmail.com>
 <CAO+oWtBKzSNxeNUwfK31wgfZ71X2-zOh-avYxwwO2dT3kff0yQ@mail.gmail.com>
In-Reply-To: 
 <CAO+oWtBKzSNxeNUwfK31wgfZ71X2-zOh-avYxwwO2dT3kff0yQ@mail.gmail.com>
From: Dave Page <dpage@pgadmin.org>
Date: Thu, 5 Dec 2024 11:41:33 +0000
Message-ID: 
 <CA+OCxozz4eKUB=OEgNCC=k70GGmpuQ+8HyFaTPjduB7ghFp+TQ@mail.gmail.com>
Subject: Re: Require suggestions on feature #5766
To: Anil Sahoo <anil.sahoo@enterprisedb.com>
Cc: pgadmin-hackers <pgadmin-hackers@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000ef4e8806288461c6"
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2BOCxozz4eKUB%3DOEgNCC%3Dk70GGmpuQ%2B8HyFaTPjduB7ghFp%2BTQ%40mail.gmail.com>
Precedence: bulk

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

Hi

On Wed, 4 Dec 2024 at 05:19, Anil Sahoo <anil.sahoo@enterprisedb.com> wrote=
:

> Hi Dave,
>
> For Windows, I checked how pgAdmin works for machine-wide installations a=
s
> admin1 (Administrator), and there is another admin user like admin2
> (Administrator), and normal users are user1 and user2. When logged in as
> other mentioned users, I was able to use pgAdmin, but when I tried to
> upgrade pgAdmin as admin2 from v8.12 to v8.13, I faced the below error:
>
> "An error occurred while trying to replace the existing file:
>
> DeleteFile failed; code 5.
>
> Access is denied."
>
>  And if I cancel installation, then run pgAdmin, v8.12 is getting
> corrupted and giving
>
> "The pgAdmin 4 server could not be contacted:
> C:\Program Files (x86)\pgAdmin 4\python\python.exe: can't open file =E2=
=80=98 C:\\
> Program Files (x86)\\pgAdmin
>
> 4\\web\\pgAdmin4.py: [Errno 2] No such file or directory."
>
> For user-level installation, everything is working fine for different
> users.
>
> I have checked some of the desktop applications that are being built with
> Electron, like VS Code and Postman.
>
> *How VS Code works is,*
>
> They have 2 different installers, one for user level and another for
> system level.
>
> When I installed the VS Code system installer on admin1, it was working
> fine, and I was able to check for updates, and for admin2 and user1, it i=
s
> available, working fine and able to check for updates, not able to update
> as I am in the latest version. (Note: not found system installers for old=
er
> versions, but user installers are available)
>
> When I installed the VS Code user installer on admin1, it was working
> fine, and VS Code says when running it as an administrator in a user setu=
p
> installation, updates will be disabled.
>
> When I tried to install the user installer on user1, it was working fine
> and able to check for updates.
>
> *How Postman works is,*
>
> When I installed Postman on admin1, it was available for admin2 also. It
> was working fine, and checking for auto updates was also working fine for
> both admins. It is not available for normal users when installed for admi=
ns.
>
> When I installed Postman for user1, it was available only for the current
> user, and checking for updates was working fine.
>
> So please give your suggestions on which approach to follow.
>
Postman seems to be a nice model to follow, though it will require us to
check if the current user has permissions to update the installation. That
might be tricky to get right.

I would suggest that for the initial version we simply disable auto-update
for machine wide installations, and think about supporting them for admin
users in the future when we can properly check that we have the desired
permissions. We should also consider changes to the installer - e.g.
perhaps make the per-user installation the default, and (if possible) add a
note under the machine-wide option to warn the user that auto updates would
be disabled.

Thanks, Dave.

--=20
Dave Page
pgAdmin: https://www.pgadmin.org
PostgreSQL: https://www.postgresql.org
pgEdge: https://www.pgedge.com

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

<div dir=3D"ltr"><div>Hi</div><br><div class=3D"gmail_quote gmail_quote_con=
tainer"><div dir=3D"ltr" class=3D"gmail_attr">On Wed, 4 Dec 2024 at 05:19, =
Anil Sahoo &lt;<a href=3D"mailto:anil.sahoo@enterprisedb.com">anil.sahoo@en=
terprisedb.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" st=
yle=3D"margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:sol=
id;border-left-color:rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><p=
>Hi Dave,</p>
<p>For Windows, I checked how pgAdmin works for machine-wide installations =
as admin1 (Administrator), and there is another admin user like admin2 (Adm=
inistrator), and normal users are user1 and user2. When logged in as other =
mentioned users, I was able to use pgAdmin, but when I tried to upgrade pgA=
dmin as admin2 from v8.12 to v8.13, I faced the below error:</p>
<p>&quot;An error occurred while trying to replace the existing file:</p>
<p>DeleteFile failed; code 5.</p><p>Access is denied.&quot;</p>
<p>=C2=A0And if I cancel installation, then run pgAdmin, v8.12 is getting c=
orrupted and giving</p>
<p>&quot;The pgAdmin 4 server could not be contacted:<br>C:\Program Files (=
x86)\pgAdmin 4\python\python.exe: can&#39;t open file =E2=80=98 C:\\ Progra=
m Files (x86)\\pgAdmin</p>
<p>4\\web\\pgAdmin4.py: [Errno 2] No such file or directory.&quot;</p><p>Fo=
r user-level installation, everything is working fine for different users.<=
/p>
<p>I have checked some of the desktop applications that are being built wit=
h Electron, like VS Code and Postman.</p>
<p><b>How VS Code works is,</b></p>
<p>They have 2 different installers, one for user level and another for sys=
tem level.</p>
<p>When I installed the VS Code system installer on admin1, it was working =
fine, and I was able to check for updates, and for admin2 and user1, it is =
available, working fine and able to check for updates, not able to update a=
s I am in the latest version. (Note: not found system installers for older =
versions, but user installers are available)</p>
<p>When I installed the VS Code user installer on admin1, it was working fi=
ne, and VS Code says when running it as an administrator in a user setup in=
stallation, updates will be disabled.</p>
<p>When I tried to install the user installer on user1, it was working fine=
 and able to check for updates.</p>
<p><b>How Postman works is,</b></p>
<p>When I installed Postman on admin1, it was available for admin2 also. It=
 was working fine, and checking for auto updates was also working fine for =
both admins. It is not available for normal users when installed for admins=
.</p>
<p>When I installed Postman for user1, it was available only for the curren=
t user, and checking for updates was working fine.</p>
<p>So please give your suggestions on which approach to follow.</p></div></=
blockquote><div>Postman seems to be a nice model to follow, though it will =
require us to check if the current user has permissions to update the insta=
llation. That might be tricky to get right.</div><div><br></div><div>I woul=
d suggest that for the initial version we simply disable auto-update for ma=
chine wide installations, and think about supporting them for admin users i=
n the future when we can properly check that we have the desired permission=
s. We should also consider changes to the installer - e.g. perhaps make the=
 per-user installation the default, and (if possible) add a note under the =
machine-wide option to warn the user that auto updates would be disabled.</=
div><div><br></div><div>Thanks, Dave.=C2=A0<br></div></div><div><br></div><=
span class=3D"gmail_signature_prefix">-- </span><br><div dir=3D"ltr" class=
=3D"gmail_signature"><div dir=3D"ltr">Dave Page<div>pgAdmin: <a href=3D"htt=
ps://www.pgadmin.org" target=3D"_blank">https://www.pgadmin.org</a></div><d=
iv>PostgreSQL: <a href=3D"https://www.postgresql.org" target=3D"_blank">htt=
ps://www.postgresql.org</a></div><div>pgEdge: <a href=3D"https://www.pgedge=
.com" target=3D"_blank">https://www.pgedge.com</a><br><div></div><div><br><=
/div></div></div></div></div>

--000000000000ef4e8806288461c6--