Thread: background process?

Is it possible to run an update in the background? I have an update to 23+ million records that will very likely take a
fewhours.<br />Is it possible to issue the update in PgAdmin, and then exit PgAdmin and have the update continue on the
server?<br/><br /><br /> 

On Sat, 2012-07-07 at 10:45 -0500, Michael Shapiro wrote:
> Is it possible to run an update in the background? I have an update to 23+
> million records that will very likely take a few hours.
> Is it possible to issue the update in PgAdmin, and then exit PgAdmin and
> have the update continue on the server?

No, that's not possible. As soon as you quit pgadmin, the connection is
dropped, and your statement is rollbacked.


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

Thanks. That's what I had thought, but I just wanted to make sure.<br />I'll use psql (or write a perl script).<br
/><br/><div class="gmail_quote">On Sat, Jul 7, 2012 at 11:24 AM, Guillaume Lelarge <span dir="ltr"><<a
href="mailto:guillaume@lelarge.info"target="_blank">guillaume@lelarge.info</a>></span> wrote:<br /><blockquote
class="gmail_quote"style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="HOEnZb"><div
class="h5">OnSat, 2012-07-07 at 10:45 -0500, Michael Shapiro wrote:<br /> > Is it possible to run an update in the
background?I have an update to 23+<br /> > million records that will very likely take a few hours.<br /> > Is it
possibleto issue the update in PgAdmin, and then exit PgAdmin and<br /> > have the update continue on the server?<br
/><br/></div></div>No, that's not possible. As soon as you quit pgadmin, the connection is dropped, and your statement
isrollbacked.<br /><span class="HOEnZb"><font color="#888888"><br /><br /> --<br /> Guillaume<br /><a
href="http://blog.guillaume.lelarge.info"target="_blank">http://blog.guillaume.lelarge.info</a><br /><a
href="http://www.dalibo.com"target="_blank">http://www.dalibo.com</a><br /><br /></font></span></blockquote></div><br
/>