致命错误:无法联系pgAdmin 4服务器



我已经安装了PostgreSQL 14.1和pgAdmin4 6.4。当我尝试运行pgAdmin 4时,我得到了一个致命的错误";无法联系pgAdmin 4服务器";。我试过以管理员身份运行它,并在";C: \Users\User\AppData\Roaming\pgAdmin,我确信PostgreSQL服务器正在运行,因为它在services.msc上的服务正在运行。

以下是运行pgAdmin4的日志。我可以看到这里出了问题,但我不知道如何解决这个问题:

pgAdmin Runtime Environment
--------------------------------------------------------
Python Path: "C:Program FilespgAdmin 4v6pythonpython.exe"
Runtime Config File: "C:UsersmiloscvjAppDataRoamingpgadminruntime_config.json"
pgAdmin Config File: "C:Program FilespgAdmin 4v6webconfig.py"
Webapp Path: "C:Program FilespgAdmin 4v6webpgAdmin4.py"
pgAdmin Command: "C:Program FilespgAdmin 4v6pythonpython.exe -s C:Program FilespgAdmin 4v6webpgAdmin4.py"
Environment: 
- ALLUSERSPROFILE: C:ProgramData
- APPDATA: C:UsersmiloscvjAppDataRoaming
- CHROME_CRASHPAD_PIPE_NAME: \.pipecrashpad_6036_OOREQHHBCDZZAVHT
- CHROME_RESTART: NW.js|Whoa! NW.js has crashed. Relaunch now?|LEFT_TO_RIGHT
- CommonProgramFiles: C:Program FilesCommon Files
- CommonProgramFiles(x86): C:Program Files (x86)Common Files
- CommonProgramW6432: C:Program FilesCommon Files
- COMPUTERNAME: MILOSCVJPC
- ComSpec: C:Windowssystem32cmd.exe
- DriverData: C:WindowsSystem32DriversDriverData
- ESET_OPTIONS:                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                
- HOMEDRIVE: C:
- HOMEPATH: Usersmiloscvj
- JAVA_HOME: C:Program FilesAdoptOpenJDKjre-8.0.265.01-hotspot
- JD2_HOME: C:UsersmiloscvjAppDataLocalJDownloader 2.0
- LOCALAPPDATA: C:UsersmiloscvjAppDataLocal
- LOGONSERVER: \MILOSCVJPC
- NUMBER_OF_PROCESSORS: 4
- OneDrive: C:UsersmiloscvjOneDrive
- OneDriveConsumer: C:UsersmiloscvjOneDrive
- OS: Windows_NT
- Path: C:Program Files (x86)Common FilesOracleJavajavapath;C:Windowssystem32;C:Windows;C:WindowsSystem32Wbem;C:WindowsSystem32WindowsPowerShellv1.0;C:WindowsSystem32OpenSSH;C:Program Files (x86)Javajre1.8.0_261bin;C:Program Files (x86)Javajdk1.8.0_261bin;C:Program FilesPuTTY;C:UsersmiloscvjAppDataLocalProgramsPythonPython39Scripts;C:UsersmiloscvjAppDataLocalProgramsPythonPython39;C:UsersmiloscvjAppDataLocalMicrosoftWindowsApps;C:UsersmiloscvjAppDataLocalProgramsMicrosoft VS Codebin
- PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
- PGADMIN_INT_KEY: 57d2b65d-0a0b-4650-b1c3-812570ba5026
- PGADMIN_INT_PORT: 1310
- PGADMIN_SERVER_MODE: OFF
- PROCESSOR_ARCHITECTURE: AMD64
- PROCESSOR_IDENTIFIER: Intel64 Family 6 Model 23 Stepping 10, GenuineIntel
- PROCESSOR_LEVEL: 6
- PROCESSOR_REVISION: 170a
- ProgramData: C:ProgramData
- ProgramFiles: C:Program Files
- ProgramFiles(x86): C:Program Files (x86)
- ProgramW6432: C:Program Files
- PSModulePath: C:Program FilesWindowsPowerShellModules;C:Windowssystem32WindowsPowerShellv1.0Modules
- PUBLIC: C:UsersPublic
- SystemDrive: C:
- SystemRoot: C:Windows
- TEMP: C:UsersmiloscvjAppDataLocalTemp
- TMP: C:UsersmiloscvjAppDataLocalTemp
- USERDOMAIN: MILOSCVJPC
- USERDOMAIN_ROAMINGPROFILE: MILOSCVJPC
- USERNAME: miloscvj
- USERPROFILE: C:Usersmiloscvj
- VBOX_MSI_INSTALL_PATH: C:Program FilesOracleVirtualBox
- windir: C:Windows
- __COMPAT_LAYER: Installer
--------------------------------------------------------
Traceback (most recent call last):
File "C:Program FilespgAdmin 4v6webpgAdmin4.py", line 39, in <module>
import config
File "C:Program FilespgAdmin 4v6webconfig.py", line 25, in <module>
from pgadmin.utils import env, IS_WIN, fs_short_path
File "C:Program FilespgAdmin 4v6webpgadmin__init__.py", line 24, in <module>
from flask_socketio import SocketIO
File "C:Program FilespgAdmin 4v6pythonlibsite-packagesflask_socketio__init__.py", line 9, in <module>
from socketio import socketio_manage  # noqa: F401
File "C:Program FilespgAdmin 4v6pythonlibsite-packagessocketio__init__.py", line 3, in <module>
from .client import Client
File "C:Program FilespgAdmin 4v6pythonlibsite-packagessocketioclient.py", line 7, in <module>
import engineio
File "C:Program FilespgAdmin 4v6pythonlibsite-packagesengineio__init__.py", line 3, in <module>
from .client import Client
File "C:Program FilespgAdmin 4v6pythonlibsite-packagesengineioclient.py", line 12, in <module>
import requests
File "C:Program FilespgAdmin 4v6pythonlibsite-packagesrequests__init__.py", line 118, in <module>
from . import utils
File "C:Program FilespgAdmin 4v6pythonlibsite-packagesrequestsutils.py", line 25, in <module>
from . import certs
File "C:Program FilespgAdmin 4v6pythonlibsite-packagesrequestscerts.py", line 15, in <module>
from certifi import where
File "<frozen importlib._bootstrap>", line 1027, in _find_and_load
File "<frozen importlib._bootstrap>", line 1006, in _find_and_load_unlocked
File "<frozen importlib._bootstrap>", line 672, in _load_unlocked
File "<frozen importlib._bootstrap>", line 632, in _load_backward_compatible
File "C:Program FilespgAdmin 4v6pythonlibsite-packageswraptimporter.py", line 157, in load_module
notify_module_loaded(module)
File "C:Program FilespgAdmin 4v6pythonlibsite-packageswraptdecorators.py", line 469, in _synchronized
return wrapped(*args, **kwargs)
File "C:Program FilespgAdmin 4v6pythonlibsite-packageswraptimporter.py", line 135, in notify_module_loaded
hook(module)
File "C:Program FilespgAdmin 4v6pythonlibsite-packagescertifi_win32wrapt_certifi.py", line 27, in apply_patches
generate_pem()
File "C:Program FilespgAdmin 4v6pythonlibsite-packagescertifi_win32wincerts.py", line 121, in generate_pem
for pem in get_pems():
File "C:Program FilespgAdmin 4v6pythonlibsite-packagescertifi_win32wincerts.py", line 41, in get_pems
ssl_context = ssl.create_default_context()
File "ssl.py", line 770, in create_default_context
File "ssl.py", line 591, in load_default_certs
File "ssl.py", line 583, in _load_windows_store_certs
ssl.SSLError: [ASN1] nested asn1 error (_ssl.c:3992)

解决方案:

删除会话记录C:UsersDellAppDataLocalpgadmin4User DataDefaultSessions然后重新启动第4页管理

最新更新