Re: Windows installation requires admin rights

Hi Dave,

1. Installer is not signed in yet and you have  already mentioned it.

2.   Findings in Install for me only(recommended) option in case of Admin User:

Pgadmin4 installing in the following location:

C:\Users\Administrator\AppData\Local\Programs\pgAdmin 4\v5

No issue found  so far with this scenario

3. Findings in Install for all users option with Admin user:

Pgadmin4 installing in the following location:

C:\Program Files\pgAdmin 4\v5

No issue found so far with this scenario

4. Findings in Install for me only(recommended) option in case of non Admin User with double:

Pgadmin4 installing in the following location:

C:\Users\Administrator\AppData\Local\Programs\pgAdmin 4\v5

No issue found  so far with this scenario

5. Findings in Install for all users option with Non admin user:

Pgadmin4 installing in the following location:

C:\Program Files\pgAdmin 4\v5

No issue found so far with this scenario

6. Findings in Install for me only(recommended) option, in case user change the installation directory with non admin user:

Login to admin user

Pgadmin4 installing in the following location:

C:\Users\Administrator\AppData\Local\Programs\pgAdmin 4\v5

 

But I changed the installation directory before the installation:

C:\Users\rayyan\AppData\Local\Programs\pgAdmin 4\v5

Menu item of pgadmin created under Administrator account while the installation is available in C:\Users\rayyan\AppData\Local\Programs\pgAdmin 4\v5

I can launch the pgadmin4 under an admin account successfully and in case a non-admin menu item of pgadmin is not present, but I can launch with the pgadmin4 script successfully.

 

7. I tested pgadmin on clean machine and no issue found

8. I also tested pgadmin4 if existing vcredist and vm tool is already available, no issue found

On Tue, May 25, 2021 at 1:29 PM Dave Page <dpage@pgadmin.org> wrote:

Hi

On Fri, May 21, 2021 at 9:25 PM Antoine Aumjaud <antoine_dev@aumjaud.fr> wrote:

Hi,

 

The actual configuration of Inno Setup for the installation of pgAdmin4 requires admin privileges on the computer :

https://github.com/postgres/pgadmin4/blob/master/pkg/win32/installer.iss.in#L31

                                PrivilegesRequired=admin

 

I have read the whole configuration, and I think that this constrain could be remove if HKCU (HKEY_CURENT_USER of Windows registry) is used instead of HKLM (HKEY_LOCAL_MACHINE).

 

The pgAdmin package provided by entreprisedb can be installed without admin rights, but it is an old version of pgAdmin.

 

Do you think that this modification is possible?

I think it's a little more complex than that, but here's a patch that I think does everything required. The only part I'm not sure about is the VC++ runtime installation, and ensuring that will work for non-admins. Fahar; can you test that on a *completely* clean installation of Windows please? You must run the "install only for me" option before anything else (don't even install VMware tools). 

There's a test build at https://developer.pgadmin.org/~dpage/non-admin-install/pgadmin4-5.3-x64.exe. Note that it is not signed, so you will get a warning, but that can be ignored for the purposes of this test.

--

Dave Page
Blog: https://pgsnake.blogspot.com
Twitter: @pgsnake

EDB: https://www.enterprisedb.com

--

Fahar Abbas

EnterpriseDB Corporation

Phone Office: +92-51-835-8874
Phone Direct: +92-51-8466803
Mobile: +92-333-5409707
Skype ID: live:fahar.abbas
Website: www.enterprisedb.com