2012-01-12 11:45:26 8 Comments

I've been using Postgres and pgAdmin III for some years, but this morning I had a very BIG BIG problem. I'm using pgAdmin III 9.0 on Windows Xp operating system, on my laptop Dell Latitude E4300.

From this morning, Query Builder ("SQL Editor") option simply stopped working. When I open pgAdmin, everything is fine and workin', until I click on the Sql Query Builder button. When I do that, nothing appears and pgAdmin crashes without giving any information.

I tried to uninstall and install PgAdmin III 9.1, again, but Sql Query Builder kept not workin'.

What could I do?


@Phil 2012-01-13 15:22:48

We had the same problem 2 times on two different computer, in just a few days of interval.

PgAdmin started to crash each time we open query builder.

Restarting the computer, reinstalling pgAdmin with differents versions... Nothing resolved the problem. But we found the solution to this problem!

PgAdmin uses a file where it saves the last queries (kind of history) and this file was probably corrupted (or one of the queries was).

This file is in the Application Data of your Windows User, that's why reinstalling pgAdmin doesn't work: this corrupted file is common for every postgres install.

So you just got to rename or delete the file pgadmin_histoqueries.xml located in your AppData (for us, D:\Documents and Settings\XXXXX\Application Data\postgresql) and relaunch pgAdmin, this should be OK.

@Erwin Brandstetter 2012-02-15 17:51:38

You just save me from a lot of headache. I started a bounty to award some extra credit.

@Jorge Vidinha 2015-09-29 17:51:42

I did the following and i solved the issue for me. Try the menu "View/Default View" so that if fixes each component's location. From…

@Kurt Koller 2016-02-11 17:25:45

Jorge - lifesaver, I had a non-drawing weirdly non-responsive query window, it started after I remote desktopped into my machine. It's normally a High DPI 4k display set at 150% scaling but over RDS was not. Clearly something got messed up, and View / Default View fixed it up nicely.

@Douglas 2019-08-12 22:03:09

Anyone know the location on Mac?

@Douglas 2019-08-14 20:22:09

If you are on a different configuration, you can get around the issue by creating a new server on the same server group and accessing the database from there. This isn't really a fix, but it does work just fine. Hope that helps someone!!

Related Questions

Sponsored Content

4 Answered Questions

[SOLVED] PgAdmin III -- how to merge output pane and query pane

  • 2017-05-22 15:25:34
  • dlb8685
  • 5462 View
  • 6 Score
  • 4 Answer
  • Tags:   pgadmin pgadmin-3

1 Answered Questions

[SOLVED] Cannot open `pg_hba.conf` in pgAdmin III

1 Answered Questions

[SOLVED] Is it possible to view a SQL query in the PgAdmin III Graphical Query Builder?

  • 2016-02-04 18:21:42
  • Charlie Hofmann
  • 1068 View
  • 1 Score
  • 1 Answer
  • Tags:   postgresql pgadmin

1 Answered Questions

[SOLVED] How can I speed up PgAdmin III Queries?

  • 2013-06-24 20:55:01
  • Robert H
  • 2660 View
  • 3 Score
  • 1 Answer
  • Tags:   postgresql pgadmin

2 Answered Questions

[SOLVED] Connect to PgAdmin III via localhost

  • 2014-07-13 07:01:56
  • Achede_HD
  • 36655 View
  • 3 Score
  • 2 Answer
  • Tags:   postgresql pgadmin

2 Answered Questions

[SOLVED] How to find the fitting version of pgadmin III?

2 Answered Questions

[SOLVED] PostgreSQL not working, pgAdmin always says server not listening

2 Answered Questions

[SOLVED] How does pgAdmin III build CREATE statements?

Sponsored Content