安装postgresql后无法联系到pgAdmin 4服务器
安装postgresql后无法联系到pgAdmin 4服务器
提问于 2021-05-16 13:41:28
安装postgres 13之后，pgadmin4无法启动，出现以下错误：
无法联系到pgAdmin 4服务器：
已试过：
作为administrator
- Adding file://C:\Program文件运行
- \PostgreSQL\13\bin到path variable
- Cleaning Appdata\roaming\pgadmin
- Restarting computer
错误仍然存在；下面是一些详细信息：
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'回答 3
Stack Overflow用户
回答已采纳
发布于 2021-05-19 09:56:13
解决方案对我来说是可行的：
删除C：\ {username}\AppData\Roaming\pgadmin
- Adding \ variable
- Download C:\Program \PostgreSQL\13\bin到路径系统环境variable
- Download pgAdmin4 at：https://www.postgresql.org/ftp/pgadmin/pgadmin4/v5.2/windows/
- Download Sql server的
- ：
https://www.enterprisedb.com/downloads/postgres-postgresql-downloads。设置时，请取消选中安装StackBuilder. 4和pgAdmin 4
Stack Overflow用户
发布于 2021-05-17 21:19:30
我也有同样的失败。我似乎无法使pgAdmin 4工作。我在另一台笔记本上安装了PostgreSQL，pdAdmin 4出现了，但后来出现了不同的故障。
Stack Overflow用户
发布于 2022-08-09 12:25:42
对于那些在MacOS上出错的人来说，新版本的pgAdmin无法连接到旧pgAdmin上的数据库。对我来说，Workarount只是将文件夹~/.pgadmin重命名为其他东西。然后，新的PgAdmin将成功启动。
Note1:使用
Command + Shift + .快捷键显示隐藏文件夹。Note2:删除~/.pgadmin结果以丢失旧的数据库连接。
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/67557374
复制相关文章
相似问题
腾讯云开发者
