PgAdmin sometimes crash when clicking SQL query button

Pavel V. picture Pavel V. · Dec 13, 2012 · Viewed 14.8k times · Source

I know this question may be seen as a duplicate with this one. I even have almost the same configuration (PostgreSQL 9.1.3, pgAdmin III 1.14.3, 32 bit Windows). What is the difference and the reason I ask a new question is that my PgAdmin doesn't crash always (just mostly) and that the cause of the problem is different - in linked question the problem was with missing adminpack, but I have adminpack installed and it works well, so the answer for linked question doesn't work for me.

Do you have any ideas where the problem could be?

EDIT: PgAdmin doesn't crash at other occasions (well, unless I do someting that obviously deserves a crash), just while trying to open SQL query window. It's worse and worse as time goes on, now it's almost "always". The problem is not "connection specific" - frequence of crashing is the same for different server connections.

EDIT2: I reinstalled PgAdmin and nothing have changed. I'm starting to suspect PostgreSQL 9.1.3 or even PostGIS 2.0.1 of the problem.

Answer

Ashwath picture Ashwath · May 28, 2015
  1. Goto run and type %appdata% and go inside postgresql folder.
  2. rename or delete pgadmin_histoqueries.xml file.
  3. try opening the SQL query editor again.

Good luck!