时间戳

首页 > 解决方案 > Postgresql 不工作显示致命错误

python - Postgresql 不工作显示致命错误

问题描述

我正在尝试使用 Postgresql 作为我在 django 中制作的网站的数据库。但是，postgresql 和 pg-admin 工具安装时没有任何错误，我无法打开数据库。首先我认为这是兼容性问题，因为我的操作系统是 Windows 7 Ultimate，但后来我尝试安装所有以前版本的数据库，但它仍然无法打开。

我得到的错误是：

pgAdmin Runtime Environment
--------------------------------------------------------
Python Path: "C:\Program Files\PostgreSQL\13\pgAdmin 4\python\python.exe"
Runtime Config File: "C:\Users\Intel\AppData\Roaming\pgadmin\runtime_config.json"
pgAdmin Config File: "C:\Program Files\PostgreSQL\13\pgAdmin 4\web\config.py"
Webapp Path: "C:\Program Files\PostgreSQL\13\pgAdmin 4\web\pgAdmin4.py"
pgAdmin Command: "C:\Program Files\PostgreSQL\13\pgAdmin 4\python\python.exe -s C:\Program Files\PostgreSQL\13\pgAdmin 4\web\pgAdmin4.py"
Environment: 
  - ALLUSERSPROFILE: C:\ProgramData
  - APPDATA: C:\Users\Intel\AppData\Roaming
  - C:\Program Files\Java\jdk-16.0.1: C:\Program Files\Java\jdk-16.0.1\bin
  - CHROME_CRASHPAD_PIPE_NAME: \\.\pipe\crashpad_3400_DAGOSZHYAFRGHRAW
  - 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: INTEL-PC
  - ComSpec: C:\Windows\system32\cmd.exe
  - FP_NO_HOST_CHECK: NO
  - HOMEDRIVE: C:
  - HOMEPATH: \Users\Intel
  - JAVA_HOME: C:\Program Files\Java\jdk-16.0.1
  - JAVA_HOME: C:\Program Files\Java\jre1.8.0_291\bin\server\jvm.dll: PATH: C:\Program Files\Java\jre1.8.0_291\bin
  - LOCALAPPDATA: C:\Users\Intel\AppData\Local
  - LOGONSERVER: \\INTEL-PC
  - NUMBER_OF_PROCESSORS: 2
  - OS: Windows_NT
  - Path: C:\Program Files\Common Files\Oracle\Java\javapath;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\; C:\Program Files\Java\jdk-16.0.1\bin;C:\Users\Intel\AppData\Local\Programs\Python\Python37;C:\Users\Intel\AppData\Local\Programs\Python\Python37\Scripts;C:\Program Files\PostgreSQL\13\bin;;C:\Program Files\JetBrains\PyCharm 2021.1.2\bin;;F:\Microsoft VS Code\bin
  - PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
  - PGADMIN_INT_KEY: ce0fb81d-5e4a-48d7-8976-49a0e405e06d
  - PGADMIN_INT_PORT: 49340
  - PGADMIN_SERVER_MODE: OFF
  - PROCESSOR_ARCHITECTURE: AMD64
  - PROCESSOR_IDENTIFIER: Intel64 Family 6 Model 15 Stepping 13, GenuineIntel
  - PROCESSOR_LEVEL: 6
  - PROCESSOR_REVISION: 0f0d
  - ProgramData: C:\ProgramData
  - ProgramFiles: C:\Program Files
  - ProgramFiles(x86): C:\Program Files (x86)
  - ProgramW6432: C:\Program Files
  - PSModulePath: C:\Windows\system32\WindowsPowerShell\v1.0\Modules\
  - PUBLIC: C:\Users\Public
  - PyCharm: C:\Program Files\JetBrains\PyCharm 2021.1.2\bin;
  - SESSIONNAME: Console
  - SystemDrive: C:
  - SystemRoot: C:\Windows
  - TEMP: C:\Users\Intel\AppData\Local\Temp
  - TMP: C:\Users\Intel\AppData\Local\Temp
  - USERDOMAIN: Intel-PC
  - USERNAME: Intel
  - USERPROFILE: C:\Users\Intel
  - windir: C:\Windows
  - windows_tracing_flags: 3
  - windows_tracing_logfile: C:\BVTBin\Tests\installpackage\csilogfile.log
--------------------------------------------------------

Traceback (most recent call last):
  File "C:\Program Files\PostgreSQL\13\pgAdmin 4\web\pgAdmin4.py", line 16, in <module>
    from cheroot.wsgi import Server as CherootServer
  File "C:\Program Files\PostgreSQL\13\pgAdmin 4\python\lib\site-packages\cheroot\wsgi.py", line 36, in <module>
    from . import server
  File "C:\Program Files\PostgreSQL\13\pgAdmin 4\python\lib\site-packages\cheroot\server.py", line 70, in <module>
    import email.utils
  File "<frozen zipimport>", line 259, in load_module
  File "email\utils.py", line 29, in <module>
  File "<frozen zipimport>", line 259, in load_module
  File "socket.py", line 49, in <module>
ImportError: DLL load failed while importing _socket: The parameter is incorrect.

我应该怎么办？？

标签： pythondjangopgadmin

解决方案

通过在我的 win 2008R2 SP1 上安装包含 KB2533623 的 Microsoft 安全更新 KB3063858 并在此之后重新安装 pgAdmin，我能够解决相同的问题。Microsoft 网站上的 Win 7 也有相同的更新。

推荐阅读