After following instructions here, pgAdmin 4 fails to connect to the server. It pops up a window entitled Fatal Error with a lengthy list of environment printout followed by an even longer list of exception traces, the most relevant of which seems to be:
Total spawn time to start the pgAdmin4 server: 0.008 Sec
2023-04-26 19:28:32,904: ERROR pgadmin: Database migration failed
2023-04-26 19:28:33,031: ERROR pgadmin: Traceback (most recent call last):
File "C:\Users\Paul\AppData\Local\Programs\pgAdmin 4\v7\python\lib\site-packages\sqlalchemy\engine\base.py", line 1964, in _exec_single_context
self.dialect.do_execute(
File "C:\Users\Paul\AppData\Local\Programs\pgAdmin 4\v7\python\lib\site-packages\sqlalchemy\engine\default.py", line 748, in do_execute
cursor.execute(statement, parameters)
sqlite3.OperationalError: duplicate column name: shared
There is a Configure button on the dialog that offers the option of changing the timeout period, or to specify a fixed port number, neither of which have any obvious positive impact.
Is there anything I can do to recover from this, or should I just reinstall PostgreSQL from the ground up? I believe I have PostgreSQL 12.3 installed.
EDIT: I uninstalled PostgreSQL and reinstalled the latest version; the issue persists :-(
