Re: Assistance Needed: pgAdmin 4 Server Connection Issue

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"