Thread: Request Support with getting Postgresql 4.8 to run.

I have just upgraded to the 4.8 version of postgresql and I am not able to get the software to start up for me.

I installed it over the top of version 4

Here is the error message that I am getting.

pgAdmin Runtime Environment

--------------------------------------------------------

Python Path: "C:\Users\jchaa\AppData\Local\Programs\pgAdmin 4\python\python.exe"

Runtime Config File: "C:\Users\jchaa\AppData\Roaming\pgadmin\runtime_config.json"

pgAdmin Config File: "C:\Users\jchaa\AppData\Local\Programs\pgAdmin 4\web\config.py"

Webapp Path: "C:\Users\jchaa\AppData\Local\Programs\pgAdmin 4\web\pgAdmin4.py"

pgAdmin Command: "C:\Users\jchaa\AppData\Local\Programs\pgAdmin 4\python\python.exe -s C:\Users\jchaa\AppData\Local\Programs\pgAdmin 4\web\pgAdmin4.py"

Environment:

  - ALLUSERSPROFILE: C:\ProgramData

  - APPDATA: C:\Users\jchaa\AppData\Roaming

  - CHROME_CRASHPAD_PIPE_NAME: \\.\pipe\crashpad_4748_HRZPBVCZNMCZATNV

  - 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: LAPTOP-CH589UUJ

  - ComSpec: C:\WINDOWS\system32\cmd.exe

  - DriverData: C:\Windows\System32\Drivers\DriverData

  - HOMEDRIVE: C:

  - HOMEPATH: \Users\jchaa

  - LOCALAPPDATA: C:\Users\jchaa\AppData\Local

  - LOGONSERVER: \\LAPTOP-CH589UUJ

  - NUMBER_OF_PROCESSORS: 8

  - OneDrive: C:\Users\jchaa\OneDrive

  - OneDriveConsumer: C:\Users\jchaa\OneDrive

  - OnlineServices: Online Services

  - OPENSSL_CONF: C:\Program Files\PostgreSQL\psqlODBC\etc\openssl.cnf

  - OS: Windows_NT

  - Path: C:\Users\jchaa\AppData\Local\Programs\pgAdmin 4\runtime;C:\Program Files\Python310\Scripts\;C:\Program Files\Python310\;C:\app\jchaa\product\18.0.0\dbhomeXE\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\WINDOWS\System32\OpenSSH\;C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\170\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\150\Tools\Binn\;C:\Program Files\Microsoft SQL Server\150\Tools\Binn\;C:\Program Files\Microsoft SQL Server\150\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\150\DTS\Binn\;C:\Program Files\Azure Data Studio\bin;C:\Program Files\HP\HP One Agent;C:\Users\jchaa\AppData\Local\Microsoft\WindowsApps;C:\Program Files\JetBrains\PyCharm Community Edition 2022.1.3\bin

  - PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC;.PY;.PYW

  - PGADMIN_INT_KEY: 9bc5ec76-bd73-461e-92b5-e792e3a4d78c

  - PGADMIN_INT_PORT: 5050

  - PGADMIN_SERVER_MODE: OFF

  - platformcode: KV

  - PROCESSOR_ARCHITECTURE: AMD64

  - PROCESSOR_IDENTIFIER: Intel64 Family 6 Model 126 Stepping 5, GenuineIntel

  - PROCESSOR_LEVEL: 6

  - PROCESSOR_REVISION: 7e05

  - 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 (x86)\Microsoft SQL Server\150\Tools\PowerShell\Modules\

  - PUBLIC: C:\Users\Public

  - PyCharm Community Edition: C:\Program Files\JetBrains\PyCharm Community Edition 2022.1.3\bin;

  - RegionCode: NA

  - SystemDrive: C:

  - SystemRoot: C:\WINDOWS

  - TEMP: C:\Users\jchaa\AppData\Local\Temp

  - TMP: C:\Users\jchaa\AppData\Local\Temp

  - USERDOMAIN: LAPTOP-CH589UUJ

  - USERDOMAIN_ROAMINGPROFILE: LAPTOP-CH589UUJ

  - USERNAME: jchaa

  - USERPROFILE: C:\Users\jchaa

  - windir: C:\WINDOWS

--------------------------------------------------------

Total spawn time to start the pgAdmin4 server: 0.011 Sec

2024-04-18 10:35:18,793: ERROR      pgadmin:    Database migration failed

