Como a falha ocorre?
Ao abrir o pg4admin no servidor apresenta falha:
"
pgAdmin Runtime Environment
--------------------------------------------------------
Python Path: "C:\Users\simon\AppData\Local\Programs\pgAdmin 4\python\python.exe"
Runtime Config File: "C:\Users\simon\AppData\Roaming\pgadmin4\config.json"
Webapp Path: "C:\Users\simon\AppData\Local\Programs\pgAdmin 4\web\pgAdmin4.py"
pgAdmin Command: "C:\Users\simon\AppData\Local\Programs\pgAdmin 4\python\python.exe -s C:\Users\simon\AppData\Local\Programs\pgAdmin 4\web\pgAdmin4.py"
Environment:
- ALLUSERSPROFILE: C:\ProgramData
- APPDATA: C:\Users\simon\AppData\Roaming
- CommonProgramFiles: C:\Program Files\Common Files
- CommonProgramFiles(x86): C:\Program Files (x86)\Common Files
- CommonProgramW6432: C:\Program Files\Common Files
- COMPUTERNAME: SIMONEBR
- ComSpec: C:\windows\system32\cmd.exe
- DriverData: C:\Windows\System32\Drivers\DriverData
- EFC_15076_1592913036: 1
- ELECTRON_ENABLE_SECURITY_WARNINGS: false
- HOMEDRIVE: C:
- HOMEPATH: \Users\simon
- LOCALAPPDATA: C:\Users\simon\AppData\Local
- LOGONSERVER: \\SIMONEBR
- MOSQUITTO_DIR: C:\Program Files (x86)\mosquitto
- NUMBER_OF_PROCESSORS: 12
- OneDrive: C:\Users\simon\OneDrive
- OneDriveConsumer: C:\Users\simon\OneDrive
- OS: Windows_NT
- Path: C:\Users\simon\AppData\Local\Programs\pgAdmin 4\runtime;C:\Program Files (x86)\Common Files\Oracle\Java\java8path;C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\Program Files (x86)\Pervasive Software\PSQL\bin\;C:\windows\system32;C:\windows;C:\windows\System32\Wbem;C:\windows\System32\WindowsPowerShell\v1.0\;C:\windows\System32\OpenSSH\;C:\Program Files\dotnet\;C:\Program Files (x86)\Microsoft SQL Server\160\Tools\Binn\;C:\Program Files\Microsoft SQL Server\160\Tools\Binn\;C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\170\Tools\Binn\;C:\Program Files\Microsoft SQL Server\160\DTS\Binn\;C:\Users\simon\AppData\Local\Microsoft\WindowsApps;C:\Users\simon\AppData\Local\PowerToys\DSCModules\
- PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
- PGADMIN_INT_KEY: f0eae297-57fe-4592-8e38-ac729735c449
- PGADMIN_INT_PORT: 5433
- PGADMIN_SERVER_MODE: OFF
- PROCESSOR_ARCHITECTURE: AMD64
- PROCESSOR_IDENTIFIER: Intel64 Family 6 Model 186 Stepping 3, GenuineIntel
- PROCESSOR_LEVEL: 6
- PROCESSOR_REVISION: ba03
- ProgramData: C:\ProgramData
- ProgramFiles: C:\Program Files
- ProgramFiles(x86): C:\Program Files (x86)
- ProgramW6432: C:\Program Files
- PSModulePath: C:\Program Files\WindowsPowerShell\Modules;C:\windows\system32\WindowsPowerShell\v1.0\Modules;C:\Program Files (x86)\Microsoft SQL Server\160\Tools\PowerShell\Modules\
- PUBLIC: C:\Users\Public
- PYTHONDONTWRITEBYTECODE: 1
- SESSIONNAME: Console
- SystemDrive: C:
- SystemRoot: C:\windows
- TEMP: C:\Users\simon\AppData\Local\Temp
- TMP: C:\Users\simon\AppData\Local\Temp
- USERDOMAIN: SIMONEBR
- USERDOMAIN_ROAMINGPROFILE: SIMONEBR
- USERNAME: simon
- USERPROFILE: C:\Users\simon
- windir: C:\windows
--------------------------------------------------------
Total spawn time to start the pgAdmin4 server: 0.013 Sec
2026-04-13 15:38:37,041: ERROR pgadmin: Table(s) ['application_state', 'sharedserver', 'macros', 'user_macros', 'user_mfa'] are missing in the database
Traceback (most recent call last):
File "C:\Users\simon\AppData\Local\Programs\pgAdmin 4\web\pgAdmin4.py", line 93, in <module>
app = create_app()
File "C:\Users\simon\AppData\Local\Programs\pgAdmin 4\web\pgadmin\__init__.py", line 478, in create_app
run_migration_for_sqlite()
~~~~~~~~~~~~~~~~~~~~~~~~^^
File "C:\Users\simon\AppData\Local\Programs\pgAdmin 4\web\pgadmin\__init__.py", line 443, in run_migration_for_sqlite
backup_db_file()
~~~~~~~~~~~~~~^^
File "C:\Users\simon\AppData\Local\Programs\pgAdmin 4\web\pgadmin\__init__.py", line 372, in backup_db_file
os.rename(SQLITE_PATH, backup_file_name)
~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PermissionError: [WinError 32] O arquivo j? est? sendo usado por outro processo: 'C:\\Users\\simon\\AppData\\Roaming\\pgAdmin\\pgadmin4.db' -> 'C:\\Users\\simon\\AppData\\Roaming\\pgAdmin\\pgadmin4.db.20260413153837'
"
A falha ocorre pois será necessário criar novo arquivo pgAdmin4.
Como corrigir?
- No servidor acesse o caminho C:\Users\?\AppData\Roaming\pgAdmin e localize o arquivo pgadmin4.db
2. Renomeie o arquivo pgadmin4.db e reinicie o serviço postgresql-x64-17.
3. Execute o pg4admin como administrador e assim será sanado.
