Thread: Recovering SQL Files after pgAdmin crash
Sometimes my pgAdmin will crash. All files that are open are lost. Is there any way to make it behave like Evolution or firefox in that when I open it again it could say recover unsaved sql files or have it save a copy of unsaved files every few minutes so I will not loose all my unsaved work? -- Thank you for your time, Jason Long CEO and Chief Software Engineer BS Physics, MS Chemical Engineering http://www.octgsoftware.com HJBug Founder and President http://www.hjbug.com
On Sat, 2011-05-21 at 05:05 -0700, Francisco Leovey wrote:<br /><blockquote type="CITE"><table cellpadding="0" cellspacing="0"><tr><tdvalign="top"> what is the version of pgAdmin and on what platform is it running?<br /><br /> --- On<b>Fri, 5/20/11, Jason Long </b><b><i><jason@octgsoftware.com></i></b> wrote:<br /><blockquote><br /> From: JasonLong <jason@octgsoftware.com><br /> Subject: [pgadmin-support] Recovering SQL Files after pgAdmin crash<br />To: pgadmin-support@postgresql.org<br /> Date: Friday, May 20, 2011, 7:40 PM<br /><br /></blockquote><blockquote> Sometimesmy pgAdmin will crash. All files that are open are lost.<br /><br /> Is there any way to make it behave like Evolutionor firefox in that<br /> when I open it again it could say recover unsaved sql files or have it<br /> save a copyof unsaved files every few minutes so I will not loose all<br /> my unsaved work?<br /><br /> -- <br /> Thank you foryour time,<br /><br /> Jason Long<br /> CEO and Chief Software Engineer<br /> BS Physics, MS Chemical Engineering<br /><ahref="http://www.octgsoftware.com/">http://www.octgsoftware.com</a><br /> HJBug Founder and President<br /><a href="http://www.hjbug.com/">http://www.hjbug.com</a><br/><br /><br /> -- <br /> Sent via pgadmin-support mailing list (<a href="http://us.mc393.mail.yahoo.com/mc/compose?to=pgadmin-support@postgresql.org">pgadmin-support@postgresql.org</a>)<br />To make changes to your subscription:<br /><a href="http://www.postgresql.org/mailpref/pgadmin-support">http://www.postgresql.org/mailpref/pgadmin-support</a><br /><br/></blockquote></td></tr></table></blockquote><br /> I am using 1.12.2 on Fedora 14 x64.<br /><br /> This mainly happenswhen I restart postgres and then try to do something in pgAdmin.<br /><br /> It will ask if I want to reconnect andthen crash. I crashed occasionally for other unknown reasons, but that is fairly rare.<br /><br /> I would really likeit to act like Open Office and ask if I want to recover the open SQL windows.
On 05/21/2011 07:30 PM, Jason Long wrote: > On Sat, 2011-05-21 at 05:05 -0700, Francisco Leovey wrote: > >> what is the version of pgAdmin and on what platform is it running? >> >> --- On Fri, 5/20/11, Jason Long <jason@octgsoftware.com> wrote: >> > [...] > I am using 1.12.2 on Fedora 14 x64. > > This mainly happens when I restart postgres and then try to do something > in pgAdmin. > > It will ask if I want to reconnect and then crash. I crashed > occasionally for other unknown reasons, but that is fairly rare. > > I would really like it to act like Open Office and ask if I want to > recover the open SQL windows. > There's no option right now that would allow the query tool to reopen old SQL windows. But it could be a nice thing to add in a future release. -- Guillaumehttp://www.postgresql.frhttp://dalibo.com