pgAdmin 4启动报错:导入_greenlet时DLL加载失败求助
PostgreSQL 16 + pgAdmin 4 Windows环境启动失败(_greenlet DLL加载错误)
我之前只用过MongoDB这类NoSQL数据库,近期为新项目开始接触PostgreSQL。从官网下载Windows版安装包后,pgAdmin 4 GUI使用完全正常,能创建表、测试查询等操作。
直到某天,pgAdmin突然反复要求输入密码,提示会话过期。我尝试卸载重装来清理损坏文件,结果问题反而更严重:重装后启动pgAdmin 4,长时间加载后弹出如下错误:
pgAdmin Runtime Environment -------------------------------------------------------- Python Path: "C:\Program Files\PostgreSQL\16\pgAdmin 4\python\python.exe" Runtime Config File: "C:\Users\franc\AppData\Roaming\pgadmin\runtime_config.json" pgAdmin Config File: "C:\Program Files\PostgreSQL\16\pgAdmin 4\web\config.py" Webapp Path: "C:\Program Files\PostgreSQL\16\pgAdmin 4\web\pgAdmin4.py" pgAdmin Command: "C:\Program Files\PostgreSQL\16\pgAdmin 4\python\python.exe -s C:\Program Files\PostgreSQL\16\pgAdmin 4\web\pgAdmin4.py" Environment: - ALLUSERSPROFILE: C:\ProgramData - APPDATA: C:\Users\franc\AppData\Roaming - CHROME_CRASHPAD_PIPE_NAME: \\.\pipe\crashpad_7644_DRSMLIYWYIBRTUGW - CHROME_RESTART: NW.js|Spiacenti, si è verificato un arresto anomalo di NW.js. Riavviarlo ora?|LEFT_TO_RIGHT - CommonProgramFiles: C:\Program Files\Common Files - CommonProgramFiles(x86): C:\Program Files (x86)\Common Files - CommonProgramW6432: C:\Program Files\Common Files - COMPUTERNAME: PCXXX - ComSpec: C:\Windows\system32\cmd.exe - DriverData: C:\Windows\System32\Drivers\DriverData - EFC_6464: 1 - FPS_BROWSER_APP_PROFILE_STRING: Internet Explorer - FPS_BROWSER_USER_PROFILE_STRING: Default - HOMEDRIVE: C: - HOMEPATH: \Users\franc - IntelliJ IDEA: C:\Program Files\JetBrains\IntelliJ IDEA 2023.1.2\bin; - IntelliJ IDEA Community Edition: C:\Program Files\JetBrains\IntelliJ IDEA Community Edition 2023.1.2\bin; - JAVA_HOME: C:\Program Files\Java\jdk-20 - LOCALAPPDATA: C:\Users\franc\AppData\Local - LOGONSERVER: \\PCXXX - NUMBER_OF_PROCESSORS: 8 - OneDrive: C:\Users\franc\OneDrive - OS: Windows_NT - Path: C:\Program Files\PostgreSQL\16\pgAdmin 4\runtime;C:\Program Files\Common Files\Oracle\Java\javapath;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\OpenSSH\;C:\Program Files\nodejs\;C:\Program Files\Git\cmd;C:\Users\franc\.console-ninja\.bin;C:\Users\franc\AppData\Local\Programs\Python\Python311\Scripts\;C:\Users\franc\AppData\Local\Programs\Python\Python311\;C:\Users\franc\AppData\Local\Microsoft\WindowsApps;C:\Users\franc\AppData\Local\Programs\Microsoft VS Code\bin;C:\msys64\usr\bin;C:\MinGW\bin;;C:\Program Files\JetBrains\IntelliJ IDEA Community Edition 2023.1.2\bin;;C:\Program Files\JetBrains\IntelliJ IDEA 2023.1.2\bin;;C:\Users\franc\AppData\Roaming\npm;C:\Program Files\heroku\bin;C:\Users\franc\AppData\Local\Programs\mongosh\ - PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC - PGADMIN_INT_KEY: 11ce715e-53fb-4267-9039-fdb7f31c92a5 - PGADMIN_INT_PORT: 50386 - PGADMIN_SERVER_MODE: OFF - PROCESSOR_ARCHITECTURE: AMD64 - PROCESSOR_IDENTIFIER: AMD64 Family 23 Model 104 Stepping 1, AuthenticAMD - PROCESSOR_LEVEL: 23 - PROCESSOR_REVISION: 6801 - 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\franc\AppData\Local\Temp - TMP: C:\Users\franc\AppData\Local\Temp - USERDOMAIN: PCXXX - USERDOMAIN_ROAMINGPROFILE: PCXXX - USERNAME: franc - USERPROFILE: C:\Users\franc - VBOX_MSI_INSTALL_PATH: C:\Program Files\Oracle\VirtualBox\ - windir: C:\Windows -------------------------------------------------------- Total spawn time to start the pgAdmin4 server: 0.014 Sec Traceback (most recent call last): File "C:\Program Files\PostgreSQL\16\pgAdmin 4\web\pgAdmin4.py", line 104, in <module> app = create_app() ^^^^^^^^^^^^ File "C:\Program Files\PostgreSQL\16\pgAdmin 4\web\pgadmin\__init__.py", line 760, in create_app app.register_blueprint(module) File "C:\Program Files\PostgreSQL\16\pgAdmin 4\python\Lib\site-packages\flask\scaffold.py", line 50, in wrapper_func return f(self, *args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Program Files\PostgreSQL\16\pgAdmin 4\python\Lib\site-packages\flask\app.py", line 1299, in register_blueprint blueprint.register(self, options) File "C:\Program Files\PostgreSQL\16\pgAdmin 4\web\pgadmin\tools\__init__.py", line 52, in register from .psql import blueprint as module File "C:\Program Files\PostgreSQL\16\pgAdmin 4\web\pgadmin\tools\psql\__init__.py", line 15, in <module> from eventlet.green import subprocess File "C:\Program Files\PostgreSQL\16\pgAdmin 4\python\Lib\site-packages\eventlet\__init__.py", line 17, in <module> from eventlet import convenience File "C:\Program Files\PostgreSQL\16\pgAdmin 4\python\Lib\site-packages\eventlet\convenience.py", line 4, in <module> from eventlet import greenpool File "C:\Program Files\PostgreSQL\16\pgAdmin 4\python\Lib\site-packages\eventlet\greenpool.py", line 4, in <module> from eventlet import queue File "C:\Program Files\PostgreSQL\16\pgAdmin 4\python\Lib\site-packages\eventlet\queue.py", line 49, in <module> from eventlet.event import Event File "C:\Program Files\PostgreSQL\16\pgAdmin 4\python\Lib\site-packages\eventlet\event.py", line 3, in <module> from eventlet import hubs File "C:\Program Files\PostgreSQL\16\pgAdmin 4\python\Lib\site-packages\eventlet\hubs\__init__.py", line 7, in <module> from eventlet.support import greenlets as greenlet File "C:\Program Files\PostgreSQL\16\pgAdmin 4\python\Lib\site-packages\eventlet\support\__init__.py", line 6, in <module> from eventlet.support import greenlets File "C:\Program Files\PostgreSQL\16\pgAdmin 4\python\Lib\site-packages\eventlet\support\greenlets.py", line 3, in <module> import greenlet File "C:\Program Files\PostgreSQL\16\pgAdmin 4\python\Lib\site-packages\greenlet\__init__.py", line 29, in <module> from ._greenlet import _C_API # pylint:disable=no-name-in-module ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ ImportError: DLL load failed while importing _greenlet: Impossibile trovare il modulo specificato.
我在网上搜索相关解决方案,但结果极少且说明模糊,多次卸载重装PostgreSQL及pgAdmin后问题仍未解决,恳请有相同经历的用户提供帮助。
内容的提问来源于stack exchange,提问作者fmerighi
相关产品推荐
相关产品推荐

