| From: | Michael Shapiro <mshapiro51(at)gmail(dot)com> |
|---|---|
| To: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
| Cc: | PgAdmin Support <pgadmin-support(at)postgresql(dot)org> |
| Subject: | Re: background process? |
| Date: | 2012-07-07 17:05:02 |
| Message-ID: | CAGCvxeYX+39XfFu_9NNtiM_XAzDuXpcXg9KZOOwx_W+85ht-QQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
Thanks. That's what I had thought, but I just wanted to make sure.
I'll use psql (or write a perl script).
On Sat, Jul 7, 2012 at 11:24 AM, Guillaume Lelarge
<guillaume(at)lelarge(dot)info>wrote:
> 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
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vjacheslav A. | 2012-07-08 15:18:56 | pgScript error when relation name contains ")" symbol |
| Previous Message | Guillaume Lelarge | 2012-07-07 16:24:28 | Re: background process? |