Обсуждение: query saved during crash
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?
Thanks
Doug Little
Sr. Data Warehouse Architect | Business Intelligence Architecture | Orbitz Worldwide
500 W. Madison, Suite 1000 Chicago IL 60661| Office 312.260.2588 | Fax 312.894.5164 | Cell 847-997-5741
orbitz.com | ebookers.com | hotelclub.com | cheaptickets.com | ratestogo.com | asiahotels.com
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