Re: Assistance Needed: pgAdmin 4 Server Connection Issue

Great!
Thanks for the update.

On Thu, Nov 30, 2023 at 6:15 PM Delcia D'Souza <ddevangel31(at)gmail(dot)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(dot)toshniwal(at)enterprisedb(dot)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 <ddevangel31(at)gmail(dot)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(dot)toshniwal(at)enterprisedb(dot)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 <ddevangel31(at)gmail(dot)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"