I’m experiencing issues with pgAdmin 4 on my Azure Windows server. Here are the details:
Steps I have taken:
- I have set up the necessary environment variables.
- I am running pgAdmin as an administrator.
- I checked the config_local.py file and verified that the server settings are correct.
- I ensured that the Windows Firewall allows inbound
- traffic on port 5050.
When I attempt to open pgAdmin 4, I receive the following error message:
pgAdmin Runtime Environment
Python Path: "C:Program FilesPostgreSQL16pgAdmin 4pythonpython.exe"
Runtime Config File: "C:Usersmecwin-mkrAppDataRoamingpgadmin4config.json"
Webapp Path: "C:Program FilesPostgreSQL16pgAdmin 4webpgAdmin4.py"
pgAdmin Command: "C:Program FilesPostgreSQL16pgAdmin 4pythonpython.exe -s C:Program FilesPostgreSQL16pgAdmin 4webpgAdmin4.py"
Environment:
- ALLUSERSPROFILE: C:ProgramData
- APPDATA: C:Usersmecwin-mkrAppDataRoaming
- ChocolateyInstall: C:ProgramDatachocolatey
- ChocolateyLastPathUpdate: 133693982423429714
- CLIENTNAME: DESKTOP-N4D9OJT
- CommonProgramFiles: C:Program FilesCommon Files
- CommonProgramFiles(x86): C:Program Files (x86)Common Files
- CommonProgramW6432: C:Program FilesCommon Files
- COMPUTERNAME: Mecwin-Nethra-M
- ComSpec: C:Windowssystem32cmd.exe
- DriverData: C:WindowsSystem32DriversDriverData
- ELECTRON_ENABLE_SECURITY_WARNINGS: false
- HOMEDRIVE: C:
- HOMEPATH: Usersmecwin-mkr
- LOCALAPPDATA: C:Usersmecwin-mkrAppDataLocal
- LOGONSERVER: Mecwin-Nethra-M
- NUMBER_OF_PROCESSORS: 2
- ORIGINAL_XDG_CURRENT_DESKTOP: undefined
- OS: Windows_NT
- Path: C:Program FilesPostgreSQL16pgAdmin 4runtime;C:Program FilesPostgreSQL16pgAdmin 4runtime;C:Windowssystem32;C:Windows;C:WindowsSystem32Wbem;C:WindowsSystem32WindowsPowerShellv1.0;C:WindowsSystem32OpenSSH;C:Program Filesdotnet;C:Program Filesnodejs;C:ProgramDatachocolateybin;C:Program FilesPostgreSQL17bin;C:Usersmecwin-mkrAppDataLocalProgramsPythonPython312python.exe;C:Usersmecwin-mkrAppDataLocalProgramsPythonPython312;C:Usersmecwin-mkrAppDataLocalProgramsPythonPython312Scripts;C:Usersmecwin-mkrAppDataLocalProgramsPythonLauncher;C:Usersmecwin-mkrAppDataLocalMicrosoftWindowsApps;C:Usersmecwin-mkrAppDataRoamingnpm;C:Usersmecwin-mkrAppDataLocalProgramsMicrosoft VS Codebin
- PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
- PGADMIN_INT_KEY: 87666d01-4c50-4dc2-b2fb-33ba21adeacb
- PGADMIN_INT_PORT: 63821
- PGADMIN_SERVER_MODE: OFF
- PROCESSOR_ARCHITECTURE: AMD64
- PROCESSOR_IDENTIFIER: Intel64 Family 6 Model 106 Stepping 6, GenuineIntel
- PROCESSOR_LEVEL: 6
- PROCESSOR_REVISION: 6a06
- 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
- PYTHONPATH: C:Program FilesPostgreSQL16pgAdmin 4python
- SESSIONNAME: RDP-Tcp#0
- SystemDrive: C:
- SystemRoot: C:Windows
- TEMP: C:UsersMECWIN~1AppDataLocalTemp2
- TMP: C:UsersMECWIN~1AppDataLocalTemp2
- USERDOMAIN: Mecwin-Nethra-M
- USERDOMAIN_ROAMINGPROFILE: Mecwin-Nethra-M
- USERNAME: mecwin-mkr
- USERPROFILE: C:Usersmecwin-mkr
- windir: C:Windows
Total spawn time to start the pgAdmin4 server: 0.014 Sec
2024-09-18 12:51:19,997: ERROR pgadmin: Table(s) ['query_history', 'database', 'sharedserver', 'macros', 'user_macros', 'user_mfa'] are missing in the database
Traceback (most recent call last):
File "C:Program FilesPostgreSQL16pgAdmin 4webpgAdmin4.py", line 103, in <module>
app = create_app()
^^^^^^^^^^^^
File "C:Program FilesPostgreSQL16pgAdmin 4webpgadmin__init__.py", line 473, in create_app
run_migration_for_sqlite()
File "C:Program FilesPostgreSQL16pgAdmin 4webpgadmin__init__.py", line 440, in run_migration_for_sqlite
backup_db_file()
File "C:Program FilesPostgreSQL16pgAdmin 4webpgadmin__init__.py", line 368, in backup_db_file
os.rename(SQLITE_PATH, backup_file_name)
PermissionError: [WinError 32] The process cannot access the file because it is being used by another process: 'C:\Users\mecwin-mkr\AppData\Roaming\pgAdmin\pgadmin4.db' -> 'C:\Users\mecwin-mkr\AppData\Roaming\pgAdmin\pgadmin4.db.20240918125119'