Instal postgres sql in windows 10

Question

I try to install the latest version of postgres sql using the latest version and the recommended set up.

However when I open the pg adming I receive this error.

Python Path: "C:\Program Files\PostgreSQL\13\pgAdmin 4\python\python.exe"
Runtime Config File: "C:\Users\User\AppData\Roaming\pgadmin\runtime_config.json"
pgAdmin Config File: "C:\Program Files\PostgreSQL\13\pgAdmin 4\web\config.py"
Webapp Path: "C:\Program Files\PostgreSQL\13\pgAdmin 4\web\pgAdmin4.py"
pgAdmin Command: "C:\Program Files\PostgreSQL\13\pgAdmin 4\python\python.exe C:\Program Files\PostgreSQL\13\pgAdmin 4\web\pgAdmin4.py"
Traceback (most recent call last):
  File "../web/pgAdmin4.py", line 98, in <module>
    app = create_app()
  File "C:\Program Files\PostgreSQL\13\pgAdmin 4\web\pgadmin\__init__.py", line 347, in create_app
    if not os.path.exists(SQLITE_PATH) or get_version() == -1:
  File "C:\Program Files\PostgreSQL\13\pgAdmin 4\web\pgadmin\setup\db_version.py", line 19, in get_version
    return version.value
AttributeError: 'NoneType' object has no attribute 'value'

Any help on how to fix it?

Answer 1

After trying all the other suggestions without success, it finally worked for me now, with the way suggested here: Get fatal error: server could not be contacted when running pgAdmin4. 'NoneType' object has no attribute 'value'

1. Install the newest version of the standalone pgAdmin from https://www.pgadmin.org/download/pgadmin-4-windows/ (you can do the installation additionally to the existing bundled version, without having to remove anything before)

2. Delete the C:\Users\your_username\AppData\Roaming\pgadmin folder

3. (I restarted the postgres service once again)

4. Run the new pgAdmin as Administrator - it works!

Several people report that, from then on, even the old bundled version of pgAdmin works fine!