On 5/19/21 2:42 AM, Derek van den Nieuwenhuijzen wrote:
> Hi Postgress,
>
> I used to have a functioning PostgreSQL database, but upon reinstalling
> due to computer issues, I am now getting this error after launching:
>
> Traceback (most recent call last):
> File "C:\Program Files\PostgreSQL\12\pgAdmin 4\web\pgAdmin4.py", line
> 98, in <module>
> app = create_app()
> File "C:\Program Files\PostgreSQL\12\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\12\pgAdmin
> 4\web\pgadmin\setup\db_version.py", line 19, in get_version
> return version.value
> AttributeError: 'NoneType' object has no attribute 'value'
>
> I've tried everything from these stackoverflow forums
> (https://stackoverflow.com/questions/43211296/pgadmin4-postgresql-application-server-could-not-be-contacted
> <https://stackoverflow.com/questions/43211296/pgadmin4-postgresql-application-server-could-not-be-contacted> and
> https://stackoverflow.com/questions/67559636/pgadmin4-nonetype-object-has-no-attribute-value/67570989#67570989
> <https://stackoverflow.com/questions/67559636/pgadmin4-nonetype-object-has-no-attribute-value/67570989#67570989>)
> in order to fix it, however the error remains. I'm out of options,
> hopefully you know the answer.
>
> I tried it with both PostgreSQL 11, 12 and 13. I'm using a windows 64
> bit with PgAdmin 4.
First, this has nothing to do with Postgres itself, so
reinstalling/changing servers is not going to help.
Second pgAdmin has it's own list:
https://www.postgresql.org/list/pgadmin-support/
where you would find this answer:
https://www.postgresql.org/message-id/CANxoLDcUQ7a-ks9bvqiTBkze_r3y%3DeQ9srHxfgo-QATzMHMfAQ%40mail.gmail.com
"
We have figured out the issue, it is because of the latest version of the
'itsdangerous' python package which was released on 12th May. We are
working on fixing the issue with EDB Installers.
Meanwhile, you can perform the following steps:
1. Take a backup of your 'pgadmin4.db' file which is present at the
"%APPDATA%\Roaming\pgadmin" folder.
2. Delete 'pgadmin4.db' file.
3. Download pgAdmin4 v5.2 from
https://www.postgresql.org/ftp/pgadmin/pgadmin4/v5.2/windows/
4. Install and Launch 'pgAdmin4 v5'.
"
>
> Kind regards,
>
> Derek
> <https://stackoverflow.com/questions/43211296/pgadmin4-postgresql-application-server-could-not-be-contacted>
>
--
Adrian Klaver
adrian.klaver@aklaver.com