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@xxxxxxxxxxx
