Pgadmin4 gives sqlite3.OperationalError – no such column after upgrade

I was using Postgres 14 and PGAdmin4 6.7 for a long while and everything was fine. This is on Windows 11. Yesterday I tried upgrading to Postgres 15 and PGAdmin4 7.6 and that’s where it fell apart!

Postgres 15 is fine and the installation was smooth. But PGAdmin4 is no longer working!

It’s giving the following error after I enter a password:

enter image description here

The interface doesn’t show any databases after I get that error. I’ve tried uninstalling PGAdmin4 and reinstalling the latest version 7.6. I also tried downgrading various versions going all the way back to the original I had running which was version 6.7. None of the versions I tried worked and they all gave the same error.

I do have SQLite3 on my system, but I don’t see how that has anything to do with my postgres install! I can use postgres fine on the command line, but I’d really like to have PGAdmin4 working again! I’m out of ideas and would appreciate some help getting this working again!

  • 1

    1) I’m guessing pgAdmin4 is using a SQLite3 database for its local store. 2) This is something you should be asking the pgadmin-support list. You will need to setup a Postgres community account to subscribe to the list.

    – 




Leave a Comment