Re: pgadmin4 doesn't work since v5.0 on Windows

Keith <keith@xxxxxxxxxxx> · Mon, 21 Jun 2021 09:29:24 -0400

On Mon, Jun 21, 2021 at 7:37 AM Sirop L <scirop@xxxxxxxxx> wrote:
Hi,

On several servers we're not able to user pgadmin 4 v5.xx
For the v4.xx no problems.
But with the v5.0 to 5.4, if the postgres server"s is not installed on the same computer, whatever we do we have troubles at the connection.

Each tim I try to launch pg admin ,I got a message like this one.
(It not mine it's copied from a thread):

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

I'vve seen plenty of threads upon the internet about this issue.
they say to delete the db file, the profil's postgres folder... to reinstall postgre (witch I do not want to)
Sometimes, it's said to install third applications (I think i ve seen to install another bdd server :-)

But I can't figure how to solve my problem...

Have you got an idea?

Regards.

Cyril

Please try the pgAdmin mailing list directly. This is a general pg administration mailing list.

https://www.pgadmin.org/support/list/

Keith