RE: Re: Re: upgrade from version 4.28 to 8.8

Hi,

i dont think so.
I did try to start pgadmin4 8.8 after reboot or after killing any pgadmin processes, the log is always the same

pgAdmin Runtime Environment
--------------------------------------------------------
Python Path: "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\python.exe"
Runtime Config File: "C:\Users\Giacomo\AppData\Roaming\pgadmin\runtime_config.json"
pgAdmin Config File: "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\web\config.py"
Webapp Path: "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\web\pgAdmin4.py"
pgAdmin Command: "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\python.exe -s C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\web\pgAdmin4.py"
Environment:
- ALLUSERSPROFILE: C:\ProgramData
- APPDATA: C:\Users\Giacomo\AppData\Roaming
- CHROME_CRASHPAD_PIPE_NAME: \\.\pipe\crashpad_7124_BMZRIYHKKPKHZLQK<file://./pipe/crashpad_7124_BMZRIYHKKPKHZLQK>
- CHROME_RESTART: NW.js|Whoa! NW.js has crashed. Relaunch now?|LEFT_TO_RIGHT
- CommonProgramFiles: C:\Program Files\Common Files
- CommonProgramFiles(x86): C:\Program Files (x86)\Common Files
- CommonProgramW6432: C:\Program Files\Common Files
- COMPUTERNAME: DESKTOP-V5R1KTH
- ComSpec: C:\WINDOWS\system32\cmd.exe
- DriverData: C:\Windows\System32\Drivers\DriverData
- FPS_BROWSER_APP_PROFILE_STRING: Internet Explorer
- FPS_BROWSER_USER_PROFILE_STRING: Default
- HOMEDRIVE: C:
- HOMEPATH: \Users\Giacomo
- LOCALAPPDATA: C:\Users\Giacomo\AppData\Local
- LOGONSERVER: \\DESKTOP-V5R1KTH<file://DESKTOP-V5R1KTH>
- NUMBER_OF_PROCESSORS: 16
- OneDrive: C:\Users\Giacomo\OneDrive
- OS: Windows_NT
- Path: C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\runtime;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\WINDOWS\System32\OpenSSH\;C:\Users\Giacomo\AppData\Local\Microsoft\WindowsApps;
- PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
- PGADMIN_INT_KEY: fcb10fa9-7b3c-46a6-ae06-4818e72a1f9e
- PGADMIN_INT_PORT: 49859
- PGADMIN_SERVER_MODE: OFF
- PROCESSOR_ARCHITECTURE: AMD64
- PROCESSOR_IDENTIFIER: AMD64 Family 23 Model 8 Stepping 2, AuthenticAMD
- PROCESSOR_LEVEL: 23
- PROCESSOR_REVISION: 0802
- ProgramData: C:\ProgramData
- ProgramFiles: C:\Program Files
- ProgramFiles(x86): C:\Program Files (x86)
- ProgramW6432: C:\Program Files
- PSModulePath: C:\Program Files\WindowsPowerShell\Modules;C:\WINDOWS\system32\WindowsPowerShell\v1.0\Modules;C:\Program Files\Intel\Wired Networking\
- PUBLIC: C:\Users\Public
- SESSIONNAME: Console
- SystemDrive: C:
- SystemRoot: C:\WINDOWS
- TEMP: C:\Users\Giacomo\AppData\Local\Temp
- TMP: C:\Users\Giacomo\AppData\Local\Temp
- USERDOMAIN: DESKTOP-V5R1KTH
- USERDOMAIN_ROAMINGPROFILE: DESKTOP-V5R1KTH
- USERNAME: Giacomo
- USERPROFILE: C:\Users\Giacomo
- VBOX_MSI_INSTALL_PATH: C:\Program Files\Oracle\VirtualBox\
- windir: C:\WINDOWS
--------------------------------------------------------

Total spawn time to start the pgAdmin4 server: 0.007 Sec
2024-07-08 10:25:23,426: ERROR      pgadmin:    Database migration failed

