Como a falha ocorre?
Ao abrir o pgAdmin4 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.db
Como corrigir?
-
No servidor acesse o caminho C:\Users\?\AppData\Roaming\pgAdmin e localize o arquivo pgadmin4.db
-
Renomeie o arquivo pgadmin4.db e reinicie o serviço postgresql-x64-17.
-
Execute o pg4admin como administrador e assim será sanado.
Caso no caminho mencionado não possua o arquivo pgadmin4.db, reinstale o pgAdmin4.
Para maiores informações, acesse: I1178 - Como baixar e instalar o PgAdmin4