安装postgresql后，无法联系pgAdmin 4服务器

Question

安装postgres 13后，pgadmin4无法启动，出现以下错误：

无法联系 pgAdmin 4 服务器：

已尝试 ：

< li >以管理员身份运行 < li >将file://C:\ Program Files \ PostgreSQL \ 13 \ bin添加到路径变量中 < li >清理Appdata\roaming\pgadmin < li >重新启动计算机

错误仍然存在;以下是一些细节：

 pgAdmin Runtime Environment
--------------------------------------------------------
Python Path: "C:\Program Files\PostgreSQL\13\pgAdmin 4\python\python.exe"
Runtime Config File: "C:\Users\DZ001160\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\DZ001160\AppData\Roaming
  - ChocolateyInstall: C:\ProgramData\chocolatey
  - CHROME_CRASHPAD_PIPE_NAME: \\.\pipe\crashpad_4904_QRCYSGHVOIEQKPFC
  - CHROME_RESTART: NW.js|NW.js est bloqué. Voulez-vous le relancer maintenant ?|LEFT_TO_RIGHT
  - CommonProgramFiles: C:\Program Files\Common Files
  - CommonProgramFiles(x86): C:\Program Files (x86)\Common Files
  - CommonProgramW6432: C:\Program Files\Common Files
  - COMPUTERNAME: W10-PC0L10T3
  - ComSpec: C:\WINDOWS\system32\cmd.exe
  - DominoAddress: fr-algapppwv001.fr.ema.ad.pwcinternal.com
  - DominoName: DZ-ALGAPP000/DZ/Server/PwC
  - DriverData: C:\Windows\System32\Drivers\DriverData
  - HOMEDRIVE: C:
  - HOMEPATH: \Users\DZ001160
  - LOCALAPPDATA: C:\Users\DZ001160\AppData\Local
  - LOGONSERVER: \\FR-PARDIR002
  - NUMBER_OF_PROCESSORS: 4
  - NVM_HOME: C:\Users\DZ001160-ladm\AppData\Roaming\nvm
  - NVM_SYMLINK: C:\Program Files\nodejs
  - OneDrive: C:\Users\DZ001160\OneDrive
  - OPENSSL_CONF: C:\Program Files\PostgreSQL\psqlODBC\etc\openssl.cnf
  - OS: Windows_NT
  - Path: C:\Program Files (x86)\Zulu\zulu-8-jre\bin\;C:\Program Files\Zulu\zulu-8-jre\bin\;C:\Python39\Scripts\;C:\Python39\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\WINDOWS\System32\OpenSSH\;C:\Program Files (x86)\IBM\Notes\;C:\Program Files (x86)\ConfigMgr 2012 Toolkit R2\ClientTools;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\ProgramData\chocolatey\bin;C:\Program Files\dotnet\;C:\Program Files\Microsoft SQL Server\130\Tools\Binn\;C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\170\Tools\Binn\;C:\Users\DZ001160-ladm\AppData\Roaming\nvm;C:\Program Files\nodejs;C:\Program Files\nodejs\;C:\Users\DZ001160\AppData\Local\Microsoft\WindowsApps;C:\Users\DZ001160\AppData\Local\Programs\Git\cmd;C:\Users\DZ001160\AppData\Local\Gource\cmd;C:\Users\DZ001160\AppData\Roaming\npm
  - PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC;.PY;.PYW
  - PGADMIN_INT_KEY: 446e590b-3ac8-45a1-9d95-611e127071b0
  - PGADMIN_INT_PORT: 53846
  - PGADMIN_SERVER_MODE: OFF
  - POSTGRES: C:\Program Files\PostgreSQL\13\bin
  - PROCESSOR_ARCHITECTURE: AMD64
  - PROCESSOR_IDENTIFIER: Intel64 Family 6 Model 78 Stepping 3, GenuineIntel
  - PROCESSOR_LEVEL: 6
  - PROCESSOR_REVISION: 4e03
  - ProgramData: C:\ProgramData
  - ProgramFiles: C:\Program Files
  - ProgramFiles(x86): C:\Program Files (x86)
  - ProgramW6432: C:\Program Files
  - PROJ_LIB: C:\Program Files\PostgreSQL\13\share\contrib\postgis-3.1\proj
  - PSModulePath: C:\Program Files\WindowsPowerShell\Modules;C:\WINDOWS\system32\WindowsPowerShell\v1.0\Modules;C:\Program Files\Thycotic\Powershell\
  - PUBLIC: C:\Users\Public
  - SESSIONNAME: Console
  - SystemDrive: C:
  - SystemRoot: C:\WINDOWS
  - TEMP: C:\Users\DZ001160\AppData\Local\Temp
  - TMP: C:\Users\DZ001160\AppData\Local\Temp
  - UATDATA: C:\WINDOWS\CCM\UATData\D9F8C395-CAB8-491d-B8AC-179A1FE1BE77
  - USERDNSDOMAIN: FR.EMA.AD.PWCINTERNAL.COM
  - USERDOMAIN: FR
  - USERDOMAIN_ROAMINGPROFILE: FR
  - USERNAME: DZ001160
  - USERPROFILE: C:\Users\DZ001160
  - windir: C:\WINDOWS
--------------------------------------------------------

Traceback (most recent call last):
  File "C:\Program Files\PostgreSQL\13\pgAdmin 4\web\pgAdmin4.py", line 98, in <module>
    app = create_app()
  File "C:\Program Files\PostgreSQL\13\pgAdmin 4\web\pgadmin\__init__.py", line 347, in create_app
    if not os.path.exists(SQLITE_PATH) or get_version() == -1:
  File "C:\Program Files\PostgreSQL\13\pgAdmin 4\web\pgadmin\setup\db_version.py", line 19, in get_version
    return version.value
AttributeError: 'NoneType' object has no attribute 'value'

Answer 1

对于那些在MacOS上遇到错误的人，新版本的pgAdmin无法连接到旧pgAdmin上的数据库。对我来说，工作只是将文件夹~/.pgadmin重命名为其他东西。然后，新的 Pg 管理员将成功启动。

注1:使用< code >命令Shift。显示隐藏文件夹的快捷键。

注2：删除＜code＞~/。pgadmin导致丢失旧数据库连接。

Answer 2

我也有同样的失败。我似乎无法使pgAdmin 4工作。我在另一台笔记本电脑上安装了PostgreSQL，出现了pdAdmin 4，但出现了另一个故障。

Answer 3

解决方案适合我：

• 删除C：\用户\{用户名}\AppData\漫游\pgadmin
• 将C：\Program Files\PostgreSQL\13\bin添加到PATH系统环境变量
• 下载pgAdmin4 at：https://www.postgresql.org/ftp/pgadmin/pgadmin4/v5.2/windows/
• 下载Sql服务器：
  https://www.enterprisedb.com/downloads/postgres-postgresql-downloads.设置时，取消选中同时安装pgAdmin 4和StackBuilder。