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.jpg@01D78EB5.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.dasi...@caemsi.com<mailto:matt.dasi...@caemsi.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.