2024-07-08 10:25:23,436: ERROR      pgadmin:    Traceback (most recent call last):
File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\web\pgadmin\__init__.py", line 386, in upgrade_db
db_upgrade(app)
File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\web\pgadmin\setup\db_upgrade.py", line 25, in db_upgrade
flask_migrate.upgrade(migration_folder)
File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\flask_migrate\__init__.py", line 111, in wrapped
f(*args, **kwargs)
File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\flask_migrate\__init__.py", line 200, in upgrade
command.upgrade(config, revision, sql=sql, tag=tag)
File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\command.py", line 403, in upgrade
script.run_env()
File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\script\base.py", line 583, in run_env
util.load_python_file(self.dir, "env.py")
File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\util\pyfiles.py", line 95, in load_python_file
module = load_module_py(module_id, path)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\util\pyfiles.py", line 113, in load_module_py
spec.loader.exec_module(module) # type: ignore
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "<frozen importlib._bootstrap_external>", line 995, in exec_module
File "<frozen importlib._bootstrap>", line 488, in _call_with_frames_removed
File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\web\pgadmin\setup\..\..\migrations\env.py", line 95, in <module>
run_migrations_online()
File "C:\Users\Giacomo\AppData\Local\Programs\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:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\runtime\environment.py", line 948, in run_migrations
self.get_context().run_migrations(**kw)
File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\runtime\migration.py", line 627, in run_migrations
step.migration_fn(**kw)
File "C:\Users\Giacomo\AppData\Local\Programs\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:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\operations\base.py", line 398, in batch_alter_table
impl.flush()
File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\operations\batch.py", line 142, in flush
existing_table = Table(
^^^^^^
File "<string>", line 2, in __new__
File "C:\Users\Giacomo\AppData\Local\Programs\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:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 431, in __new__
return cls._new(*args, **kw)
^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 485, in _new
with util.safe_reraise():
File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\util\langhelpers.py", line 146, in __exit__
raise exc_value.with_traceback(exc_tb)
File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 481, in _new
table.__init__(name, metadata, *args, _no_init=False, **kw)
File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 861, in __init__
self._autoload(
File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 893, in _autoload
conn_insp.reflect_table(
File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\engine\reflection.py", line 1570, in reflect_table
self._reflect_fk(
File "C:\Users\Giacomo\AppData\Local\Programs\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:\Users\Giacomo\AppData\Local\Programs\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:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 431, in __new__
return cls._new(*args, **kw)
^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 485, in _new
with util.safe_reraise():
File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\util\langhelpers.py", line 146, in __exit__
raise exc_value.with_traceback(exc_tb)
File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 481, in _new
table.__init__(name, metadata, *args, _no_init=False, **kw)
File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 861, in __init__
self._autoload(
File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 893, in _autoload
conn_insp.reflect_table(
File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\engine\reflection.py", line 1570, in reflect_table
self._reflect_fk(
File "C:\Users\Giacomo\AppData\Local\Programs\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:\Users\Giacomo\AppData\Local\Programs\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:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 431, in __new__
return cls._new(*args, **kw)
^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 485, in _new
with util.safe_reraise():
File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\util\langhelpers.py", line 146, in __exit__
raise exc_value.with_traceback(exc_tb)
File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 481, in _new
table.__init__(name, metadata, *args, _no_init=False, **kw)
File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 861, in __init__
self._autoload(
File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 893, in _autoload
conn_insp.reflect_table(
File "C:\Users\Giacomo\AppData\Local\Programs\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:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\web\pgadmin\__init__.py", line 386, in upgrade_db
db_upgrade(app)
File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\web\pgadmin\setup\db_upgrade.py", line 25, in db_upgrade
flask_migrate.upgrade(migration_folder)
File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\flask_migrate\__init__.py", line 111, in wrapped
f(*args, **kwargs)
File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\flask_migrate\__init__.py", line 200, in upgrade
command.upgrade(config, revision, sql=sql, tag=tag)
File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\command.py", line 403, in upgrade
script.run_env()
File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\script\base.py", line 583, in run_env
util.load_python_file(self.dir, "env.py")
File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\util\pyfiles.py", line 95, in load_python_file
module = load_module_py(module_id, path)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\util\pyfiles.py", line 113, in load_module_py
spec.loader.exec_module(module) # type: ignore
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "<frozen importlib._bootstrap_external>", line 995, in exec_module
File "<frozen importlib._bootstrap>", line 488, in _call_with_frames_removed
File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\web\pgadmin\setup\..\..\migrations\env.py", line 95, in <module>
run_migrations_online()
File "C:\Users\Giacomo\AppData\Local\Programs\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:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\runtime\environment.py", line 948, in run_migrations

self.get_context().run_migrations(**kw)
File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\runtime\migration.py", line 627, in run_migrations
step.migration_fn(**kw)
File "C:\Users\Giacomo\AppData\Local\Programs\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:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\operations\base.py", line 398, in batch_alter_table
impl.flush()
File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\alembic\operations\batch.py", line 142, in flush
existing_table = Table(
^^^^^^
File "<string>", line 2, in __new__
File "C:\Users\Giacomo\AppData\Local\Programs\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:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 431, in __new__
return cls._new(*args, **kw)
^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 485, in _new
with util.safe_reraise():
File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\util\langhelpers.py", line 146, in __exit__
raise exc_value.with_traceback(exc_tb)
File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 481, in _new
table.__init__(name, metadata, *args, _no_init=False, **kw)
File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 861, in __init__
self._autoload(
File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 893, in _autoload
conn_insp.reflect_table(
File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\engine\reflection.py", line 1570, in reflect_table
self._reflect_fk(
File "C:\Users\Giacomo\AppData\Local\Programs\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:\Users\Giacomo\AppData\Local\Programs\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:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 431, in __new__
return cls._new(*args, **kw)
^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 485, in _new
with util.safe_reraise():
File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\util\langhelpers.py", line 146, in __exit__
raise exc_value.with_traceback(exc_tb)
File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 481, in _new
table.__init__(name, metadata, *args, _no_init=False, **kw)
File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 861, in __init__
self._autoload(
File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 893, in _autoload
conn_insp.reflect_table(
File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\engine\reflection.py", line 1570, in reflect_table
self._reflect_fk(
File "C:\Users\Giacomo\AppData\Local\Programs\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:\Users\Giacomo\AppData\Local\Programs\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:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 431, in __new__
return cls._new(*args, **kw)
^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 485, in _new
with util.safe_reraise():
File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\util\langhelpers.py", line 146, in __exit__
raise exc_value.with_traceback(exc_tb)
File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 481, in _new
table.__init__(name, metadata, *args, _no_init=False, **kw)
File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 861, in __init__
self._autoload(
File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\python\Lib\site-packages\sqlalchemy\sql\schema.py", line 893, in _autoload
conn_insp.reflect_table(
File "C:\Users\Giacomo\AppData\Local\Programs\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:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\web\pgAdmin4.py", line 103, in <module>
app = create_app()
^^^^^^^^^^^^
File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\web\pgadmin\__init__.py", line 473, in create_app
run_migration_for_sqlite()
File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\web\pgadmin\__init__.py", line 432, in run_migration_for_sqlite
upgrade_db()
File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\web\pgadmin\__init__.py", line 391, in upgrade_db
backup_db_file()
File "C:\Users\Giacomo\AppData\Local\Programs\pgAdmin 4\web\pgadmin\__init__.py", line 368, 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\\Giacomo\\AppData\\Roaming\\pgAdmin\\pgadmin4.db' -> 'C:\\Users\\Giacomo\\AppData\\Roaming\\pgAdmin\\pgadmin4.db.20240708102523'

Sensitivity: C2 Internal

From: Aditya Toshniwal <aditya(dot)toshniwal(at)enterprisedb(dot)com>
Sent: Montag, 8. Juli 2024 07:38
To: Bonafé, Giacomo <giacomo(dot)bonafe(at)six-group(dot)com>
Cc: pgadmin-support(at)lists(dot)postgresql(dot)org
Subject: [External Sender] Re: Re: upgrade from version 4.28 to 8.8

Hi Giacomo,

Is the db file open in any external SQLLite DB viewer? Or any other pgAdmin instance is running? You need stop the usage first.

On Fri, Jul 5, 2024 at 12:32 PM Bonafé, Giacomo <giacomo(dot)bonafe(at)six-group(dot)com<mailto:giacomo(dot)bonafe(at)six-group(dot)com>> wrote:
Ok i have kept pgadmin.db and the replaced in the directory of my user

From The error log:

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\\<user>\\AppData\\Roaming\\pgadmin\\pgadmin4.db<file://AppData/Roaming/pgadmin/pgadmin4.db>' -> 'C:\\Users\\<user>\\AppData\\Roaming\\pgadmin\\pgadmin4.db.20240704155404<file://AppData/Roaming/pgadmin/pgadmin4.db.20240704155404>'

In the pgadmin directory above the pgadmin4.db is saved by the tool with name

pgadmin4.db.prev.bak

and a new file pgadmin4 is created

Sensitivity: C2 Internal
From: Aditya Toshniwal <aditya(dot)toshniwal(at)enterprisedb(dot)com<mailto:aditya(dot)toshniwal(at)enterprisedb(dot)com>>
Sent: Donnerstag, 4. Juli 2024 14:06
To: Bonafé, Giacomo <giacomo(dot)bonafe(at)six-group(dot)com<mailto:giacomo(dot)bonafe(at)six-group(dot)com>>
Cc: pgadmin-support(at)lists(dot)postgresql(dot)org<mailto:pgadmin-support(at)lists(dot)postgresql(dot)org>
Subject: [External Sender] Re: upgrade from version 4.28 to 8.8

Hi Giacomo,

Keep the backup of the pgadmin.db file and directly upgrade pgAdmin. It should work.
If you're facing any issues, share the error details.

On Thu, Jul 4, 2024 at 4:42 PM Bonafé, Giacomo <giacomo(dot)bonafe(at)six-group(dot)com<mailto:giacomo(dot)bonafe(at)six-group(dot)com>> wrote:
Hello,

is there a way to upgrade from version 4.28 to version 8.8 ?
I have attempted saving the pgadmin.db file before deleting 4.28 and installed 8.8 and then copied the saved pgadmin.db but this does not work

Is there a solution to this problem ?

Thanks and regards
Giacomo Bonafe

Sensitivity: C2 Internal

The content of this e-mail is intended only for the confidential use of the person addressed.
If you are not the intended recipient, please notify the sender and delete this e-mail immediately.
Thank you.

--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Sr. Software Architect | enterprisedb.com<https://www.enterprisedb.com/>
"Don't Complain about Heat, Plant a TREE"

The content of this e-mail is intended only for the confidential use of the person addressed.
If you are not the intended recipient, please notify the sender and delete this e-mail immediately.
Thank you.

--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Sr. Software Architect | enterprisedb.com<https://www.enterprisedb.com/>
"Don't Complain about Heat, Plant a TREE"

The content of this e-mail is intended only for the confidential use of the person addressed.
If you are not the intended recipient, please notify the sender and delete this email immediately.
Thank you.

Sensitivity: Confidential
The content of this e-mail is intended only for the confidential use of the person addressed.
If you are not the intended recipient, please notify the sender and delete this e-mail immediately.
Thank you.