Thread: query saved during crash

<div class="WordSection1"><p class="MsoNormal">Pgadmin crashes on me a lot because the connection to the db has been
severedby  the network for inactivity. <p class="MsoNormal">Often, I’ve been working on a query and have not yet saved
thequery. <p class="MsoNormal"> <p class="MsoNormal">Is there any place the active queries are cached on disk that I
mightbe able to recover from?<p class="MsoNormal"> <p class="MsoNormal">Thanks<p class="MsoNormal"> <p
class="MsoNormal"> <pclass="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">Doug
Little</span></b><pclass="MsoNormal"><b><span style="font-size:12.0pt"> </span></b><p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Arial","sans-serif"">Sr.Data Warehouse Architect | Business Intelligence
Architecture| Orbitz Worldwide </span><p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Arial","sans-serif"">500W. Madison, Suite 1000  Chicago IL 60661| Office
312.260.2588 |Fax 312.894.5164 | Cell 847-997-5741</span><span style="font-size:12.0pt;font-family:"Times New
Roman","serif""></span><pclass="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif""><a
href="mailto:Douglas.Little@orbitz.com"title="mailto:dlittle@orbitz.com"><b><span
style="color:blue">Douglas.Little@orbitz.com</span></b></a></span><b><u><spanstyle="font-size:13.5pt;font-family:"Times
NewRoman","serif";color:blue"></span></u></b><p class="MsoNormal"> <img alt="cid:image001.jpg@01CABEC8.D4980670"
border="0"height="61" id="Picture_x0020_1" src="cid:image001.jpg@01CE0AC2.ADE1E980" width="83" />  <a
href="http://www.orbitz.com/"title="http://www.orbitz.com/"><span
style="font-size:8.0pt;font-family:"Arial","sans-serif";color:blue">orbitz.com</span></a><span
style="color:blue">|</span><a href="http://www.ebookers.com/" title="http://www.ebookers.com/"><span
style="font-size:8.0pt;font-family:"Arial","sans-serif";color:blue">ebookers.com</span></a><span
style="color:blue">|</span><a href="http://www.hotelclub.com/" title="http://www.hotelclub.com/"><span
style="font-size:8.0pt;font-family:"Arial","sans-serif";color:blue">hotelclub.com</span></a><span
style="color:blue">|</span><a href="http://www.cheaptickets.com/" title="http://www.cheaptickets.com/"><span
style="font-size:8.0pt;font-family:"Arial","sans-serif";color:blue">cheaptickets.com</span></a><span
style="color:blue">|</span><a href="http://www.ratestogo.com/" title="http://www.ratestogo.com/"><span
style="font-size:8.0pt;font-family:"Arial","sans-serif";color:blue">ratestogo.com</span></a><spanstyle="color:blue">
|</span><a href="http://www.asiahotels.com/" title="http://www.asiahotels.com/"><span
style="font-size:8.0pt;font-family:"Arial","sans-serif";color:blue">asiahotels.com</span></a><p
class="MsoNormal"> </div>

On Thu, 2013-02-14 at 14:50 -0600, Little, Douglas wrote:
> Pgadmin crashes on me a lot because the connection to the db has been severed by  the network for inactivity.
> Often, I've been working on a query and have not yet saved the query.
> 
> Is there any place the active queries are cached on disk that I might be able to recover from?
> 

Nope.

There's a ticket on this issue
(http://code.pgadmin.org/trac/ticket/366). The idea would be to save
every queries before executing them. After a crash, pgAdmin would be
able to see that it crashed and would re-open the query tools with their
respective queries. That's the theory, now we need a patch to make it
happen :)


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com