Обсуждение: query saved during crash

Поиск
Список
Период
Сортировка

query saved during crash

От
"Little, Douglas"
Дата:

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

Douglas.Little@orbitz.com

 cid:image001.jpg@01CABEC8.D4980670  orbitz.com | ebookers.com | hotelclub.com | cheaptickets.com | ratestogo.com | asiahotels.com

 

Re: query saved during crash

От
Guillaume Lelarge
Дата:
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