Issue opening pgAdmin4 v5 in Windows 10

From: Matt DaSilva <Matt(dot)DaSilva(at)caemsi(dot)com>
To: "pgadmin-support(at)lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org>
Subject: Issue opening pgAdmin4 v5 in Windows 10
Date: 2021-08-11 17:35:46
Message-ID: BN3P110MB037285CE6B53B6D0EE6CA8FAE3F89@BN3P110MB0372.NAMP110.PROD.OUTLOOK.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hello,

I just installed pgAdmin 4 v5. I previously had pgAdmin 4 but it stopped connecting about 3 weeks ago. A co-worker told me that updating to pgAdmin 4 v5 (for their own user) fixed the issue for him. However, we I launch it, I get the following error below:

[cid:image004(dot)jpg(at)01D78EB5(dot)C973E740]

Can I get some assistance please?

Here’s the full message:
pgAdmin Runtime Environment
--------------------------------------------------------
Python Path: "C:\Users\dasilvama\AppData\Local\Programs\pgAdmin 4\v5\python\python.exe"
Runtime Config File: "C:\Users\dasilvama\AppData\Roaming\pgadmin\runtime_config.json"
pgAdmin Config File: "C:\Users\dasilvama\AppData\Local\Programs\pgAdmin 4\v5\web\config.py"
Webapp Path: "C:\Users\dasilvama\AppData\Local\Programs\pgAdmin 4\v5\web\pgAdmin4.py"
pgAdmin Command: "C:\Users\dasilvama\AppData\Local\Programs\pgAdmin 4\v5\python\python.exe -s C:\Users\dasilvama\AppData\Local\Programs\pgAdmin 4\v5\web\pgAdmin4.py"
Environment:
- ALLUSERSPROFILE: C:\ProgramData
- APPDATA: C:\Users\dasilvama\AppData\Roaming
- CHROME_CRASHPAD_PIPE_NAME: \\.\pipe\crashpad_36924_ZPVKVUMAEKCFIHMA
- CHROME_RESTART: NW.js|Whoa! NW.js has crashed. Relaunch now?|LEFT_TO_RIGHT
- CommonProgramFiles: C:\Program Files\Common Files
- CommonProgramFiles(x86): C:\Program Files (x86)\Common Files
- CommonProgramW6432: C:\Program Files\Common Files
- COMPUTERNAME: MSINB5CG03873S9
- ComSpec: C:\WINDOWS\system32\cmd.exe
- DriverData: C:\Windows\System32\Drivers\DriverData
- GDAL_DATA: C:\Program Files\PostgreSQL\11\gdal-data
- HOMEDRIVE: C:
- HOMEPATH: \Users\dasilvama
- JAVA_BIN: C:\Program Files\Java\jdk1.8.0_291\bin
- JAVA_HOME: C:\Program Files\Java\jdk1.8.0_291
- JAVA_INCLUDE: C:\Program Files\Java\jdk1.8.0_291\include
- LDMS_LOCAL_DIR: C:\Program Files (x86)\LANDesk\LDClient\Data
- LOCALAPPDATA: C:\Users\dasilvama\AppData\Local
- LOGONSERVER: \\CAEMSIDC03
- MSMPI_BIN: C:\Program Files\Microsoft MPI\Bin\
- NUMBER_OF_PROCESSORS: 8
- OneDrive: C:\Users\dasilvama\OneDrive
- OS: Windows_NT
- Path: C:\Program Files (x86)\VMware\VMware Workstation\bin\;C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\Program Files\Microsoft MPI\Bin\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\WINDOWS\System32\OpenSSH\;C:\Program Files\Microsoft SQL Server\130\Tools\Binn\;C:\Program Files\dotnet\;C:\Program Files\Git\cmd;C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\170\Tools\Binn\;C:\Program Files\PuTTY\;C:\Program Files\RedHat\java-1.8.0-openjdk-1.8.0.242-3\bin;C:\Program Files\RedHat\java-1.8.0-openjdk-1.8.0.242-3\jre\bin;C:\Program Files\Docker\Docker\resources\bin;C:\ProgramData\DockerDesktop\version-bin;C:\Program Files\Amazon\AWSCLI\bin\;C:\Program Files\nodejs\;C:\Python27\;C:\Users\dasilvama\AppData\Local\Programs\Python\Python36\;C:\Program Files (x86)\Sennheiser\SenncomSDK\;C:\Fortify\Fortify_SCA_and_Apps_20.2.2\bin;C:\Users\dasilvama\AppData\Local\Microsoft\WindowsApps;C:\Users\dasilvama\AppData\Local\Programs\Microsoft VS Code\bin;C:\Users\dasilvama\AppData\Roaming\npm;C:\cygwin64\bin;C:\Users\dasilvama\AppData\Local\gitkraken\bin
- PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
- PGADMIN_INT_KEY: 08e0cc30-6347-4c63-96da-89cda330f77a
- PGADMIN_INT_PORT: 58944
- PGADMIN_SERVER_MODE: OFF
- POSTGIS_ENABLE_OUTDB_RASTERS: 1
- POSTGIS_GDAL_ENABLED_DRIVERS: GTiff PNG JPEG GIF XYZ DTED USGSDEM AAIGrid
- PROCESSOR_ARCHITECTURE: AMD64
- PROCESSOR_IDENTIFIER: Intel64 Family 6 Model 142 Stepping 12, GenuineIntel
- PROCESSOR_LEVEL: 6
- PROCESSOR_REVISION: 8e0c
- ProgramData: C:\ProgramData
- ProgramFiles: C:\Program Files
- ProgramFiles(x86): C:\Program Files (x86)
- ProgramW6432: C:\Program Files
- PSModulePath: C:\Program Files\WindowsPowerShell\Modules;C:\WINDOWS\system32\WindowsPowerShell\v1.0\Modules
- PUBLIC: C:\Users\Public
- SESSIONNAME: Console
- SystemDrive: C:
- SystemRoot: C:\WINDOWS
- TEMP: C:\Users\DASILV~1\AppData\Local\Temp
- TMP: C:\Users\DASILV~1\AppData\Local\Temp
- UATDATA: C:\WINDOWS\CCM\UATData\D9F8C395-CAB8-491d-B8AC-179A1FE1BE77
- USERDNSDOMAIN: MSI.CAEMILUSA.COM
- USERDOMAIN: MSI
- USERDOMAIN_ROAMINGPROFILE: MSI
- USERNAME: dasilvama
- USERPROFILE: C:\Users\dasilvama
- windir: C:\WINDOWS
--------------------------------------------------------

