Prevent loss of query text when pgAdmin crashes or freezes

From: Evan Martin <postgresql(at)realityexists(dot)net>
To: pgadmin-support(at)postgresql(dot)org
Subject: Prevent loss of query text when pgAdmin crashes or freezes
Date: 2012-07-02 02:32:40
Message-ID: 4FF10848.6020002@realityexists.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

I often have multiple SQL query windows open in pgAdmin (v1.14.3 on
Windows 7 x64). From time to time pgAdmin will crash or freeze (become
unresponsive) and would have to be killed. When this happens all unsaved
query text is lost, which is extremely frustrating. It's by far the
biggest problem for me in using pgAdmin.

Please implement some way to recover the query text from such crashes.
Ideally something like what Firefox or Chrome do: when restarted after a
crash they offer the option to restore previous windows (including form
data, at least in Chrome). This would require that pgAdmin saves query
text in the background on a regular basis (at least before running any
query).

Another great way to mitigate this would be to run each SQL query window
in a separate process, so it could crash without bringing down the rest.
However, the main pgAdmin process could crash, too, and this should not
kill the query window processes without allowing data to be saved.

Regards,

Evan

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Andrey Vinogradov 2012-07-02 11:04:31 default parameters
Previous Message Guillaume Lelarge 2012-06-29 20:06:08 Re: Compile Source Code