Great! Thanks for the update. On Thu, Nov 30, 2023 at 6:15 PM Delcia D'Souza <ddevange...@gmail.com> wrote:
> Hi Aditya, > > Thanks for resolving the issue I was facing with PG Admin. I now have > access to PG Admin and can navigate the platform. > > If there are any additional steps or tasks I need to undertake to ensure a > smooth experience with PG Admin, please do let me know > > Best regards, > > Delcia > > On Thu, 30 Nov 2023 at 12:04, Aditya Toshniwal < > aditya.toshni...@enterprisedb.com> wrote: > >> Hi Delcia, >> >> Try taking a backup of >> C:\\Users\\golia\\AppData\\Roaming\\pgAdmin\\pgadmin4.db >> and then removing it. After that, start pgAdmin. >> >> On Thu, Nov 30, 2023 at 4:07 PM Delcia D'Souza <ddevange...@gmail.com> >> wrote: >> >>> pgAdmin Runtime Environment >>> -------------------------------------------------------- >>> Python Path: "C:\Program Files\PostgreSQL\16\pgAdmin 4\python\python.exe" >>> Runtime Config File: >>> "C:\Users\golia\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\golia\AppData\Roaming >>> - CHROME_CRASHPAD_PIPE_NAME: \\.\pipe\crashpad_5492_ZWGDRTNRMHXJSWLY >>> - CHROME_RESTART: NW.js|Whoa! NW.js has crashed. Relaunch >>> now?|LEFT_TO_RIGHT >>> - CLASSPATH: C:\Program Files\Portugal Identity Card\ >>> - CommonProgramFiles: C:\Program Files\Common Files >>> - CommonProgramFiles(x86): C:\Program Files (x86)\Common Files >>> - CommonProgramW6432: C:\Program Files\Common Files >>> - COMPUTERNAME: DESKTOP-IOITUK1 >>> - ComSpec: C:\Windows\system32\cmd.exe >>> - CURL_CA_BUNDLE: C:\Program >>> Files\PostgreSQL\16\ssl\certs\ca-bundle.crt >>> - DriverData: C:\Windows\System32\Drivers\DriverData >>> - GDAL_DATA: C:\Program Files\PostgreSQL\16\gdal-data >>> - HOMEDRIVE: C: >>> - HOMEPATH: \Users\golia >>> - LOCALAPPDATA: C:\Users\golia\AppData\Local >>> - LOGONSERVER: \\DESKTOP-IOITUK1 >>> - NUMBER_OF_PROCESSORS: 4 >>> - OneDrive: C:\Users\golia\OneDrive >>> - OneDriveConsumer: C:\Users\golia\OneDrive >>> - OS: Windows_NT >>> - Path: C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\runtime;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\OpenSSH\;C:\Program >>> Files\Portugal Identity Card\;C:\Program >>> Files\dotnet\;C:\Users\golia\AppData\Local\Microsoft\WindowsApps;C:\Users\golia\.dotnet\tools >>> - PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC >>> - PGADMIN_INT_KEY: 80064c74-4460-4bdc-831a-58ed8460feb4 >>> - PGADMIN_INT_PORT: 5439 >>> - PGADMIN_SERVER_MODE: OFF >>> - POSTGIS_ENABLE_OUTDB_RASTERS: 1 >>> - POSTGIS_GDAL_ENABLED_DRIVERS: GTiff PNG JPEG GIF XYZ DTED USGSDEM >>> AAIGrid >>> - 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 >>> - PROJ_LIB: C:\Program >>> Files\PostgreSQL\16\share\contrib\postgis-3.4\proj >>> - PSModulePath: C:\Program >>> Files\WindowsPowerShell\Modules;C:\Windows\system32\WindowsPowerShell\v1.0\Modules >>> - PUBLIC: C:\Users\Public >>> - SystemDrive: C: >>> - SystemRoot: C:\Windows >>> - TEMP: C:\Users\golia\AppData\Local\Temp >>> - TMP: C:\Users\golia\AppData\Local\Temp >>> - USERDOMAIN: DESKTOP-IOITUK1 >>> - USERDOMAIN_ROAMINGPROFILE: DESKTOP-IOITUK1 >>> - USERNAME: golia >>> - USERPROFILE: C:\Users\golia >>> - windir: C:\Windows >>> -------------------------------------------------------- >>> >>> Total spawn time to start the pgAdmin4 server: 0.036 Sec >>> 2023-11-29 16:43:58,936: ERROR pgadmin: Database migration failed >>> >>> 2023-11-29 16:43:58,952: ERROR pgadmin: Traceback (most recent call >>> last): >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\web\pgadmin\__init__.py", line 390, in upgrade_db >>> db_upgrade(app) >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\web\pgadmin\setup\db_upgrade.py", line 25, in db_upgrade >>> flask_migrate.upgrade(migration_folder) >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\flask_migrate\__init__.py", line 111, in wrapped >>> f(*args, **kwargs) >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\flask_migrate\__init__.py", line 200, in upgrade >>> command.upgrade(config, revision, sql=sql, tag=tag) >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\alembic\command.py", line 398, in upgrade >>> script.run_env() >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\alembic\script\base.py", line 579, in run_env >>> util.load_python_file(self.dir, "env.py") >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\alembic\util\pyfiles.py", line 93, in >>> load_python_file >>> module = load_module_py(module_id, path) >>> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\alembic\util\pyfiles.py", line 109, in >>> load_module_py >>> spec.loader.exec_module(module) # type: ignore >>> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ >>> File "<frozen importlib._bootstrap_external>", line 940, in exec_module >>> File "<frozen importlib._bootstrap>", line 241, in >>> _call_with_frames_removed >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\web\pgadmin\setup\..\..\migrations\env.py", line 95, in <module> >>> run_migrations_online() >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\web\pgadmin\setup\..\..\migrations\env.py", line 87, in >>> run_migrations_online >>> context.run_migrations() >>> File "<string>", line 8, in run_migrations >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\alembic\runtime\environment.py", line 938, in >>> run_migrations >>> self.get_context().run_migrations(**kw) >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\alembic\runtime\migration.py", line 624, in >>> run_migrations >>> step.migration_fn(**kw) >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\web\migrations\versions\a39bd015b644_.py", line 26, in upgrade >>> with op.batch_alter_table("sharedserver") as batch_op: >>> File "contextlib.py", line 144, in __exit__ >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\alembic\operations\base.py", line 375, in >>> batch_alter_table >>> impl.flush() >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\alembic\operations\batch.py", line 139, in flush >>> existing_table = Table( >>> ^^^^^^ >>> File "<string>", line 2, in __new__ >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\sqlalchemy\util\deprecations.py", line 281, in >>> warned >>> return fn(*args, **kwargs) # type: ignore[no-any-return] >>> ^^^^^^^^^^^^^^^^^^^ >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 436, in __new__ >>> return cls._new(*args, **kw) >>> ^^^^^^^^^^^^^^^^^^^^^ >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 490, in _new >>> with util.safe_reraise(): >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\sqlalchemy\util\langhelpers.py", line 146, in >>> __exit__ >>> raise exc_value.with_traceback(exc_tb) >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 486, in _new >>> table.__init__(name, metadata, *args, _no_init=False, **kw) >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 866, in __init__ >>> self._autoload( >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 898, in _autoload >>> conn_insp.reflect_table( >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\sqlalchemy\engine\reflection.py", line 1570, in >>> reflect_table >>> self._reflect_fk( >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\sqlalchemy\engine\reflection.py", line 1768, in >>> _reflect_fk >>> sa_schema.Table( >>> File "<string>", line 2, in __new__ >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\sqlalchemy\util\deprecations.py", line 281, in >>> warned >>> return fn(*args, **kwargs) # type: ignore[no-any-return] >>> ^^^^^^^^^^^^^^^^^^^ >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 436, in __new__ >>> return cls._new(*args, **kw) >>> ^^^^^^^^^^^^^^^^^^^^^ >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 490, in _new >>> with util.safe_reraise(): >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\sqlalchemy\util\langhelpers.py", line 146, in >>> __exit__ >>> raise exc_value.with_traceback(exc_tb) >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 486, in _new >>> table.__init__(name, metadata, *args, _no_init=False, **kw) >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 866, in __init__ >>> self._autoload( >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 898, in _autoload >>> conn_insp.reflect_table( >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\sqlalchemy\engine\reflection.py", line 1570, in >>> reflect_table >>> self._reflect_fk( >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\sqlalchemy\engine\reflection.py", line 1768, in >>> _reflect_fk >>> sa_schema.Table( >>> File "<string>", line 2, in __new__ >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\sqlalchemy\util\deprecations.py", line 281, in >>> warned >>> return fn(*args, **kwargs) # type: ignore[no-any-return] >>> ^^^^^^^^^^^^^^^^^^^ >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 436, in __new__ >>> return cls._new(*args, **kw) >>> ^^^^^^^^^^^^^^^^^^^^^ >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 490, in _new >>> with util.safe_reraise(): >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\sqlalchemy\util\langhelpers.py", line 146, in >>> __exit__ >>> raise exc_value.with_traceback(exc_tb) >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 486, in _new >>> table.__init__(name, metadata, *args, _no_init=False, **kw) >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 866, in __init__ >>> self._autoload( >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 898, in _autoload >>> conn_insp.reflect_table( >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\sqlalchemy\engine\reflection.py", line 1538, in >>> reflect_table >>> raise exc.NoSuchTableError(table_name) >>> sqlalchemy.exc.NoSuchTableError: user_old >>> >>> >>> Traceback (most recent call last): >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\web\pgadmin\__init__.py", line 390, in upgrade_db >>> >>> db_upgrade(app) >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\web\pgadmin\setup\db_upgrade.py", line 25, in db_upgrade >>> flask_migrate.upgrade(migration_folder) >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\flask_migrate\__init__.py", line 111, in wrapped >>> >>> f(*args, **kwargs) >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\flask_migrate\__init__.py", line 200, in upgrade >>> command.upgrade(config, revision, sql=sql, tag=tag) >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\alembic\command.py", line 398, in upgrade >>> >>> script.run_env() >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\alembic\script\base.py", line 579, in run_env >>> util.load_python_file(self.dir, "env.py") >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\alembic\util\pyfiles.py", line 93, in >>> load_python_file >>> >>> module = load_module_py(module_id, path) >>> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\alembic\util\pyfiles.py", line 109, in >>> load_module_py >>> spec.loader.exec_module(module) # type: ignore >>> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ >>> File "<frozen importlib._bootstrap_external>", line 940, in exec_module >>> File "<frozen importlib._bootstrap>", line 241, in >>> _call_with_frames_removed >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\web\pgadmin\setup\..\..\migrations\env.py", line 95, in <module> >>> run_migrations_online() >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\web\pgadmin\setup\..\..\migrations\env.py", line 87, in >>> run_migrations_online >>> >>> context.run_migrations() >>> File "<string>", line 8, in run_migrations >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\alembic\runtime\environment.py", line 938, in >>> run_migrations >>> self.get_context().run_migrations(**kw) >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\alembic\runtime\migration.py", line 624, in >>> run_migrations >>> >>> step.migration_fn(**kw) >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\web\migrations\versions\a39bd015b644_.py", line 26, in upgrade >>> with op.batch_alter_table("sharedserver") as batch_op: >>> File "contextlib.py", line 144, in __exit__ >>> >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\alembic\operations\base.py", line 375, in >>> batch_alter_table >>> impl.flush() >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\alembic\operations\batch.py", line 139, in flush >>> >>> existing_table = Table( >>> ^^^^^^ >>> File "<string>", line 2, in __new__ >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\sqlalchemy\util\deprecations.py", line 281, in >>> warned >>> return fn(*args, **kwargs) # type: ignore[no-any-return] >>> ^^^^^^^^^^^^^^^^^^^ >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 436, in __new__ >>> >>> return cls._new(*args, **kw) >>> ^^^^^^^^^^^^^^^^^^^^^ >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 490, in _new >>> >>> with util.safe_reraise(): >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\sqlalchemy\util\langhelpers.py", line 146, in >>> __exit__ >>> raise exc_value.with_traceback(exc_tb) >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 486, in _new >>> >>> table.__init__(name, metadata, *args, _no_init=False, **kw) >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 866, in __init__ >>> >>> self._autoload( >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 898, in _autoload >>> conn_insp.reflect_table( >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\sqlalchemy\engine\reflection.py", line 1570, in >>> reflect_table >>> >>> self._reflect_fk( >>> >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\sqlalchemy\engine\reflection.py", line 1768, in >>> _reflect_fk >>> >>> sa_schema.Table( >>> >>> File "<string>", line 2, in __new__ >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\sqlalchemy\util\deprecations.py", line 281, in >>> warned >>> return fn(*args, **kwargs) # type: ignore[no-any-return] >>> ^^^^^^^^^^^^^^^^^^^ >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 436, in __new__ >>> >>> return cls._new(*args, **kw) >>> >>> ^^^^^^^^^^^^^^^^^^^^^ >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 490, in _new >>> >>> with util.safe_reraise(): >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\sqlalchemy\util\langhelpers.py", line 146, in >>> __exit__ >>> raise exc_value.with_traceback(exc_tb) >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 486, in _new >>> >>> table.__init__(name, metadata, *args, _no_init=False, **kw) >>> >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 866, in __init__ >>> >>> self._autoload( >>> >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 898, in _autoload >>> >>> conn_insp.reflect_table( >>> >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\sqlalchemy\engine\reflection.py", line 1570, in >>> reflect_table >>> >>> self._reflect_fk( >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\sqlalchemy\engine\reflection.py", line 1768, in >>> _reflect_fk >>> >>> sa_schema.Table( >>> >>> File "<string>", line 2, in __new__ >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\sqlalchemy\util\deprecations.py", line 281, in >>> warned >>> return fn(*args, **kwargs) # type: ignore[no-any-return] >>> ^^^^^^^^^^^^^^^^^^^ >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 436, in __new__ >>> >>> return cls._new(*args, **kw) >>> ^^^^^^^^^^^^^^^^^^^^^ >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 490, in _new >>> >>> with util.safe_reraise(): >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\sqlalchemy\util\langhelpers.py", line 146, in >>> __exit__ >>> >>> raise exc_value.with_traceback(exc_tb) >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 486, in _new >>> >>> table.__init__(name, metadata, *args, _no_init=False, **kw) >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 866, in __init__ >>> >>> self._autoload( >>> >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 898, in _autoload >>> >>> conn_insp.reflect_table( >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\python\Lib\site-packages\sqlalchemy\engine\reflection.py", line 1538, in >>> reflect_table >>> >>> raise exc.NoSuchTableError(table_name) >>> >>> sqlalchemy.exc.NoSuchTableError: user_old >>> >>> During handling of the above exception, another exception occurred: >>> >>> Traceback (most recent call last): >>> File "C:\Program Files\PostgreSQL\16\pgAdmin 4\web\pgAdmin4.py", line >>> 104, in <module> >>> 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 436, in run_migration_for_sqlite >>> upgrade_db() >>> >>> File "C:\Program Files\PostgreSQL\16\pgAdmin >>> 4\web\pgadmin\__init__.py", line 395, in upgrade_db >>> 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] The process cannot access the file >>> because it is being used by another process: >>> 'C:\\Users\\golia\\AppData\\Roaming\\pgAdmin\\pgadmin4.db' -> >>> 'C:\\Users\\golia\\AppData\\Roaming\\pgAdmin\\pgadmin4.db.20231129164358' >>> >>> >>> On Thu, 30 Nov 2023 at 03:51, Aditya Toshniwal < >>> aditya.toshni...@enterprisedb.com> wrote: >>> >>>> Hi Delcia, >>>> >>>> Can you share the logs from the window which is opened after - server >>>> could not be contacted error? >>>> >>>> On Wed, Nov 29, 2023 at 10:25 PM Delcia D'Souza <ddevange...@gmail.com> >>>> wrote: >>>> >>>>> Good evening, >>>>> >>>>> I hope this email finds you well. I am reaching out to seek assistance >>>>> regarding an issue I encountered after downloading PostgreSQL on my >>>>> Windows >>>>> system. >>>>> >>>>> Upon attempting to open pgAdmin, I encountered the following error: >>>>> "The pgAdmin 4 server could not be contacted." Despite attempting various >>>>> troubleshooting steps, the problem persists. >>>>> >>>>> ould you kindly provide guidance or assistance in resolving this >>>>> matter? I would greatly appreciate any insights or steps I may have >>>>> overlooked. >>>>> >>>>> Thank you for your time and assistance. I look forward to your >>>>> guidance on this matter. >>>>> >>>>> Best regards, >>>>> >>>>> Delcia >>>>> >>>> >>>> >>>> -- >>>> Thanks, >>>> Aditya Toshniwal >>>> pgAdmin Hacker | Sr. Software Architect | *enterprisedb.com* >>>> <https://www.enterprisedb.com/> >>>> "Don't Complain about Heat, Plant a TREE" >>>> >>> >> >> -- >> Thanks, >> Aditya Toshniwal >> pgAdmin Hacker | Sr. Software Architect | *enterprisedb.com* >> <https://www.enterprisedb.com/> >> "Don't Complain about Heat, Plant a TREE" >> > -- Thanks, Aditya Toshniwal pgAdmin Hacker | Sr. Software Architect | *enterprisedb.com* <https://www.enterprisedb.com/> "Don't Complain about Heat, Plant a TREE"