Thread: Assistance Needed: pgAdmin 4 Server Connection Issue
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.
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,
Thank you for your time and assistance. I look forward to your guidance on this matter.
Best regards,
Delcia
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@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
"Don't Complain about Heat, Plant a TREE"
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@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.toshniwal@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 <ddevangel31@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"Don't Complain about Heat, Plant a TREE"
Thanks,
Aditya Toshniwal
"Don't Complain about Heat, Plant a TREE"
Great!
Thanks for the update.
On Thu, Nov 30, 2023 at 6:15 PM Delcia D'Souza <ddevangel31@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 knowBest regards,DelciaOn Thu, 30 Nov 2023 at 12:04, Aditya Toshniwal <aditya.toshniwal@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 <ddevangel31@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.toshniwal@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 <ddevangel31@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"Don't Complain about Heat, Plant a TREE"--Thanks,Aditya Toshniwal"Don't Complain about Heat, Plant a TREE"
Thanks,
Aditya Toshniwal
"Don't Complain about Heat, Plant a TREE"