2024-04-18 10:35:18,793: ERROR      pgadmin:    Traceback (most recent call last):

  File "C:\Users\jchaa\AppData\Local\Programs\pgAdmin 4\web\pgadmin\__init__.py", line 386, in upgrade_db

    db_upgrade(app)

  File "C:\Users\jchaa\AppData\Local\Programs\pgAdmin 4\web\pgadmin\setup\db_upgrade.py", line 25, in db_upgrade

    flask_migrate.upgrade(migration_folder)

  File "C:\Users\jchaa\AppData\Local\Programs\pgAdmin 4\python\lib\site-packages\flask_migrate\__init__.py", line 111, in wrapped

    f(*args, **kwargs)

  File "C:\Users\jchaa\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\jchaa\AppData\Local\Programs\pgAdmin 4\python\lib\site-packages\alembic\command.py", line 403, in upgrade

    script.run_env()

  File "C:\Users\jchaa\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\jchaa\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\jchaa\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 883, in exec_module

  File "<frozen importlib._bootstrap>", line 241, in _call_with_frames_removed

  File "C:\Users\jchaa\AppData\Local\Programs\pgAdmin 4\web\pgadmin\setup\..\..\migrations\env.py", line 95, in <module>

    run_migrations_online()

  File "C:\Users\jchaa\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\jchaa\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\jchaa\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\jchaa\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 142, in __exit__

  File "C:\Users\jchaa\AppData\Local\Programs\pgAdmin 4\python\lib\site-packages\alembic\operations\base.py", line 398, in batch_alter_table

    impl.flush()

  File "C:\Users\jchaa\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\jchaa\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\jchaa\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\jchaa\AppData\Local\Programs\pgAdmin 4\python\lib\site-packages\sqlalchemy\sql\schema.py", line 485, in _new

    with util.safe_reraise():

  File "C:\Users\jchaa\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\jchaa\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\jchaa\AppData\Local\Programs\pgAdmin 4\python\lib\site-packages\sqlalchemy\sql\schema.py", line 861, in __init__

    self._autoload(

  File "C:\Users\jchaa\AppData\Local\Programs\pgAdmin 4\python\lib\site-packages\sqlalchemy\sql\schema.py", line 893, in _autoload

    conn_insp.reflect_table(

  File "C:\Users\jchaa\AppData\Local\Programs\pgAdmin 4\python\lib\site-packages\sqlalchemy\engine\reflection.py", line 1570, in reflect_table

    self._reflect_fk(

  File "C:\Users\jchaa\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\jchaa\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\jchaa\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\jchaa\AppData\Local\Programs\pgAdmin 4\python\lib\site-packages\sqlalchemy\sql\schema.py", line 485, in _new

    with util.safe_reraise():

  File "C:\Users\jchaa\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\jchaa\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\jchaa\AppData\Local\Programs\pgAdmin 4\python\lib\site-packages\sqlalchemy\sql\schema.py", line 861, in __init__

    self._autoload(

  File "C:\Users\jchaa\AppData\Local\Programs\pgAdmin 4\python\lib\site-packages\sqlalchemy\sql\schema.py", line 893, in _autoload

    conn_insp.reflect_table(

  File "C:\Users\jchaa\AppData\Local\Programs\pgAdmin 4\python\lib\site-packages\sqlalchemy\engine\reflection.py", line 1570, in reflect_table

    self._reflect_fk(

  File "C:\Users\jchaa\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\jchaa\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\jchaa\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\jchaa\AppData\Local\Programs\pgAdmin 4\python\lib\site-packages\sqlalchemy\sql\schema.py", line 485, in _new

    with util.safe_reraise():

  File "C:\Users\jchaa\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\jchaa\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\jchaa\AppData\Local\Programs\pgAdmin 4\python\lib\site-packages\sqlalchemy\sql\schema.py", line 861, in __init__

    self._autoload(

  File "C:\Users\jchaa\AppData\Local\Programs\pgAdmin 4\python\lib\site-packages\sqlalchemy\sql\schema.py", line 893, in _autoload

    conn_insp.reflect_table(

  File "C:\Users\jchaa\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\jchaa\AppData\Local\Programs\pgAdmin 4\web\pgadmin\__init__.py", line 386, in upgrade_db

    db_upgrade(app)

  File "C:\Users\jchaa\AppData\Local\Programs\pgAdmin 4\web\pgadmin\setup\db_upgrade.py", line 25, in db_upgrade

    flask_migrate.upgrade(migration_folder)

  File "C:\Users\jchaa\AppData\Local\Programs\pgAdmin 4\python\lib\site-packages\flask_migrate\__init__.py", line 111, in wrapped

    f(*args, **kwargs)

  File "C:\Users\jchaa\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\jchaa\AppData\Local\Programs\pgAdmin 4\python\lib\site-packages\alembic\command.py", line 403, in upgrade

    script.run_env()

  File "C:\Users\jchaa\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\jchaa\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\jchaa\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 883, in exec_module

  File "<frozen importlib._bootstrap>", line 241, in _call_with_frames_removed

  File "C:\Users\jchaa\AppData\Local\Programs\pgAdmin 4\web\pgadmin\setup\..\..\migrations\env.py", line 95, in <module>

    run_migrations_online()

  File "C:\Users\jchaa\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\jchaa\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\jchaa\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\jchaa\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 142, in __exit__

  File "C:\Users\jchaa\AppData\Local\Programs\pgAdmin 4\python\lib\site-packages\alembic\operations\base.py", line 398, in batch_alter_table

    impl.flush()

  File "C:\Users\jchaa\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\jchaa\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\jchaa\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\jchaa\AppData\Local\Programs\pgAdmin 4\python\lib\site-packages\sqlalchemy\sql\schema.py", line 485, in _new

    with util.safe_reraise():

  File "C:\Users\jchaa\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\jchaa\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\jchaa\AppData\Local\Programs\pgAdmin 4\python\lib\site-packages\sqlalchemy\sql\schema.py", line 861, in __init__

    self._autoload(

  File "C:\Users\jchaa\AppData\Local\Programs\pgAdmin 4\python\lib\site-packages\sqlalchemy\sql\schema.py", line 893, in _autoload

    conn_insp.reflect_table(

  File "C:\Users\jchaa\AppData\Local\Programs\pgAdmin 4\python\lib\site-packages\sqlalchemy\engine\reflection.py", line 1570, in reflect_table

    self._reflect_fk(

  File "C:\Users\jchaa\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\jchaa\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\jchaa\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\jchaa\AppData\Local\Programs\pgAdmin 4\python\lib\site-packages\sqlalchemy\sql\schema.py", line 485, in _new

    with util.safe_reraise():

  File "C:\Users\jchaa\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\jchaa\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\jchaa\AppData\Local\Programs\pgAdmin 4\python\lib\site-packages\sqlalchemy\sql\schema.py", line 861, in __init__

    self._autoload(

  File "C:\Users\jchaa\AppData\Local\Programs\pgAdmin 4\python\lib\site-packages\sqlalchemy\sql\schema.py", line 893, in _autoload

    conn_insp.reflect_table(

  File "C:\Users\jchaa\AppData\Local\Programs\pgAdmin 4\python\lib\site-packages\sqlalchemy\engine\reflection.py", line 1570, in reflect_table

    self._reflect_fk(

  File "C:\Users\jchaa\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\jchaa\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\jchaa\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\jchaa\AppData\Local\Programs\pgAdmin 4\python\lib\site-packages\sqlalchemy\sql\schema.py", line 485, in _new

    with util.safe_reraise():

  File "C:\Users\jchaa\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\jchaa\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\jchaa\AppData\Local\Programs\pgAdmin 4\python\lib\site-packages\sqlalchemy\sql\schema.py", line 861, in __init__

    self._autoload(

  File "C:\Users\jchaa\AppData\Local\Programs\pgAdmin 4\python\lib\site-packages\sqlalchemy\sql\schema.py", line 893, in _autoload

    conn_insp.reflect_table(

  File "C:\Users\jchaa\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\jchaa\AppData\Local\Programs\pgAdmin 4\web\pgAdmin4.py", line 103, in <module>

    app = create_app()

  File "C:\Users\jchaa\AppData\Local\Programs\pgAdmin 4\web\pgadmin\__init__.py", line 473, in create_app

    run_migration_for_sqlite()

  File "C:\Users\jchaa\AppData\Local\Programs\pgAdmin 4\web\pgadmin\__init__.py", line 432, in run_migration_for_sqlite

    upgrade_db()

  File "C:\Users\jchaa\AppData\Local\Programs\pgAdmin 4\web\pgadmin\__init__.py", line 391, in upgrade_db

    backup_db_file()

  File "C:\Users\jchaa\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\\jchaa\\AppData\\Roaming\\pgAdmin\\pgadmin4.db' -> 'C:\\Users\\jchaa\\AppData\\Roaming\\pgAdmin\\pgadmin4.db.20240418103518'

Any suggestions would be appreciated.

Thank you

Joseph Haas