Re: Prevent loss of query text when pgAdmin crashes or freezes

On Mon, Jul 2, 2012 at 9:44 PM, Guillaume Lelarge
<guillaume(at)lelarge(dot)info> wrote:
> On Mon, 2012-07-02 at 12:32 +1000, Evan Martin wrote:
>> 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.
>>
>
> I though we already had this in our TODO list, but I can't find it. So I
> added it.

I'd far rather see the bug fixed, but without any details that seems
tricky. FWIW, I use pgAdmin on Windows and Mac daily, and don't run
into crashes or hangs.

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company