无法打开pgadmin4！这是什么问题！试了好多种方法都解决不了。
The pgAdmin 4 server could not be contacted:
pgAdmin Runtime Environment
Python Path: "D:\software\postgresql16\pgAdmin 4\python\python.exe"
Runtime Config File: "C:\Users\lenovo\AppData\Roaming\pgadmin\runtime_config.json"
pgAdmin Config File: "D:\software\postgresql16\pgAdmin 4\web\config.py"
Webapp Path: "D:\software\postgresql16\pgAdmin 4\web\pgAdmin4.py"
pgAdmin Command: "D:\software\postgresql16\pgAdmin 4\python\python.exe -s D:\software\postgresql16\pgAdmin 4\web\pgAdmin4.py"
Environment:
- ADSK_3DSMAX_x64_2021: D:\software\Autodesk\3ds Max 2021\
- AGSDESKTOPJAVA: D:\software\ArcGIS10.8\Desktop10.8\
- ALLUSERSPROFILE: C:\ProgramData
- APPDATA: C:\Users\lenovo\AppData\Roaming
- CHROME_CRASHPAD_PIPE_NAME: \\.\pipe\crashpad_9760_NMVOSUWZFGFLISAH
- CHROME_RESTART: NW.js|哎呀！NW.js 崩溃了。要立即重新启动吗？|LEFT_TO_RIGHT
- ClassPath: .;D:\software\java_severlibdt.jar;D:\software\java_severlib ools.jar;
- CommonProgramFiles: C:\Program Files\Common Files
- CommonProgramFiles(x86): C:\Program Files (x86)\Common Files
- CommonProgramW6432: C:\Program Files\Common Files
- COMPUTERNAME: LAPTOP-2034COOG
- ComSpec: C:\Windows\system32\cmd.exe
- CURL_CA_BUNDLE: D:\software\pgadmin\ssl\certs\ca-bundle.crt
- DriverData: C:\Windows\System32\Drivers\DriverData
- EFC_11396: 1
- ENVI53_GPTOOLS: D:\software\ENVI\IDL85
- GDAL_DATA: D:\software\pgadmin\gdal-data
- HOMEDRIVE: C:
- HOMEPATH: \Users\lenovo
- IGCCSVC_DB: AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAdEfksm+GN0G5Ztl+lT3WOQQAAAACAAAAAAAQZgAAAAEAACAAAACbCx1vGsl9PpiCeZH0JtLnMBj4ccGnmoH3sF08Ml+6wAAAAAAOgAAAAAIAACAAAAAyZMxOtwO4n+/kNyVIr6XEnjEIga3TwgI1z0hF8es02WAAAACMSHU2Up6vumYJWgsLnHCdL00jslsHJhVXJ6+AIkPJnZQChTUNxMQoRqU73dlSWgW928sX3KrRBHb1eLTWez16MePJjK2hc17ZRO78Bmm3zBXW+aogUzgrbC0GABFkHXlAAAAAZCH11Ow9dKN5MKNR6InKzNft83MIaQQLsKbWrX72/oW5NEiSUTcibPI67n5Apish9Y64kpxTMo5BF+XU9+/Mpg==
- JAVA_HOME: D:\software\java_sever
- LOCALAPPDATA: C:\Users\lenovo\AppData\Local
- LOGONSERVER: \\LAPTOP-2034COOG
- NUMBER_OF_PROCESSORS: 32
- OneDrive: C:\Users\lenovo\OneDrive
- OneDriveConsumer: C:\Users\lenovo\OneDrive
- OS: Windows_NT
- path: D:\software\java_sever\jre\bin;D:\software\java_sever\bin;D:\software\python\Scripts\pip.exe；D:\software\python\Scripts\pip3.exe;C:\Users\lenovo\AppData\Local\Programs\Python\Launcher\;C:\Users\lenovo\.dotnet\tools;C:\Users\lenovo\AppData\Roaming\npm;D:\software\python;D:\software\Microsoft VS Code\bin;C:\Users\lenovo\AppData\Local\Microsoft\WindowsApps;;D:\software\PyCharm 2023.2.1\bin;
- PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
- PGADMIN_INT_KEY: bba24faa-87ca-4032-ba57-c333ec1dab1b
- PGADMIN_INT_PORT: 5050
- 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 183 Stepping 1, GenuineIntel
- PROCESSOR_LEVEL: 6
- PROCESSOR_REVISION: b701
- ProgramData: C:\ProgramData
- ProgramFiles: C:\Program Files
- ProgramFiles(x86): C:\Program Files (x86)
- ProgramW6432: C:\Program Files
- PROJ_LIB: D:\software\pgadmin\share\contrib\postgis-3.4\proj
- PSModulePath: C:\Program Files\WindowsPowerShell\Modules;C:\Windows\system32\WindowsPowerShell\v1.0\Modules
- PUBLIC: C:\Users\Public
- PyCharm: D:\software\PyCharm 2023.2.1\bin;
- SESSIONNAME: Console
- SystemDrive: C:
- SystemRoot: C:\Windows
- TEMP: C:\Users\lenovo\AppData\Local\Temp
- TMP: C:\Users\lenovo\AppData\Local\Temp
- USERDOMAIN: LAPTOP-2034COOG
- USERDOMAIN_ROAMINGPROFILE: LAPTOP-2034COOG
- USERNAME: lenovo
- USERPROFILE: C:\Users\lenovo
- windir: C:\Windows
- ZES_ENABLE_SYSMAN: 1
- __COMPAT_LAYER: DetectorsAppHealth
--------------------------------------------------------
Total spawn time to start the pgAdmin4 server: 0.017 Sec
Traceback (most recent call last):
File "D:\software\postgresql16\pgAdmin 4\web\pgAdmin4.py", line 104, in <module>
app = create_app()
^^^^^^^^^^^^
File "D:\software\postgresql16\pgAdmin 4\web\pgadmin\__init__.py", line 534, in create_app
driver.init_app(app)
File "D:\software\postgresql16\pgAdmin 4\web\pgadmin\utils\driver\__init__.py", line 27, in init_app
DriverRegistry.load_modules(app)
File "D:\software\postgresql16\pgAdmin 4\web\pgadmin\utils\driver\registry.py", line 20, in load_modules
from . import psycopg3 as module
File "D:\software\postgresql16\pgAdmin 4\web\pgadmin\utils\driver\psycopg3\__init__.py", line 21, in <module>
import psycopg
File "D:\software\postgresql16\pgAdmin 4\python\Lib\site-packages\psycopg\__init__.py", line 9, in <module>
from . import pq # noqa: F401 import early to stabilize side effects
^^^^^^^^^^^^^^^^
File "D:\software\postgresql16\pgAdmin 4\python\Lib\site-packages\psycopg\pq\__init__.py", line 114, in <module>
import_from_libpq()
File "D:\software\postgresql16\pgAdmin 4\python\Lib\site-packages\psycopg\pq\__init__.py", line 106, in import_from_libpq
raise ImportError(
ImportError: no pq wrapper available.
Attempts made:
- couldn't import psycopg 'c' implementation: DLL load failed while importing pq: �Ҳ���ָ����ģ�顣
- couldn't import psycopg 'binary' implementation: No module named 'psycopg_binary'
- couldn't import psycopg 'python' implementation: Could not find module 'libpq.dll' (or one of its dependencies). Try using the full path with constructor syntax.
