Boa tarde
Eu fiz a instalação do PostgreSQL.
Após que é acessado o o pgAdmin4, apresenta o seguinte erro a seguir:
The pgAdmin 4 server could not be contacted:
pgAdmin Runtime Environment
Python Path: "C:\Program Files\PostgreSQL\16\pgAdmin 4\python\python.exe" Runtime Config File: "C:\Users\User\AppData\Roaming\pgadmin\runtime_config.json" pgAdmin Config File: "C:\Program Files\PostgreSQL\16\pgAdmin 4\web\config.py" Webapp Path: "C:\Program Files\PostgreSQL\16\pgAdmin 4\web\pgAdmin4.py" pgAdmin Command: "C:\Program Files\PostgreSQL\16\pgAdmin 4\python\python.exe -s C:\Program Files\PostgreSQL\16\pgAdmin 4\web\pgAdmin4.py" Environment: - ALLUSERSPROFILE: C:\ProgramData - APPDATA: C:\Users\User\AppData\Roaming - CHROME_CRASHPAD_PIPE_NAME: \.\pipe\crashpad_9992_UUYHQEKPOQDJIDBP - CHROME_RESTART: NW.js|O NW.js travou. Reiniciar agora?|LEFT_TO_RIGHT - CM2014DIR: C:\Program Files (x86)\Common Files\Autodesk Shared\Materials - CommonProgramFiles: C:\Program Files\Common Files - CommonProgramFiles(x86): C:\Program Files (x86)\Common Files - CommonProgramW6432: C:\Program Files\Common Files - COMPUTERNAME: ALAN - ComSpec: C:\WINDOWS\system32\cmd.exe - DriverData: C:\Windows\System32\Drivers\DriverData - FPS_BROWSER_APP_PROFILE_STRING: Internet Explorer - FPS_BROWSER_USER_PROFILE_STRING: Default - FP_NO_HOST_CHECK: NO - HOMEDRIVE: C: - HOMEPATH: \Users\User - ILBDIR: C:\Program Files (x86)\Common Files\Autodesk Shared\Materials - LOCALAPPDATA: C:\Users\User\AppData\Local - LOGONSERVER: \ALAN - NUMBER_OF_PROCESSORS: 4 - OneDrive: C:\Users\User\OneDrive - OS: Windows_NT - Path: C:\Program Files\PostgreSQL\16\pgAdmin 4\runtime;C:\Program Files (x86)\Intel\iCLS Client;C:\Program Files\Intel\iCLS Client;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files (x86)\ATI Technologies\ATI.ACE\Core-Static;C:\Program Files\Acer\Remote Files;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0;C:\WINDOWS\System32\OpenSSH;C:\Program Files\Git\cmd;C:\Program Files\GitHub CLI;C:\Program Files\nodejs;C:\Users\User\AppData\Local\Microsoft\WindowsApps;C:\Users\User\AppData\Local\Programs\Microsoft VS Code\bin;C:\Users\User\AppData\Roaming\npm - PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC - PGADMIN_INT_KEY: d55556d6-21fb-4708-a696-e730789858b2 - PGADMIN_INT_PORT: 54320 - PGADMIN_SERVER_MODE: OFF - PROCESSOR_ARCHITECTURE: AMD64 - PROCESSOR_IDENTIFIER: Intel64 Family 6 Model 69 Stepping 1, GenuineIntel - PROCESSOR_LEVEL: 6 - PROCESSOR_REVISION: 4501 - ProgramData: C:\ProgramData - ProgramFiles: C:\Program Files - ProgramFiles(x86): C:\Program Files (x86) - ProgramW6432: C:\Program Files - PSModulePath: C:\WINDOWS\system32\WindowsPowerShell\v1.0\Modules - PUBLIC: C:\Users\Public - SESSIONNAME: Console - SystemDrive: C: - SystemRoot: C:\WINDOWS - TEMP: C:\Users\User\AppData\Local\Temp - TMP: C:\Users\User\AppData\Local\Temp - USERDOMAIN: Alan - USERDOMAIN_ROAMINGPROFILE: Alan - USERNAME: User - USERPROFILE: C:\Users\User - windir: C:\WINDOWS - __COMPAT_LAYER: DetectorsAppHealth
Total spawn time to start the pgAdmin4 server: 0.278 Sec 2023-10-03 17:16:07,964: 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 Files\PostgreSQL\16\pgAdmin 4\web\pgAdmin4.py", line 104, in app = create_app() ^^^^^^^^^^^^ File "C:\Program Files\PostgreSQL\16\pgAdmin 4\web\pgadmin_init.py", line 477, in create_app run_migration_for_sqlite() File "C:\Program Files\PostgreSQL\16\pgAdmin 4\web\pgadmin_init.py", line 444, in run_migration_for_sqlite backup_db_file() File "C:\Program Files\PostgreSQL\16\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\User\AppData\Roaming\pgadmin\pgadmin4.db' -> 'C:\Users\User\AppData\Roaming\pgadmin\pgadmin4.db.20231003171607'
O que deve ser feito para corrigir esse erro ? para depois seguir para o site ?