Traceback (most recent call last):
File "C:\Users\dasilvama\AppData\Local\Programs\pgAdmin 4\v5\web\pgAdmin4.py", line 98, in <module>
app = create_app()
File "C:\Users\dasilvama\AppData\Local\Programs\pgAdmin 4\v5\web\pgadmin\__init__.py", line 502, in create_app
driver.init_app(app)
File "C:\Users\dasilvama\AppData\Local\Programs\pgAdmin 4\v5\web\pgadmin\utils\driver\__init__.py", line 27, in init_app
DriverRegistry.load_modules(app)
File "C:\Users\dasilvama\AppData\Local\Programs\pgAdmin 4\v5\web\pgadmin\utils\dynamic_registry\__init__.py", line 63, in __load_modules
module = import_module(module_name)
File "importlib\__init__.py", line 127, in import_module
File "<frozen importlib._bootstrap>", line 1014, in _gcd_import
File "<frozen importlib._bootstrap>", line 991, in _find_and_load
File "<frozen importlib._bootstrap>", line 975, in _find_and_load_unlocked
File "<frozen importlib._bootstrap>", line 671, in _load_unlocked
File "<frozen importlib._bootstrap_external>", line 783, in exec_module
File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed
File "C:\Users\dasilvama\AppData\Local\Programs\pgAdmin 4\v5\web\pgadmin\utils\driver\psycopg2\__init__.py", line 21, in <module>
import psycopg2
File "C:\Users\dasilvama\AppData\Local\Programs\pgAdmin 4\v5\python\lib\site-packages\psycopg2\__init__.py", line 51, in <module>
from psycopg2._psycopg import ( # noqa
ImportError: DLL load failed while importing _psycopg: Access is denied.

Thanks,
[studio:_LOGOS:CAE:CAE:CAE_MASTER_LOGO_PMS_300C:CAE_LOGO_DIGITAL:CAE_LOGO_PNG:CAE_LOGO_RGB.png]

Matt DaSilva
Engineering Group Leader, CAE USA MSI

T. +1 813 880-7280 ▪ E. matt(dot)dasilva(at)caemsi(dot)com<mailto:matt(dot)dasilva(at)caemsi(dot)com>

Mission Solutions Inc. (MSI)
caemsi.com<https://www.cae.com/cae-usa/cae-usa-msi/>

CONFIDENTIALITY NOTICE
This e-mail message is intended only for the above named recipient(s) and may contain information that is confidential. If you have received this message in error or are not the named recipient(s), please immediately notify the sender, delete this e-mail message without making a copy and do not disclose or relay this e-mail message to anyone.

Browse pgadmin-support by date

  From Date Subject
Next Message Aditya Toshniwal 2021-08-12 04:34:46 Re: Running pgadmin4:5.5 behind reverse-proxy only shows progress indicator after successful login
Previous Message Jörg Liebig 2021-08-11 16:48:26 Re: Running pgadmin4:5.5 behind reverse-proxy only shows progress indicator after successful login